public ActionResult AddCrm() { var model = new CrmCustomerViewModel(); model.il_sorumlu_personelList = GetsorumluPersonel(); return(View(model)); }
public JsonResult LoadCustomer(int id) { Response response; try { CrmCustomer item; using (var db = new KiaGalleryContext()) { item = db.CrmCustomer.FirstOrDefault(x => x.Id == id); var list = new CrmCustomerViewModel { id = item.Id, fullName = item.FullName, phoneNumber = item.PhoneNumber, factorNumber = item.FactorNumber, buyType = item.BuyType, buyTypeOnline = item.BuyTypeOnline, buyTypeSubset = item.BuyTypeSubset, score = item.Score, date = DateUtility.GetPersianDate(item.Date), answerList = item.CrmCustomerAnswerList.Select(x => new CrmCustomerAnswerViewModel() { crmQuestionId = x.CrmQuestionId, crmQuestionType = x.CrmQuestion.CrmQuestionType, buyType = x.CrmQuestion.BuyType, buyTypeSubset = x.CrmQuestion.BuyTypeSubset, buyTypeOnline = x.CrmQuestion.BuyTypeOnline, crmQuestionValueId = x.CrmQuestionValueId, descriptiveAnswer = x.DescriptiveAnswer, yesNoAnswer = x.YesNoAnswer, }).ToList() }; if (list != null) { response = new Response() { status = 200, data = list, }; } else { response = new Response() { status = 404, message = "سوال مورد نظر یافت نشد." }; } } } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }
public JsonResult SaveCustomer(CrmCustomerViewModel model) { var currentUser = GetAuthenticatedUser(); Response response; try { using (var db = new KiaGalleryContext()) { if (model.id != null && model.id > 0) { var customer = db.CrmCustomer.Single(x => x.Id == model.id); customer.Id = model.id; customer.FullName = model.fullName; customer.FactorNumber = model.factorNumber; customer.PhoneNumber = model.phoneNumber; if (User.IsInRole("branchCrm")) { customer.BuyType = BuyType.BuyAttendance; } if (User.IsInRole("officeCrm")) { customer.BuyType = BuyType.BuyOnline; } customer.BuyTypeOnline = model.buyTypeOnline; customer.BuyTypeSubset = model.buyTypeSubset; customer.Date = DateUtility.GetDateTime(model.date); customer.Score = model.score; customer.BranchId = currentUser.BranchId; customer.ModifyUserId = GetAuthenticatedUserId(); customer.ModifyDate = DateTime.Now; customer.Ip = Request.UserHostAddress; var idList = model.answerList.Where(x => model.id != null).Select(x => model.id).ToList(); var deletedItems = customer.CrmCustomerAnswerList.Where(x => !idList.Any(y => y == x.Id)).ToList(); if (deletedItems.Count > 0) { db.CrmCustomerAnswer.RemoveRange(deletedItems); } model.answerList.ForEach(x => { var value = customer.CrmCustomerAnswerList.SingleOrDefault(y => y.CrmQuestionId == x.crmQuestionId); if (value != null) { value.CrmQuestionId = x.crmQuestionId; value.CrmQuestionValueId = x.crmQuestionValueId; value.DescriptiveAnswer = x.descriptiveAnswer; value.YesNoAnswer = x.yesNoAnswer; value.ModifyDate = DateTime.Now; value.ModifyUserId = GetAuthenticatedUserId(); value.Ip = Request.UserHostAddress; } else { customer.CrmCustomerAnswerList.Add(new CrmCustomerAnswer() { CrmQuestionId = x.crmQuestionId, CrmQuestionValueId = x.crmQuestionValueId, DescriptiveAnswer = x.descriptiveAnswer, YesNoAnswer = x.yesNoAnswer, CreateUserId = GetAuthenticatedUserId(), ModifyUserId = GetAuthenticatedUserId(), CreateDate = DateTime.Now, ModifyDate = DateTime.Now, Ip = Request.UserHostAddress, }); } }); } else { var item = new CrmCustomer() { FullName = model.fullName, FactorNumber = model.factorNumber, PhoneNumber = model.phoneNumber, BuyType = model.buyType, BuyTypeOnline = model.buyTypeOnline, BuyTypeSubset = model.buyTypeSubset, BranchId = currentUser.BranchId, Date = DateUtility.GetDateTime(model.date), Score = model.score, CreateUserId = GetAuthenticatedUserId(), ModifyUserId = GetAuthenticatedUserId(), CreateDate = DateTime.Now, ModifyDate = DateTime.Now, Ip = Request.UserHostAddress, }; if (User.IsInRole("branchCrm")) { item.BuyType = BuyType.BuyAttendance; } if (User.IsInRole("officeCrm")) { item.BuyType = BuyType.BuyOnline; } model.answerList.ForEach(x => { item.CrmCustomerAnswerList.Add(new CrmCustomerAnswer() { CrmQuestionId = x.crmQuestionId, CrmQuestionValueId = x.crmQuestionValueId, DescriptiveAnswer = x.descriptiveAnswer, YesNoAnswer = x.yesNoAnswer, CreateUserId = GetAuthenticatedUserId(), ModifyUserId = GetAuthenticatedUserId(), CreateDate = DateTime.Now, ModifyDate = DateTime.Now, Ip = Request.UserHostAddress, }); }); db.CrmCustomer.Add(item); } db.SaveChanges(); } response = new Response() { status = 200, message = "ثبت اطلاعات با موفقیت انجام شد." }; } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }
public ActionResult AddCrm(CrmCustomerViewModel model) { if (ModelState.IsValid) { if (_carihesaplarORM.carihesapvarmı(model.il_carikodu)) { return(Json("Böyle bir cari hesap bulunmadı")); } else { ILISKILER il = new ILISKILER(); il.il_RECid_DBCno = model.il_RECid_DBCno; il.il_RECid_RECno = model.il_RECid_DBCno; il.il_SpecRECno = model.il_RECid_DBCno; il.il_iptal = model.il_iptal; il.il_fileid = model.il_fileid; il.il_hidden = model.il_hidden; il.il_kilitli = model.il_kilitli; il.il_degisti = model.il_degisti; il.il_checksum = model.il_checksum; il.il_create_user = model.il_create_user; il.il_create_date = model.il_create_date; il.il_lastup_user = model.il_RECid_DBCno; il.il_lastup_date = model.il_lastup_date; il.il_special1 = model.il_special1; il.il_special2 = model.il_special2; il.il_special3 = model.il_special3; il.il_baszaman = Convert.ToDateTime(model.il_baszaman + " " + model.il_bassaati); il.il_bitzaman = Convert.ToDateTime(model.il_bitzaman + " " + model.il_bitsaati); il.il_sorumlu_personel = model.il_sorumlu_personel; il.il_iliski_tipi = model.il_iliski_tipi; il.il_carikodu = model.il_carikodu; il.il_adres_no = model.il_adres_no; il.il_yetkiliRecID_DBCno = model.il_yetkiliRecID_DBCno; il.il_yetkiliRecID_RECno = model.il_yetkiliRecID_RECno; il.il_yetkiliadi = model.il_yetkiliadi; il.il_yer = model.il_yer; il.il_konu = model.il_konu; il.il_refno = model.il_refno; il.il_projekodu = model.il_projekodu; il.il_oncelik = model.il_oncelik; il.il_cari_tipi = model.il_cari_tipi; if (_iliskiORM.Insert(il)) { Success("Kayit işlemi başarılı."); var getLastId = _iliskiORM.GetList("Select * From ILISKILER where il_carikodu='" + model.il_carikodu + "' order by il_RECno desc ").FirstOrDefault(); if (getLastId != null) { mye_TextData dt = new mye_TextData(); dt.TableID = 154; dt.RecID_DBCno = 0; dt.RecID_RECno = getLastId.il_RECno; dt.Data = model.Aciklama; _myeTextDataOrm.Insert(dt); } return(Json("1")); } else { Danger("Kayit işlemi başarısiz."); return(Json("1")); } } } model.il_sorumlu_personelList = GetsorumluPersonel(); return(View(model)); }