//Banka Hareketleri
public ActionResult BankList()
{
var model = new ReportBankSearchViewModel();
List <ReportBankListViewModel> list = new List <ReportBankListViewModel>();
model.ReportBankList = list.ToPagedList(model.Page ?? 1, 20);
return(View(model));
}
public ActionResult BankList(ReportBankSearchViewModel model)
{
if (ModelState.IsValid)
{
string sql = "Select msg_S_0088 as Id,msg_S_0089 as Tarih,msg_S_0090 as EvrakSeri,msg_S_0091 as EvrakSira,msg_S_0094 as EvrakTip,msg_S_0003 as Cinsi,#msg_S_0158 as Vade,msg_S_0100 as BorcAlacak,[msg_S_0101\\T] as Borc,[msg_S_0102\\T] as Alacak,[#msg_S_0103\\T] as Tutar,[msg_S_0114] as Hesapismi from dbo.fn_CariFoy (N'0',2,N'" + model.BankaKod + "',1,'" + model.DevirDate + "','" + model.startDate + "','" + model.endDate + "',0,N'')";
int pageIndex = model.Page ?? 1;
var data = _viewBankReportORM.GetList(sql);
List <ReportBankListViewModel> list = new List <ReportBankListViewModel>();
if (data.Count > 0)
{
foreach (var item in data)
{
ReportBankListViewModel cus = new ReportBankListViewModel();
cus.Alacak = item.Alacak;
cus.Borc = item.Borc;
cus.BorcAlacak = item.BorcAlacak;
cus.EvrakSeri = item.EvrakSeri;
cus.EvrakSira = item.EvrakSira;
cus.EvrakTip = item.EvrakTip;
cus.HesapIsmi = item.HesapIsmi;
cus.Tarih = item.Tarih;
cus.Vade = item.Vade;
list.Add(cus);
}
}
model.ReportBankList = list.ToPagedList(pageIndex, 10);
if (Request.IsAjaxRequest())
{
return(PartialView("_reportbanklist", model));
}
return(View(model));
}
return(View(model));
}
