public ActionResult Customer()
{
var model = new ReportCustomerSearchViewModel();
List <ReportCustomerListViewModel> list = new List <ReportCustomerListViewModel>();
model.ReportCustomerList = list.ToPagedList(model.Page ?? 1, 20);
return(View(model));
}
public ActionResult Customer(ReportCustomerSearchViewModel model)
{
if (ModelState.IsValid)
{
string sql = "select msg_S_0088 as Id,#msg_S_0158 as EvrakCinsId,msg_S_0089 as Tarih,msg_S_0090 as EvrakSeri,msg_S_0091 as EvrakSira,msg_S_0094 as EvrakTip,msg_S_0003 as EvrakCinsi,msg_S_0098 as VadeTarih,#msg_S_0165 as Miktar,msg_S_0100 as BA,[msg_S_0101\\T] as Borc,[msg_S_0102\\T] as Alacak,msg_S_0115 as KarsiHesapIsmi from dbo.fn_CariFoy (N'0',0,'" + model.CariKod + "',NULL,'" + model.DevirDate + "','" + model.startDate + "','" + model.endDate + "',0,N'')";
int pageIndex = model.Page ?? 1;
var data = _viewCustomerReportORM.GetList(sql);
List <ReportCustomerListViewModel> list = new List <ReportCustomerListViewModel>();
if (data.Count > 0)
{
foreach (var item in data)
{
ReportCustomerListViewModel cus = new ReportCustomerListViewModel();
cus.Alacak = item.Alacak;
cus.Borc = item.Borc;
cus.BA = item.BA;
cus.EvrakCinsi = item.EvrakCinsi;
cus.EvrakCinsId = item.EvrakCinsId;
cus.EvrakSeri = item.EvrakSeri;
cus.EvrakSira = item.EvrakSira;
cus.EvrakTip = item.EvrakTip;
cus.Id = item.Id;
cus.KarsiHesapIsmi = item.KarsiHesapIsmi;
cus.Miktar = item.Miktar;
cus.Tarih = item.Tarih;
cus.VadeTarih = item.VadeTarih;
list.Add(cus);
}
}
model.ReportCustomerList = list.ToPagedList(pageIndex, 10);
if (Request.IsAjaxRequest())
{
return(PartialView("_reportcustomerlist", model));
}
return(View(model));
}
return(View(model));
}