public async Task <IActionResult> Filter(ListInsuranceViewModel md, string ddlAgent, int?ddlSupervisior, int?ddlPishkhan)
{
ListInsuranceViewModel model = new ListInsuranceViewModel();
FilterItemsViewModel filter = new FilterItemsViewModel();
filter = md.FilterItemsVM;
filter.AgentID = ddlAgent;
filter.PishkhanID = ddlPishkhan;
filter.SupervisiorID = ddlSupervisior;
//کاربر هیچ اطلاعاتی برای فیلتر کردن وارد ننموده
if (filter.AgentID == "0" && filter.SupervisiorID == 0 && filter.PishkhanID == 0 && filter.InsuranceNumber == null && filter.BimegozarName == null && filter.BimegozarPhone == null && filter.BimeshodeName == null && filter.BimeshodePhone == null && filter.FromDate_Soodoor == null && filter.FromDate_Start == null && filter.InsuranceSerial == null && filter.ToDate_Soodoor == null && filter.ToDate_Start == null)
{
ViewBag.pm = "لطفا یک آیتم برای فیلتر انتخاب نمایید";
}
//ارسال اطلاعات به مادل برای جستجو در دیتابیس
else
{
ViewBag.pm = "";
var result = _service.TblLifeInsurance.GetInsuranceList(true, 0, 0, filter);
foreach (var item in result)
{
TabelItemsViewModel vm = new TabelItemsViewModel();
vm.Agent = item.TblUser.Name;
vm.BimegozarName = item.Bimegozar_Name;
vm.BimegozarPhone = item.Bimegozar_Phone;
vm.BimeshodeName = item.Bimeshode_Name;
vm.BimeshodePhon = item.Bimeshode_Phone;
vm.DateSoodoor = item.Date_Soodoor_Shamsi;
vm.DateStart = item.Date_Soodoor_Shamsi;
vm.ID = item.ID;
vm.InsuranceNumber = item.InsuranceNumber_Code + "/" + item.InsuranceNumber_CenterCode + "/" + item.InsuranceNumber_GarardadNumber + "/" + item.InsuranceNumber_Year + "/" + item.InsuranceNumber_Number;
vm.PaymentType = item.PaymentType;
vm.Price = item.Payment_Price;
vm.Status = item.Insurance_Status;
try
{
vm.Supervisior = item.TblSupervisior.Name;
}
catch { }
try
{
vm.Pishkhan = item.TblPishkhan.Name;
}
catch { }
model.TabelItemsVM.Add(vm);
}
}
//-----------------------------------------------------------------------------------------------------------
//return items
//Get Agent , pishkhan , supervisior List
var _agentList = _user.GetAgentListAsync();
var _pishkhanList = _service.TblPishkhan.GetAll();
var _supervisiorList = _service.TblSupervisior.GetAll();
var _countTotalRow = _service.TblLifeInsurance.GetTotalCount();
var agentList = await _agentList;
var pishkhanList = await _pishkhanList;
var supervisiorList = await _supervisiorList;
var countTotalRow = await _countTotalRow;
//Fill DropdownList ViewModel
foreach (var item in agentList)
{
AgentListViewModel vm = new AgentListViewModel();
vm.ID = item.Id;
vm.Name = item.Name;
model.AgentListVM.Add(vm);
}
foreach (var item in pishkhanList)
{
PishkhanListViewModel vm = new PishkhanListViewModel();
vm.ID = item.ID;
vm.Name = item.Name;
model.PishkhanListVM.Add(vm);
}
foreach (var item in supervisiorList)
{
SupervisiorListViewModel vm = new SupervisiorListViewModel();
vm.ID = item.ID;
vm.Name = item.Name;
model.SupervisiorListVM.Add(vm);
}
//Fill Tabel Items
model.Take = 0;
model.Skip = 0;
return(View("List", model));
}
public async Task <IActionResult> List()
{
ListInsuranceViewModel model = new ListInsuranceViewModel();
//Get Agent , pishkhan , supervisior List
var _agentList = _user.GetAgentListAsync();
var _pishkhanList = _service.TblPishkhan.GetAll();
var _supervisiorList = _service.TblSupervisior.GetAll();
var _countTotalRow = _service.TblLifeInsurance.GetTotalCount();
var agentList = await _agentList;
var pishkhanList = await _pishkhanList;
var supervisiorList = await _supervisiorList;
var countTotalRow = await _countTotalRow;
//Fill DropdownList ViewModel
foreach (var item in agentList)
{
AgentListViewModel vm = new AgentListViewModel();
vm.ID = item.Id;
vm.Name = item.Name;
model.AgentListVM.Add(vm);
}
foreach (var item in pishkhanList)
{
PishkhanListViewModel vm = new PishkhanListViewModel();
vm.ID = item.ID;
vm.Name = item.Name;
model.PishkhanListVM.Add(vm);
}
foreach (var item in supervisiorList)
{
SupervisiorListViewModel vm = new SupervisiorListViewModel();
vm.ID = item.ID;
vm.Name = item.Name;
model.SupervisiorListVM.Add(vm);
}
//Fill Tabel Items
model.Take = 20;
model.Skip = 0;
var _take = _service.TblSetting.GetFirst();
var take = await _take;
if (take != null)
{
model.Take = take.CountTakeItem;
}
//Get Info From Database
var result = (_service.TblLifeInsurance.GetInsuranceList(false, model.Skip, model.Take, model.FilterItemsVM)).ToList();
//Fill Count TotalRow
model.CountTotalRow = countTotalRow;
model.CountRow = result.Count;
foreach (var item in result)
{
TabelItemsViewModel vm = new TabelItemsViewModel();
vm.Agent = item.TblUser.Name;
vm.BimegozarName = item.Bimegozar_Name;
vm.BimegozarPhone = item.Bimegozar_Phone;
vm.BimeshodeName = item.Bimeshode_Name;
vm.BimeshodePhon = item.Bimeshode_Phone;
vm.DateSoodoor = item.Date_Soodoor_Shamsi;
vm.DateStart = item.Date_Soodoor_Shamsi;
vm.ID = item.ID;
vm.InsuranceNumber = item.InsuranceNumber_Code + "/" + item.InsuranceNumber_CenterCode + "/" + item.InsuranceNumber_GarardadNumber + "/" + item.InsuranceNumber_Year + "/" + item.InsuranceNumber_Number;
vm.PaymentType = item.PaymentType;
vm.Price = item.Payment_Price;
vm.Status = item.Insurance_Status;
try
{
vm.Supervisior = item.TblSupervisior.Name;
}
catch { }
try
{
vm.Pishkhan = item.TblPishkhan.Name;
}
catch { }
try {
if (item.TarikhSabtBimename.Year < 2000)
{
vm.TarikhSabtBimename = "";
}
else
{
vm.TarikhSabtBimename = item.TarikhSabtBimename.DateToShamsi();
}
}
catch {
vm.TarikhSabtBimename = "";
}
model.TabelItemsVM.Add(vm);
}
return(View(model));
}
