public bool UpdateNumber(Common.GeneralNumber generalNumber, Guid userGuid, Business.CheckNumberScope scope) { try { if (!IsDuplicateNumber(userGuid, generalNumber.GeneralPhoneBookGuid, scope, generalNumber.CellPhone)) { throw new Exception(Language.GetString("ErrorDuplicateNumber")); } return(base.ExecuteSPCommand("UpdateNumber", "@Guid", generalNumber.GeneralNumberGuid, "@FirstName", generalNumber.FirstName, "@LastName", generalNumber.LastName, "@BirthDate", generalNumber.BirthDate, "@Telephone", generalNumber.Telephone, "@CellPhone", generalNumber.CellPhone, "@FaxNumber", generalNumber.FaxNumber, "@Job", generalNumber.Job, "@Address", generalNumber.Address, "@Email", generalNumber.Email, "@Sex", generalNumber.Sex)); } catch (Exception ex) { throw ex; } }
protected void btnSave_Click(object sender, EventArgs e) { try { int countNumberDuplicate = 0; List <string> lstFailedNumbers = new List <string>(); List <string> lstNumbers = txtNumbers.Text.Replace("\r\n", "\n").Split('\n').ToList(); Business.CheckNumberScope scope = (Business.CheckNumberScope)Enum.Parse(typeof(Business.CheckNumberScope), drpCheckNumberScope.SelectedValue); if (!Facade.PhoneNumber.InsertListNumber(UserGuid, PhoneBookGuid, ref lstNumbers, ref lstFailedNumbers, ref countNumberDuplicate, scope)) { throw new Exception(Language.GetString("ErrorRecord")); } txtNumbersInvalid.Text += string.Join(Environment.NewLine, lstFailedNumbers.ToArray()); ShowMessageBox(Language.GetString("TotalNumberOfRegistered") + (lstNumbers.Count - countNumberDuplicate) + Language.GetString("Number") + "<br/>" + Language.GetString("TotalNumberOfDuplicate") + countNumberDuplicate + Language.GetString("Number") + "<br/>" + Language.GetString("CountNumberFail") + lstFailedNumbers.Count + Language.GetString("Number") + "<br/>", string.Empty, "success"); } catch (Exception ex) { ShowMessageBox(ex.Message, string.Empty, "danger"); } }
public bool IsDuplicateNumber(Guid userGuid, Guid generalPhoneBookGuid, Business.CheckNumberScope scope, string cellPhone) { DataTable dataTableGeneralNumberStatus = new DataTable(); dataTableGeneralNumberStatus = base.FetchSPDataTable("NumberStatus", "@Scope", (int)scope, "@CellPhone", cellPhone, "@GeneralPhoneBookGuid", generalPhoneBookGuid, "@UserGuid", userGuid); return(dataTableGeneralNumberStatus.Rows.Count > 0 ? true : false); }
public static bool InsertListNumber(Guid userGuid, Guid phoneBookGuid, ref List <string> lstNumbers, ref List <string> lstFailedNumbers, ref int countNumberDuplicate, Business.CheckNumberScope scope) { Business.PhoneNumber phoneNumberController = new Business.PhoneNumber(); int mobileCount = 0; int emailCount = 0; try { Outbox.GetCountNumberOfOperators(ref lstNumbers, ref lstFailedNumbers); if (lstNumbers.Count == 0) { throw new Exception(Language.GetString("CompleteMobileNoField")); } Common.User user = User.LoadUser(userGuid); PhoneBook.GetUserMaximumRecordInfo(userGuid, ref mobileCount, ref emailCount); if (user.MaximumPhoneNumber != -1 && user.MaximumPhoneNumber <= mobileCount && user.MaximumPhoneNumber <= (mobileCount + lstNumbers.Count)) { throw new Exception(Language.GetString("ErrorMaximumPhoneNumber")); } XDocument doc = new XDocument(); XElement root = new XElement("NewDataSet"); foreach (string number in lstNumbers) { XElement element = new XElement("Table"); element.Add(new XElement("CellPhone", number)); root.Add(element); } doc.Add(root); return(phoneNumberController.InsertListNumber(userGuid, phoneBookGuid, doc.ToString(), ref countNumberDuplicate, scope)); } catch (Exception ex) { throw ex; } }
public bool UpdateNumber(Common.PhoneNumber phoneNumber, Guid userGuid, Business.CheckNumberScope scope) { try { DataTable dataTableNumberStatus = new DataTable(); if ((int)scope == (int)CheckNumberScope.DeleteDuplicateNumberInGroup) { dataTableNumberStatus = FetchDataTable(@"SELECT [CellPhone] FROM [PhoneNumbers] WHERE [IsDeleted]=0 AND [Guid]!= @Guid AND [PhoneBookGuid] = @PhoneBookGuid AND [CellPhone] = @CellPhone AND [Email] = @Email" , "@Guid", phoneNumber.PhoneNumberGuid, "@PhoneBookGuid", phoneNumber.PhoneBookGuid, "@CellPhone", phoneNumber.CellPhone, "@Email", phoneNumber.Email); } else if ((int)scope == (int)CheckNumberScope.DeleteDuplicateNumberInTotalGroup) { dataTableNumberStatus = FetchDataTable(@"SELECT [CellPhone] FROM [PhoneNumbers] number INNER JOIN [PhoneBooks] phoneBook ON phoneBook.[Guid]=number.[PhoneBookGuid] WHERE number.[IsDeleted] = 0 AND phoneBook.[IsDeleted] = 0 AND [UserGuid] = @UserGuid AND number.[Guid]!=@Guid AND [CellPhone] = @CellPhone AND [Email] = @Email" , "@UserGuid", userGuid, "@Guid", phoneNumber.PhoneNumberGuid, "@CellPhone", phoneNumber.CellPhone, "@Email", phoneNumber.Email); } if (dataTableNumberStatus.Rows.Count > 0) { throw new Exception(Language.GetString("ErrorDuplicateNumber")); } return(base.ExecuteSPCommand("UpdateNumber", "@Guid", phoneNumber.PhoneNumberGuid, "@FirstName", phoneNumber.FirstName, "@LastName", phoneNumber.LastName, "@NationalCode", phoneNumber.NationalCode, "@BirthDate", phoneNumber.BirthDate, "@Telephone", phoneNumber.Telephone, "@CellPhone", phoneNumber.CellPhone, "@FaxNumber", phoneNumber.FaxNumber, "@Job", phoneNumber.Job, "@Address", phoneNumber.Address, "@Email", phoneNumber.Email, "@F1", phoneNumber.F1, "@F2", phoneNumber.F2, "@F3", phoneNumber.F3, "@F4", phoneNumber.F4, "@F5", phoneNumber.F5, "@F6", phoneNumber.F6, "@F7", phoneNumber.F7, "@F8", phoneNumber.F8, "@F9", phoneNumber.F9, "@F10", phoneNumber.F10, "@F11", phoneNumber.F11, "@F12", phoneNumber.F12, "@F13", phoneNumber.F13, "@F14", phoneNumber.F14, "@F15", phoneNumber.F15, "@F16", phoneNumber.F16, "@F17", phoneNumber.F17, "@F18", phoneNumber.F18, "@F19", phoneNumber.F19, "@F20", phoneNumber.F20, "@Sex", phoneNumber.Sex)); } catch (Exception ex) { throw ex; } }
public static bool UpdateNumber(Common.PhoneNumber phoneNumber, Guid userGuid, Business.CheckNumberScope scope) { try { Business.PhoneNumber phoneNumberController = new Business.PhoneNumber(); return(phoneNumberController.UpdateNumber(phoneNumber, userGuid, scope)); } catch (Exception ex) { throw ex; } }
public static bool IsDuplicateNumber(Guid userGuid, Guid phoneBookGuid, Business.CheckNumberScope scope, string cellPhone, string email) { Business.PhoneNumber phoneNumberController = new Business.PhoneNumber(); return(phoneNumberController.IsDuplicateNumber(userGuid, phoneBookGuid, scope, cellPhone, email)); }
public static bool UpdateNumber(Common.GeneralNumber generalNumber, Guid userGuid, Business.CheckNumberScope scope) { Business.GeneralNumber generalNumberController = new Business.GeneralNumber(); return(generalNumberController.UpdateNumber(generalNumber, userGuid, scope)); }
public static bool IsDuplicateNumber(Guid userGuid, Guid generalPhoneBookGuid, Business.CheckNumberScope scope, string cellPhone) { Business.GeneralNumber generalNumberController = new Business.GeneralNumber(); return(generalNumberController.IsDuplicateNumber(userGuid, generalPhoneBookGuid, scope, cellPhone)); }