Hi,
I have one table with fields
ItemId ItemName Date
1 a 2/2/2019
1 b 3/2/2019
I have 3 filters Item Grom date and Tdate
Intitally after clicking of go button i am getting based upon above filters some records on grid view
I need to display filter range variables in Grid view based upon From date and todate range
I have selected from date:1/2/2019 and ToDate:6/2/2019
My expeted o/p on screen
ItemId ItemName Date
1 a 1/2/19 2/2/2019 3/3/2019 4/2/2019 5/2/2019 6/2/2019
2 b 1/2/19 2/2/2019 3/3/2019 4/2/2019 5/2/2019 6/2/2019
Based upon 2 dates i am getting dates coulms in date header
Could you please help me
<html>
<head>
<title>Index</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script type="text/javascript" src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/angular.js/1.5.5/angular.js"></script>
<script type="text/javascript">
var app = angular.module('MyApp', []);
app.controller('MyController', function ($scope, $window) {
GetItems();
function GetItems() {
$scope.Items = [];
$http({
method: 'Get',
url: '/Home/GetReport/'
}).success(function (data, status, headers, config) {
$scope.Items = data;
// Adding All option.
$scope.Items.splice(0, 0, { Id: 0, Name: 'All' });
}).error(function (data, status, headers, config) {
$scope.message = 'Unexpected Error';
});
}
$scope.Go = function () {
var Id1 = $scope.Item;
var fd = $scope.FDate.toISOString().split('T')[0];
var td = $scope.TDate.toISOString().split('T')[0];
$.post("/attendanceentry/Edit/", { ItId: Id1, Fdate: fd, tdate: td }, function (r) {
$scope.items= [];
for (var i = 0; i < r.item.length; i++) {
var itemtry = {};
itemtry.ItemId= r.item[i].ItemId;
itemtry.ItemName = r.item[i].ItemName;
itemtry.Date = r.item[i].Date;
$scope.items.push(itemtry);
}
});
$scope.$apply();
}
});
</script>
<body ng-app="MyApp" ng-controller="MyController">
<div class="form-horizontal">
<div class="form-group">
<label for="ID" class="control-label col-xs-2">
Item</label>
<div class="col-md-2">
<select style="display: inline" data-ng-model="Item" class="form-control" data-ng-options="p.Id as p.Name for p in Items">
<option value="">-- Select Item --</option>
</select>
</div>
<div class="col-md-4">
<label for="FDate">
From Date</label>
<input type="date" ng-model="FDate" id="FDate" name="FDate" class="form-control"
required />
</div>
<div class="col-md-4">
<label for="lblTDate">
To Date</label>
<input type="date" ng-model="TDate" id="TDate" name="TDate" class="form-control"
required />
</div>
</div>
</div>
<div>
<button class="btn btn-success btn-sm" ng-model="IsVisible" ng-click="Go()">
<span class="glyphicon glyphicon-ok"></span>Submit
</button>
</div>
<div class="container" ng-show="IsVisible" id="printarea">
<table class="table table-bordered">
<tr class="success">
<th>Id</th>
<th>Item</th>
<th>Date</th>
</tr>
<tr ng-repeat="item in items">
<td>{{item.ItemId}}</td>
<td>{{item.ItemName}}</td>
<td>{{item.Date}}</td>
</tr>
</table>
</div>
</body>
</html>
[HttpPost]
public JsonResult Edit((int ItId,DateTime? Fdate, DateTime? tdate)
{
List<Item> ItemList = new List<Item>();
if(ItId==0){
var items = (from E in db.Item
where E.ItemId == ItId && (E.Date) >= Fdate && (E.Date) <= tdate
select new
{
E.ItemId,
E.ItemName,
E.Date
}).ToList();
foreach (var atten in items)
{
ItemList.Add(new Item { ItemId = atten.ItemId, ItemName = atten.Itemname, Date = atten.Date});
}
ItemEntryDetail details = new ItemEntryDetail();
details.item = ItemList;
return Json(details, JsonRequestBehavior.AllowGet);
}
else{
var items = (from E in db.Item
where (E.Date) >= Fdate && (E.Date) <= tdate
select new
{
E.ItemId,
E.ItemName,
E.Date
}).ToList();
foreach (var atten in items)
{
ItemList.Add(new Item { ItemId = atten.ItemId, ItemName = atten.Itemname, Date = atten.Date});
}
ItemEntryDetail details = new ItemEntryDetail();
details.item = ItemList;
return Json(details, JsonRequestBehavior.AllowGet);
}
}
