public ActionResult PaymentHistData(DTParameters param)
{
if (Request.IsAuthenticated)
{
try
{
string user_id = User.Identity.GetUserId();
var dtsource = new List <TransactionHistory>();//data source for payment history
using (BOSEMEntities dc = new BOSEMEntities())
{
if (isAdminUser())
{
dtsource = db.Database.SqlQuery <TransactionHistory>("select * from TransactionHistory where txn_id in (" +
"select distinct txn_id from requested_mark where txn_id is not NULL" +
") order by create_at desc").OrderByDescending(m => m.create_at).ToList();
}
else
{
dtsource = db.Database.SqlQuery <TransactionHistory>("select * from TransactionHistory where txn_id in (" +
"select distinct txn_id from requested_mark where txn_id is not NULL and user_id = '" + user_id + "'" +
") order by create_at desc").OrderByDescending(m => m.create_at).ToList();
}
}
List <String> columnSearch = new List <string>();
foreach (var col in param.Columns)
{
columnSearch.Add(col.Search.Value);
}
List <TransactionHistory> data = new ResultSet().GetTxnResult(param.Search.Value, param.SortOrder, param.Start, param.Length, dtsource, columnSearch);
List <TxnHistViewModel> new_data = new List <TxnHistViewModel>();
foreach (TransactionHistory row in data)
{
new_data.Add(new TxnHistViewModel(row));
}
int count = new ResultSet().TxnCount(param.Search.Value, dtsource, columnSearch);
DTResult <TxnHistViewModel> result = new DTResult <TxnHistViewModel>
{
draw = param.Draw,
data = new_data,
recordsFiltered = count,
recordsTotal = count
};
return(Json(result));
}
catch (Exception ex)
{
return(Json(new { error = ex.Message }));
}
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public ActionResult RequestHistData(DTParameters param)
{
if (Request.IsAuthenticated)
{
try
{
string user_id = User.Identity.GetUserId();
List <RequestHistories> dtsource = new List <RequestHistories>();//data source
using (BOSEMEntities dc = new BOSEMEntities())
{
dtsource = dc.RequestHistories.Where(m => m.user_id == user_id && m.payment_status != "unpaid").OrderByDescending(m => m.request_date).ToList();
}
List <String> columnSearch = new List <string>();
foreach (var col in param.Columns)
{
columnSearch.Add(col.Search.Value);
}
List <RequestHistories> data = new ResultSet().GetResult(param.Search.Value, param.SortOrder, param.Start, param.Length, dtsource, columnSearch, user_id);
List <RequestHistModel> new_data = new List <RequestHistModel>();
foreach (RequestHistories row_data in data)
{
new_data.Add(new RequestHistModel(row_data));
}
int count = new ResultSet().Count(param.Search.Value, dtsource, columnSearch, user_id);
DTResult <RequestHistModel> result = new DTResult <RequestHistModel>
{
draw = param.Draw,
data = new_data,
recordsFiltered = count,
recordsTotal = count
};
return(Json(result));
}
catch (Exception ex)
{
return(Json(new { error = ex.Message }));
}
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
