/// <summary>
/// 分页
/// </summary>
/// <param name="Id"></param>
/// <param name="usercode"></param>
/// <param name="Level"></param>
/// <param name="Strat"></param>
/// <param name="End"></param>
/// <param name="i">I为0就是查询未开通</param>
/// <param name="pageIndex"></param>
/// <returns></returns>
public PartialViewResult MemberGetPage(string Id, string usercode, DateTime?Strat, DateTime?End, int i, int pageIndex = 1)
{
AgentListViewModel model = new AgentListViewModel();
AgentSearchResult result = agentServeice.GetAgentList(Id, usercode, Strat, End, pageIndex, pageSize, i);
model.AgentListDTO = result.AgentList;
//分页
Pagination pager = new Pagination();
pager.PageIndex = pageIndex;
pager.PageSize = pageSize;
pager.TotalCount = result.TotalCount;
if (result.TotalCount <= pageSize)
{
model.Page = "";
}
else
{
model.Page = pager.GetPagerHtml();
}
string Table = "";
if (i == 0)
{
Table = "AgentPage";
}
else
{
Table = "AgentListPage";
}
return(PartialView(Table, model));
//return Json(new AjaxResult { Status = "1", Data = model });
}
/// <summary>
/// 查询状态--表内有数据
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult GetAgentState(int id) //还差钱没扣,还要查询一下状态
{
AgentListViewModel model = new AgentListViewModel();
AgentListDTO Agent = new AgentListDTO();
model.Agent = AgentServeice.GetAgentName(GetUserInfo().UserCode).AgentList;
if (model.Agent.Length > 0)
{
model.AgentList = model.Agent.First();
if (model.AgentList.Flag == 0)
{
return(Json(new AjaxResult {
Status = "1", Msg = "提交的申请未审批,请耐心等待"
}));
}
else if (model.AgentList.Flag == 1)
{
return(Json(new AjaxResult {
Status = "1", Msg = "当前已经是报单中心"
}));
}
else if (model.AgentList.Flag == 2)
{
return(Json(new AjaxResult {
Status = "1", Msg = "当前报单中心已被冻结"
}));
}
}
return(Json(new AjaxResult {
Status = "1", Msg = "您还不是报单中心"
}));
}
////-------------------------------------------------------------------
public ActionResult AgentList(int pageIndex = 1)
{
ViewBag.hard_value = new List <SelectListItem>()
{
new SelectListItem()
{
Value = "0", Text = "--请选择--"
},
new SelectListItem()
{
Value = "1", Text = "会员编号"
},
};
AgentListViewModel model = new AgentListViewModel();
//分页
Pagination pager = new Pagination();
pager.PageIndex = pageIndex;
pager.PageSize = pageSize;
pager.TotalCount = agentServeice.GetAgentList("0", "", null, null, pageIndex, pageSize, 2).TotalCount;
if (pager.TotalCount <= pageSize)
{
model.Page = "";
}
else
{
model.Page = pager.GetPagerHtml();
}
model.AgentListDTO = agentServeice.GetAgentList("0", "", null, null, pageIndex, pageSize, 2).AgentList;
return(PartialView("AgentListPage", model));
}
/// <summary>
/// AgentLevel的控制器
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public ActionResult AgentLevel(string name = "system") //还差钱没扣
{
AgentListViewModel model = new AgentListViewModel();
model.Member = Member.ToUser((int)GetLoginID()).MemberList.First();//查询这个人的信息 ，只要GetUserInfo().UserCode
if (AgentServeice.GetAgentName(name).AgentList.Length <= 0)
{
return(View(model));
}
else
{
model.AgentList = AgentServeice.GetAgentName(name).AgentList.First();;
return(View(model));
}
}
// GET: Agents Details
public ActionResult Details(int agentId)
{
Context _context = new Context();
AgentListViewModel agentList = new AgentListViewModel();
agentList.Agents = (from ag in _context.Agent
where ag.AgentId == agentId
join inv in _context.Invoice
on ag.AgentId equals inv.AgentId
join inp in _context.IndividualPiece
on inv.IndividualPieceId equals inp.IndividualPieceId
orderby ag.AgentId
select new AgentDetailViewModel
{
AgentId = ag.AgentId,
FirstName = ag.FirstName,
LastName = ag.LastName,
Location = ag.Location,
Address = ag.Address,
PhoneNumber = ag.PhoneNumber,
Active = ag.Active,
InvoiceId = inv.InvoiceId,
IndividualPieceId = inp.IndividualPieceId,
Cost = inp.Cost,
Price = inp.Price,
Profit = inp.Price - inp.Cost
}).ToList();
decimal totalProfit = 0;
for (var i = 0; i < agentList.Agents.Count; i++)
{
totalProfit += agentList.Agents[i].Profit;
}
agentList.TotalProfit = totalProfit;
return(View(agentList));
}
public PartialViewResult Agent_Page(string Id, string usercode, DateTime?Strat, DateTime?End, int i, int pageIndex = 1)
{
AgentListViewModel model = new AgentListViewModel();
AgentSearchResult result = agentServeice.GetAgentList(Id, usercode, Strat, End, pageIndex, pageSize, i);
model.AgentListDTO = result.AgentList;
//分页
Pagination pager = new Pagination();
pager.PageIndex = pageIndex;
pager.PageSize = pageSize;
pager.TotalCount = result.TotalCount;
if (result.TotalCount <= pageSize)
{
model.Page = "";
}
else
{
model.Page = pager.GetPagerHtml();
}
return(PartialView("AgentPage", model));
}
/// <summary>
/// 提交
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Agent_btn(int id) //提交
{
//先查有没有数据 在查是否为待激活状态 ，激活状态，然后在插入申请
AgentListViewModel model = new AgentListViewModel();
AgentListDTO Agent = new AgentListDTO();
model.Agent = AgentServeice.GetAgentName(GetUserInfo().UserCode).AgentList;
if (model.Agent.Length > 0)
{
model.AgentList = model.Agent.First();
if (model.AgentList.AgentType != 2)
{
return(Json(new AjaxResult {
Status = "1", Msg = "提交的申请未审批,请耐心等待"
}));
}
return(Json(new AjaxResult {
Status = "1", Msg = "该报单中心已存在"
}));
}
Agent.AgentCode = GetUserInfo().UserCode;
Agent.Flag = 0;//等待审核
Agent.UserID = GetLoginID();
Agent.AgentType = 1;
Agent.CreateTime = DateTime.Now;
long i = AgentServeice.Add(Agent);
if (i > 0)
{
return(Json(new AjaxResult {
Status = "1", Msg = "申请成功"
}));
}
return(Json(new AjaxResult {
Status = "0", Msg = "申请失败"
}));
}
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));
}
