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));
}
