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