paymenttblsViewModel GetViewModel(int pageIndex, string whereName)
{
paymenttblsViewModel model = new paymenttblsViewModel();
var data = db.paymenttbl.Select(x => new RequestPay
{
payid = x.payid,
mid = x.mid,
name = x.name,
phone = x.phone,
addr = x.addr,
pay = x.payid,
paydate = x.paydate,
memo = x.memo
}).OrderBy(x => x.mid);
if (!string.IsNullOrEmpty(whereName))
{
model = new paymenttblsViewModel
{
RequestPay = data.Where(x => x.name.Contains(whereName)).ToPagedList(pageIndex, l_pageSize),
PageIndex = pageIndex
};
}
else
{
model = new paymenttblsViewModel
{
RequestPay = data.ToPagedList(pageIndex, l_pageSize),
PageIndex = pageIndex
};
}
return(model);
}
public ActionResult Index(paymenttblsViewModel model)
{
if (string.IsNullOrEmpty(model.SelectPay.name))
{
model = GetViewModel(1, string.Empty);
}
else
{
model = GetViewModel(1, model.SelectPay.name);
}
return(View(model));
}
public ActionResult DeleteCheck(RequestPay model)
{
paymenttbl paymenttbl = new paymenttbl();
paymenttbl.payid = model.payid;
paymenttbl.mid = model.mid;
paymenttbl.name = model.name;
paymenttbl.phone = model.phone;
paymenttbl.addr = model.addr;
paymenttbl.pay = model.payid;
paymenttbl.paydate = model.paydate;
paymenttbl.memo = model.memo;
db.Entry(paymenttbl).State = System.Data.Entity.EntityState.Deleted;
db.paymenttbl.Remove(paymenttbl);
db.SaveChanges();
var data = db.paymenttbl.Where(x => x.payid.Equals(paymenttbl.payid)).Select(x => new RequestPay
{
payid = x.payid,
mid = x.mid,
name = x.name,
phone = x.phone,
addr = x.addr,
pay = x.payid,
paydate = x.paydate,
memo = x.memo
}).OrderBy(x => x.payid).ToPagedList(1, l_pageSize);
var viewModel = new paymenttblsViewModel
{
RequestPay = data,
PageIndex = 1
};
return(View("Index", viewModel));
}
