public JsonResult GetPaymentListByLocation(string _search, long?UserId, long?locationId, int?rows = 20, int?page = 1, int?TotalRecords = 10, string sord = null, string txtSearch = null, string sidx = null, string UserType = null)
{
eTracLoginModel ObjLoginModel = null;
long MISNumber = 0;
if (Session["eTrac"] != null)
{
ObjLoginModel = (eTracLoginModel)(Session["eTrac"]);
if (locationId == null)
{
locationId = ObjLoginModel.LocationID;
}
UserId = ObjLoginModel.UserId;
}
JQGridResults result = new JQGridResults();
List <JQGridRow> rowss = new List <JQGridRow>();
sord = string.IsNullOrEmpty(sord) ? "desc" : sord;
sidx = string.IsNullOrEmpty(sidx) ? "UserEmail" : sidx;
txtSearch = string.IsNullOrEmpty(txtSearch) ? "" : txtSearch; //UserType = Convert.ToInt64(Helper.UserType.ITAdministrator);
try
{
locationId = 0;//Need to fetch all data
var paymentList = _IPaymentManager.GetListPaymentByLocationId(UserId, locationId, rows, TotalRecords, sidx, sord, locationId, txtSearch, UserType);
foreach (var payment in paymentList.rows)
{
if (payment.BillNo != null)
{
JQGridRow row = new JQGridRow();
row.id = Cryptography.GetEncryptedData(Convert.ToString(payment.BillNo), true);
row.cell = new string[14];
row.cell[0] = payment.BillNo.ToString();
row.cell[1] = payment.LocationName == null ? "N/A" : payment.LocationName;
row.cell[2] = payment.VendorName == null ? "N/A" : payment.VendorName;
row.cell[3] = payment.OperatingCompany == null ? "N/A" : payment.OperatingCompany;
row.cell[4] = payment.BillType == null ? "N/A" : payment.BillType;
row.cell[5] = payment.BillAmount.ToString();
row.cell[6] = payment.BillDate.ToString();
row.cell[7] = payment.GracePeriod == null ? "N/A" : payment.GracePeriod.ToString();
row.cell[8] = (payment.PaymentMode == null && payment.BillType == "MIS") ? "MISC" : (payment.PaymentMode == null && payment.BillType == "ManualBill") ? "ManualBill" : payment.PaymentMode.ToString();
row.cell[9] = payment.Status.ToString();
row.cell[10] = payment.VendorId > 0 ? payment.VendorId.ToString() : "0";
row.cell[11] = payment.OperatingCompanyId > 0 ? payment.OperatingCompanyId.ToString() : "0";
row.cell[12] = payment.LocationId > 0 ? payment.LocationId.ToString() : "0";
row.cell[13] = payment.LLBL_ID.ToString();
rowss.Add(row);
}
}
result.rows = rowss.ToArray();
result.page = Convert.ToInt32(page);
result.total = (int)Math.Ceiling((decimal)Convert.ToInt32(TotalRecords.Value) / rows.Value);
result.records = Convert.ToInt32(TotalRecords.Value);
}
catch (Exception ex)
{ return(Json(ex.Message, JsonRequestBehavior.AllowGet)); }
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult GetPaymentListByLocation(string _search, long?UserId, long?locationId, int?rows = 20, int?page = 1, int?TotalRecords = 10, string sord = null, string txtSearch = null, string sidx = null, string UserType = null, string BillTypeId = null)
{
eTracLoginModel ObjLoginModel = null;
long MISNumber = 0;
if (Session["eTrac"] != null)
{
ObjLoginModel = (eTracLoginModel)(Session["eTrac"]);
if (locationId == null)
{
locationId = ObjLoginModel.LocationID;
}
UserId = ObjLoginModel.UserId;
}
ViewBag.PaymentModeList = _IVendorManagement.PaymentModeList();
try
{
locationId = 0; //Need to fetch all data // it was previously done need to be discussed
if (BillTypeId == "0") // Logic :to show all data
{
BillTypeId = null;
}
if (!string.IsNullOrEmpty(txtSearch))
{
var paymentList = _IPaymentManager.GetListPaymentByLocationId(UserId, locationId, rows, TotalRecords, sidx, sord, locationId, txtSearch, UserType, BillTypeId).Where(x => !String.IsNullOrEmpty(x.VendorName));
var FilterList = paymentList.Where(X => X.VendorName.ToLower().Contains(txtSearch.ToLower())).ToList();
return(Json(FilterList.ToList(), JsonRequestBehavior.AllowGet));
}
else
{
var paymentList = _IPaymentManager.GetListPaymentByLocationId(UserId, locationId, rows, TotalRecords, sidx, sord, locationId, txtSearch, UserType, BillTypeId);
return(Json(paymentList.ToList(), JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
//JQGridResults result = new JQGridResults();
//List<JQGridRow> rowss = new List<JQGridRow>();
//sord = string.IsNullOrEmpty(sord) ? "desc" : sord;
//sidx = string.IsNullOrEmpty(sidx) ? "UserEmail" : sidx;
//txtSearch = string.IsNullOrEmpty(txtSearch) ? "" : txtSearch; //UserType = Convert.ToInt64(Helper.UserType.ITAdministrator);
//try
//{
// locationId = 0;//Need to fetch all data
// var paymentList = _IPaymentManager.GetListPaymentByLocationId(UserId, locationId, rows, TotalRecords, sidx, sord, locationId, txtSearch, UserType);
// foreach (var payment in paymentList.rows)
// {
// if (payment.BillNo != null)
// {
// JQGridRow row = new JQGridRow();
// row.id = Cryptography.GetEncryptedData(Convert.ToString(payment.BillNo), true);
// row.cell = new string[14];
// row.cell[0] = payment.BillNo.ToString();
// row.cell[1] = payment.LocationName == null ? "N/A" : payment.LocationName;
// row.cell[2] = payment.VendorName == null ? "N/A" : payment.VendorName;
// row.cell[3] = payment.OperatingCompany == null ? "N/A" : payment.OperatingCompany;
// row.cell[4] = payment.BillType == null ? "N/A" : payment.BillType;
// row.cell[5] = payment.BillAmount.ToString();
// row.cell[6] = payment.BillDate.ToString();
// row.cell[7] = payment.GracePeriod == null ? "N/A" : payment.GracePeriod.ToString();
// row.cell[8] = (payment.PaymentMode == null && payment.BillType == "MIS") ? "MISC" : (payment.PaymentMode == null && payment.BillType == "ManualBill") ? "ManualBill" : payment.PaymentMode.ToString();
// row.cell[9] = payment.Status.ToString();
// row.cell[10] = payment.VendorId > 0 ? payment.VendorId.ToString() : "0";
// row.cell[11] = payment.OperatingCompanyId > 0 ? payment.OperatingCompanyId.ToString() : "0";
// row.cell[12] = payment.LocationId > 0 ? payment.LocationId.ToString() : "0";
// row.cell[13] = payment.LLBL_ID.ToString();
// rowss.Add(row);
// }
// }
// result.rows = rowss.ToArray();
// result.page = Convert.ToInt32(page);
// result.total = (int)Math.Ceiling((decimal)Convert.ToInt32(TotalRecords.Value) / rows.Value);
// result.records = Convert.ToInt32(TotalRecords.Value);
//}
//catch (Exception ex)
//{ return Json(ex.Message, JsonRequestBehavior.AllowGet); }
}
