public string CheckThongTinKhachHang(Add_Bill item) { string rs = null; if (string.IsNullOrEmpty(item.tenkh)) { return(rs = "Tên khách hàng không được để trống"); } if (string.IsNullOrEmpty(item.dienthoai)) { return(rs = "SĐT khách hàng không được để trống"); } var checkKH = db.service_customer.FirstOrDefault(m => m.fullname == item.tenkh && m.mobile == item.dienthoai); if (checkKH == null) { service_customer inew = new service_customer(); inew.fullname = item.tenkh; inew.mobile = item.dienthoai; inew.address = item.diachi; inew.id_center = item.id_center; inew.code_center = item.code_center; inew.created_at = DateTime.Now; inew.created_by = item.tennguoithaotac; inew.status = 1; inew.note = "Thêm mới khách hàng khi bán đại lý"; db.service_customer.Add(inew); db.SaveChanges(); } return(null); }
public ActionResult _AddCustomer(string fullName, string cmt, string birth, string address, string phone, string note, int branchId = 0) { // kiểm tra quyền thêm var sys = CheckActiveMenu.ReturnActive(SystemMessageConst.TypeAction.Addnew); if (sys.IsSuccess == false) { return(Json(new { result = sys }, JsonRequestBehavior.AllowGet)); } var db = new CustomerBusiness(); service_customer serviceCustomer = new service_customer(); var getbrand = entity.Branch.FirstOrDefault(m => m.Id == branchId); serviceCustomer.fullname = fullName; serviceCustomer.id_card = cmt; serviceCustomer.address = address; serviceCustomer.mobile = phone; serviceCustomer.note = note; serviceCustomer.status = 1; serviceCustomer.id_center = branchId; serviceCustomer.code_center = getbrand.Branch_code; serviceCustomer.created_by = user.FullName; serviceCustomer.created_at = DateTime.Now; DateTime _birth; if (!string.IsNullOrEmpty(birth)) { if (!DateTime.TryParseExact(birth, "dd/MM/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out _birth)) { SystemMessage systemMessage = new SystemMessage(); systemMessage.IsSuccess = false; systemMessage.Message = string.Format(SystemMessageConst.ValidateConst.DateIsNotValid, "Ngày sinh"); return(Json(new { result = systemMessage }, JsonRequestBehavior.AllowGet)); } serviceCustomer.birthday = _birth; } var result = db.AddCustomer(serviceCustomer); // luu log - thêm mới CheckRuleAndSaveLog.ReturnCheckRuleAndSaveLog(DbLogType.Create.ToString(), result.IsSuccess, JsonConvert.SerializeObject(new { data = serviceCustomer }, Newtonsoft.Json.Formatting.Indented, new JsonSerializerSettings { NullValueHandling = NullValueHandling.Ignore })); return(Json(new { result }, JsonRequestBehavior.AllowGet)); }
public SystemMessage AddCustomer(service_customer customer) { SystemMessage systemMessage = new SystemMessage(); try { var check = ValidateCustomer(customer); if (check != null) { systemMessage.IsSuccess = false; systemMessage.Message = check; return(systemMessage); } var checkBranch = db.Branch.FirstOrDefault(ob => ob.Id == customer.id_center); if (checkBranch == null) { systemMessage.IsSuccess = false; systemMessage.Message = "Đại lý không tồn tại !!!!"; return(systemMessage); } var checkSDT = db.service_customer.FirstOrDefault(m => m.mobile == customer.mobile && m.id_center == customer.id_center); if (checkSDT != null) { systemMessage.IsSuccess = false; systemMessage.Message = "SĐT đã tồn tại"; return(systemMessage); } var checkCMT = db.service_customer.FirstOrDefault(m => m.id_card == customer.id_card && m.id_center == customer.id_center); if (checkCMT != null) { systemMessage.IsSuccess = false; systemMessage.Message = "CMT đã tồn tại"; return(systemMessage); } db.service_customer.Add(customer); db.SaveChanges(); systemMessage.IsSuccess = true; systemMessage.Message = SystemMessageConst.systemmessage.AddSuccess; return(systemMessage); } catch (Exception e) { systemMessage.IsSuccess = false; systemMessage.Message = e.ToString(); return(systemMessage); } }
public Customer_Pagelist ListCustomer(string searchValue, int currPage, int recodperpage, int centerid, int roleid) { Customer_Pagelist result = new Customer_Pagelist(); List <service_customer> list = new List <service_customer>(); SqlConnection con = new SqlConnection(); con = Connection.Connect.GetConnect(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_customer_getall"; cmd.Parameters.Add(new SqlParameter("@searchValue", searchValue)); cmd.Parameters.Add(new SqlParameter("@centerid", centerid)); cmd.Parameters.Add(new SqlParameter("@roleid", roleid)); cmd.Parameters.Add(new SqlParameter("@roleadmin", SystemMessageConst.Role.Admin)); cmd.Parameters.Add(new SqlParameter("@currPage", currPage)); cmd.Parameters.Add(new SqlParameter("@recodperpage", 10)); cmd.Parameters.Add("@totalCount", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Connection = con; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); int total = Convert.ToInt32(cmd.Parameters["@totalCount"].Value); foreach (DataRow rowItem in dt.Rows) { service_customer customer = new service_customer(); customer.id = Int32.Parse(rowItem["id"].ToString()); customer.id_center = Int32.Parse(rowItem["id_center"].ToString()); customer.fullname = rowItem["fullname"].ToString(); customer.id_card = rowItem["id_card"].ToString(); customer.address = rowItem["address"].ToString(); customer.mobile = rowItem["mobile"].ToString(); customer.note = rowItem["note"].ToString(); if (rowItem["birthday"].ToString() != "") { customer.birthday = DateTime.Parse(rowItem["birthday"].ToString()); } list.Add(customer); } result.Data = list; result.Total = total; return(result); }
public ActionResult _EditCustomer(string fullName, string cmt, string birth, string address, string phone, string note, int branchId = 0, int id = 0) { // kiểm tra quyền thêm sửa var sys = CheckActiveMenu.ReturnActive(SystemMessageConst.TypeAction.Update); if (sys.IsSuccess == false) { return(Json(new { result = sys }, JsonRequestBehavior.AllowGet)); } var db = new CustomerBusiness(); service_customer serviceCustomer = new service_customer(); serviceCustomer.fullname = fullName; serviceCustomer.id_card = cmt; serviceCustomer.address = address; serviceCustomer.mobile = phone; serviceCustomer.note = note; serviceCustomer.id_center = branchId; serviceCustomer.id = id; DateTime _birth; if (!string.IsNullOrEmpty(birth)) { if (!DateTime.TryParseExact(birth, "dd/MM/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out _birth)) { SystemMessage systemMessage = new SystemMessage(); systemMessage.IsSuccess = false; systemMessage.Message = string.Format(SystemMessageConst.ValidateConst.DateIsNotValid, "Ngày sinh"); return(Json(new { result = systemMessage }, JsonRequestBehavior.AllowGet)); } serviceCustomer.birthday = _birth; } var result = db.EditCustomer(serviceCustomer); CheckRuleAndSaveLog.ReturnCheckRuleAndSaveLog(DbLogType.Update.ToString(), result.IsSuccess, JsonConvert.SerializeObject(new { log = "CapNhatThongTinKH", newtdata = serviceCustomer }, Newtonsoft.Json.Formatting.Indented, new JsonSerializerSettings { NullValueHandling = NullValueHandling.Ignore })); return(Json(new { result }, JsonRequestBehavior.AllowGet)); }
public string ValidateCustomer(service_customer customer) { string rs = null; var vld = new ValidateUtils(); rs = vld.CheckRequiredField(customer.fullname, "Họ và tên", 3, 50); if (rs != null) { return(rs); } rs = vld.CheckRequiredField(customer.id_card, "Số chứng minh thư", 7, 25); if (rs != null) { return(rs); } //rs = vld.CheckRequiredField(customer.code_customer, "Mã khách hàng", 3, 25); //if (rs != null) //{ // return rs; //} rs = vld.CheckRequiredField(customer.address, "Địa chỉ", 3, 100); if (rs != null) { return(rs); } rs = vld.CheckRequiredField(customer.mobile, "Số điện thoại", 9, 15); if (rs != null) { return(rs); } rs = vld.CheckNonRequiredField(customer.note, "Ghi chú", 250); if (rs != null) { return(rs); } return(null); }
public SystemMessage EditCustomer(service_customer customer) { SystemMessage systemMessage = new SystemMessage(); try { var check = ValidateCustomer(customer); if (check != null) { systemMessage.IsSuccess = false; systemMessage.Message = check; return(systemMessage); } var checkExisted = db.service_customer.FirstOrDefault(ob => ob.id == customer.id && ob.id_center == customer.id_center); if (checkExisted == null) { systemMessage.IsSuccess = false; systemMessage.Message = SystemMessageConst.systemmessage.NoData; return(systemMessage); } var checkBranch = db.Branch.FirstOrDefault(ob => ob.Id == customer.id_center); if (checkBranch == null) { systemMessage.IsSuccess = false; systemMessage.Message = "Đại lý không tồn tại !!!!"; return(systemMessage); } var checkSDT = db.service_customer.FirstOrDefault(m => m.mobile == customer.mobile && m.id != customer.id && m.id_center == customer.id_center); if (checkSDT != null) { systemMessage.IsSuccess = false; systemMessage.Message = "SĐT đã tồn tại"; return(systemMessage); } var checkCMT = db.service_customer.FirstOrDefault(m => m.id_card == customer.id_card && m.id != customer.id && m.id_center == customer.id_center); if (checkCMT != null) { systemMessage.IsSuccess = false; systemMessage.Message = "CMT đã tồn tại"; return(systemMessage); } checkExisted.fullname = customer.fullname; checkExisted.address = customer.address; checkExisted.note = customer.note; checkExisted.id_card = customer.id_card; checkExisted.note = customer.note; checkExisted.birthday = customer.birthday; checkExisted.id_center = customer.id_center; checkExisted.mobile = customer.mobile; db.SaveChanges(); systemMessage.IsSuccess = true; systemMessage.Message = SystemMessageConst.systemmessage.EditSuccess; return(systemMessage); } catch (Exception e) { systemMessage.IsSuccess = false; systemMessage.Message = e.ToString(); return(systemMessage); } }