public static Common.PhoneNumber LoadNumber(Guid phoneNumberGuid)
{
Common.PhoneNumber phoneNumber = new Common.PhoneNumber();
Business.PhoneNumber phoneNumberController = new Business.PhoneNumber();
phoneNumberController.Load(phoneNumberGuid, phoneNumber);
return(phoneNumber);
}
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 bool InsertNumber(Common.PhoneNumber phoneNumber)
{
Guid guid = Guid.NewGuid();
return(base.ExecuteSPCommand("InsertNumber",
"@Guid", guid,
"@FirstName", phoneNumber.FirstName,
"@LastName", phoneNumber.LastName,
"@NationalCode", phoneNumber.NationalCode,
"@BirthDate", phoneNumber.BirthDate,
"@CreateDate", phoneNumber.CreateDate,
"@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,
"@PhoneBookGuid", phoneNumber.PhoneBookGuid));
}
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 InsertNumber(Common.PhoneNumber phoneNumber)
{
Business.PhoneNumber phoneNumberController = new Business.PhoneNumber();
return(phoneNumberController.InsertNumber(phoneNumber));
}
private void SetCustomFieldValue(Common.PhoneNumber phoneNumber, int customFieldId, string value, UserFieldTypes userFieldTypes)
{
try
{
DateTime date;
switch (userFieldTypes)
{
case UserFieldTypes.Number:
if (!Helper.CheckDataConditions(value).IsIntNumber)
{
throw new Exception();
}
break;
case UserFieldTypes.DateTime:
date = DateManager.GetChristianDateForDB(value);
if (date != DateTime.MinValue)
{
value = date.ToString();
}
break;
}
switch (customFieldId)
{
case 1:
phoneNumber.F1 = value;
break;
case 2:
phoneNumber.F2 = value;
break;
case 3:
phoneNumber.F3 = value;
break;
case 4:
phoneNumber.F4 = value;
break;
case 5:
phoneNumber.F5 = value;
break;
case 6:
phoneNumber.F6 = value;
break;
case 7:
phoneNumber.F7 = value;
break;
case 8:
phoneNumber.F8 = value;
break;
case 9:
phoneNumber.F9 = value;
break;
case 10:
phoneNumber.F10 = value;
break;
case 11:
phoneNumber.F11 = value;
break;
case 12:
phoneNumber.F12 = value;
break;
case 13:
phoneNumber.F13 = value;
break;
case 14:
phoneNumber.F14 = value;
break;
case 15:
phoneNumber.F15 = value;
break;
case 16:
phoneNumber.F16 = value;
break;
case 17:
phoneNumber.F17 = value;
break;
case 18:
phoneNumber.F18 = value;
break;
case 19:
phoneNumber.F19 = value;
break;
case 20:
phoneNumber.F20 = value;
break;
}
}
catch
{
throw new Exception(Language.GetString("CustomFieldValueIsInValid"));
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Common.PhoneNumber phoneNumber;
List <Common.PhoneNumber> lstNumbers = new List <Common.PhoneNumber>();
string fieldId;
string saveReport = string.Empty;
try
{
string file = hdnFilePath.Value;
if (!System.IO.File.Exists(Server.MapPath(string.Format("/Uploads/{0}", file))))
{
throw new Exception(Language.GetString("FileDoesNotExist"));
}
string extension = file.Substring(file.LastIndexOf('.')).TrimStart('.');
bool firstRowHasColumnNames = chbHeaderRow.Checked;
DataTable dtb = new DataTable();
switch (extension.ToLower())
{
case "csv":
dtb = ImportFile.ImportCSV(Server.MapPath(string.Format("/Uploads/{0}", file)), firstRowHasColumnNames);
break;
case "xls":
case "xlsx":
dtb = ImportFile.ImportExcel(Server.MapPath(string.Format("/Uploads/{0}", file)), firstRowHasColumnNames);
break;
}
foreach (DataRow row in dtb.Rows)
{
phoneNumber = new Common.PhoneNumber();
phoneNumber.PhoneNumberGuid = Guid.NewGuid();
phoneNumber.PhoneBookGuid = PhoneBookGuid;
phoneNumber.CreateDate = DateTime.Now;
phoneNumber.FirstName = !string.IsNullOrEmpty(txtFirstName.Text) ? row[Helper.GetInt(txtFirstName.Text.Trim()) - 1].ToString() : string.Empty;
phoneNumber.LastName = !string.IsNullOrEmpty(txtLastName.Text) ? row[Helper.GetInt(txtLastName.Text.Trim()) - 1].ToString() : string.Empty;
if (!string.IsNullOrEmpty(txtBirthDate.Text))
{
phoneNumber.BirthDate = DateManager.GetChristianDateForDB(row[Helper.GetInt(txtBirthDate.Text.Trim()) - 1].ToString());
}
if (!string.IsNullOrEmpty(txtSex.Text))
{
phoneNumber.Sex = GetSex(row[Helper.GetInt(txtSex.Text.Trim()) - 1].ToString());
}
string mobile = !string.IsNullOrEmpty(txtCellPhone.Text) ? Helper.GetLocalMobileNumber(row[Helper.GetInt(txtCellPhone.Text.Trim()) - 1].ToString()) : string.Empty;
string email = !string.IsNullOrEmpty(txtEmail.Text) ? row[Helper.GetInt(txtEmail.Text.Trim()) - 1].ToString() : string.Empty;
if (!Helper.CheckDataConditions(email).IsEmail)
{
email = string.Empty;
}
//if (!Helper.CheckingCellPhone(ref mobile) && !Helper.CheckDataConditions(email).IsEmail)
// continue;
phoneNumber.Email = email;
phoneNumber.CellPhone = mobile;
phoneNumber.Job = !string.IsNullOrEmpty(txtJob.Text) ? row[Helper.GetInt(txtJob.Text.Trim()) - 1].ToString() : string.Empty;
phoneNumber.Telephone = !string.IsNullOrEmpty(txtTelephone.Text) ? row[Helper.GetInt(txtTelephone.Text.Trim()) - 1].ToString() : string.Empty;
phoneNumber.FaxNumber = !string.IsNullOrEmpty(txtFaxNumber.Text) ? row[Helper.GetInt(txtFaxNumber.Text.Trim()) - 1].ToString() : string.Empty;
phoneNumber.Address = !string.IsNullOrEmpty(txtAddress.Text) ? row[Helper.GetInt(txtAddress.Text.Trim()) - 1].ToString() : string.Empty;
fieldId = string.Empty;
for (int customFieldCounter = 1; customFieldCounter <= 20; customFieldCounter++)
{
fieldId = "Field" + customFieldCounter.ToString();
TextBox customField = pnlUserField.FindControl(fieldId) as TextBox;
if (customField != null && !string.IsNullOrEmpty(customField.Text))
{
SetCustomFieldValue(phoneNumber,
customFieldCounter,
row[Helper.GetInt(customField.Text.Trim()) - 1].ToString(),
(UserFieldTypes)Helper.GetInt(customField.Attributes["FieldType"]));
}
}
lstNumbers.Add(phoneNumber);
}
if (!Facade.PhoneNumber.InsertBulkNumbers(lstNumbers, UserGuid))
{
throw new Exception(Language.GetString("ErrorRecord"));
}
ClientSideScript = "saveResult('OK','" + Language.GetString("InsertRecord") + "');";
hdnFilePath.Value = string.Empty;
}
catch (Exception ex)
{
ClientSideScript = "saveResult('Error','" + ex.Message + "');";
}
}
private void InitializePage()
{
btnCancel.Text = Language.GetString("Cancel");
foreach (Business.Gender sex in Enum.GetValues(typeof(Business.Gender)))
{
drpSex.Items.Add(new ListItem(Language.GetString(sex.ToString()), ((int)sex).ToString()));
}
drpSex.Items.Insert(0, new ListItem(string.Empty, string.Empty));
foreach (Business.CheckNumberScope scope in Enum.GetValues(typeof(Business.CheckNumberScope)))
{
drpCheckNumberScope.Items.Add(new ListItem(Language.GetString(scope.ToString()), ((int)scope).ToString()));
}
if (ActionType == "edit")
{
string customField = string.Empty;
Common.PhoneNumber phoneNumber = Facade.PhoneNumber.LoadNumber(PhoneNumberGuid);
txtFirstName.Text = phoneNumber.FirstName;
txtLastName.Text = phoneNumber.LastName;
txtNationalCode.Text = phoneNumber.NationalCode;
if (phoneNumber.BirthDate != DateTime.MinValue)
{
dtpBirthDate.Value = DateManager.GetSolarDate(phoneNumber.BirthDate);
}
txtTelephone.Text = phoneNumber.Telephone;
txtCellPhone.Text = phoneNumber.CellPhone;
txtFaxNumber.Text = phoneNumber.FaxNumber;
txtJob.Text = phoneNumber.Job;
txtAddress.Text = phoneNumber.Address;
txtEmail.Text = phoneNumber.Email;
drpSex.SelectedValue = Helper.GetString(phoneNumber.Sex);
if (!Helper.CheckDataConditions(phoneNumber.F1).IsEmpty)
{
customField += "Field1{(" + phoneNumber.F1 + ")}";
}
if (!Helper.CheckDataConditions(phoneNumber.F2).IsEmpty)
{
customField += "Field2{(" + phoneNumber.F2 + ")}";
}
if (!Helper.CheckDataConditions(phoneNumber.F3).IsEmpty)
{
customField += "Field3{(" + phoneNumber.F3 + ")}";
}
if (!Helper.CheckDataConditions(phoneNumber.F4).IsEmpty)
{
customField += "Field4{(" + phoneNumber.F4 + ")}";
}
if (!Helper.CheckDataConditions(phoneNumber.F5).IsEmpty)
{
customField += "Field5{(" + phoneNumber.F5 + ")}";
}
if (!Helper.CheckDataConditions(phoneNumber.F6).IsEmpty)
{
customField += "Field6{(" + phoneNumber.F6 + ")}";
}
if (!Helper.CheckDataConditions(phoneNumber.F7).IsEmpty)
{
customField += "Field7{(" + phoneNumber.F7 + ")}";
}
if (!Helper.CheckDataConditions(phoneNumber.F8).IsEmpty)
{
customField += "Field8{(" + phoneNumber.F8 + ")}";
}
if (!Helper.CheckDataConditions(phoneNumber.F9).IsEmpty)
{
customField += "Field9{(" + phoneNumber.F9 + ")}";
}
if (!Helper.CheckDataConditions(phoneNumber.F10).IsEmpty)
{
customField += "Field10{(" + phoneNumber.F10 + ")}";
}
if (!Helper.CheckDataConditions(phoneNumber.F11).IsEmpty)
{
customField += "Field11{(" + phoneNumber.F11 + ")}";
}
if (!Helper.CheckDataConditions(phoneNumber.F12).IsEmpty)
{
customField += "Field12{(" + phoneNumber.F12 + ")}";
}
if (!Helper.CheckDataConditions(phoneNumber.F13).IsEmpty)
{
customField += "Field13{(" + phoneNumber.F13 + ")}";
}
if (!Helper.CheckDataConditions(phoneNumber.F14).IsEmpty)
{
customField += "Field14{(" + phoneNumber.F14 + ")}";
}
if (!Helper.CheckDataConditions(phoneNumber.F15).IsEmpty)
{
customField += "Field15{(" + phoneNumber.F15 + ")}";
}
if (!Helper.CheckDataConditions(phoneNumber.F16).IsEmpty)
{
customField += "Field16{(" + phoneNumber.F16 + ")}";
}
if (!Helper.CheckDataConditions(phoneNumber.F17).IsEmpty)
{
customField += "Field17{(" + phoneNumber.F17 + ")}";
}
if (!Helper.CheckDataConditions(phoneNumber.F18).IsEmpty)
{
customField += "Field18{(" + phoneNumber.F18 + ")}";
}
if (!Helper.CheckDataConditions(phoneNumber.F19).IsEmpty)
{
customField += "Field19{(" + phoneNumber.F19 + ")}";
}
if (!Helper.CheckDataConditions(phoneNumber.F20).IsEmpty)
{
customField += "Field20{(" + phoneNumber.F20 + ")}";
}
ClientSideScript = "customField('" + GenerateCustomField(customField) + "')";
}
else
{
ClientSideScript = "customField('" + GenerateCustomField(string.Empty) + "')";
}
}
public HttpResponseMessage Register(PhoneBookModel phonebookInfo)
{
Common.PhoneNumber phoneNumber;
List <Common.PhoneNumber> lstNumbers = new List <Common.PhoneNumber>();
var principal = Thread.CurrentPrincipal;
if (!principal.Identity.IsAuthenticated)
{
throw new BusinessException(HttpStatusCode.Accepted, ErrorCode.AccountIsInvalid, Language.GetString("AccountIsInvalid"));
}
if (phonebookInfo.PhoneBookGuid == Guid.Empty ||
phonebookInfo.Numbers.Count > 100 ||
phonebookInfo.Numbers.Count == 0)
{
throw new BusinessException(HttpStatusCode.Accepted, ErrorCode.BadRequest, Language.GetString("BadRequest"));
}
Common.User userInfo = ((MyPrincipal)principal).UserDetails;
Parallel.ForEach <PostPhoneNumberModel>(phonebookInfo.Numbers, (numberInfo) =>
{
numberInfo.Mobile = Helper.GetLocalMobileNumber(numberInfo.Mobile);
phoneNumber = new Common.PhoneNumber();
phoneNumber.PhoneNumberGuid = Guid.NewGuid();
phoneNumber.FirstName = numberInfo.FirstName;
phoneNumber.LastName = numberInfo.LastName;
phoneNumber.BirthDate = numberInfo.BirthDate;
phoneNumber.CreateDate = DateTime.Now;
phoneNumber.Telephone = numberInfo.Telephone;
phoneNumber.CellPhone = numberInfo.Mobile;
phoneNumber.FaxNumber = numberInfo.FaxNumber;
phoneNumber.Job = numberInfo.Job;
phoneNumber.Address = numberInfo.Address;
phoneNumber.Email = numberInfo.Email;
phoneNumber.Sex = Helper.GetByte(numberInfo.Gender);
phoneNumber.PhoneBookGuid = phonebookInfo.PhoneBookGuid;
if (Helper.IsCellPhone(numberInfo.Mobile) != 0)
{
lstNumbers.Add(phoneNumber);
}
});
if (lstNumbers.Count == 0)
{
throw new BusinessException(HttpStatusCode.Accepted, ErrorCode.ReceiversIsEmpty, Language.GetString("ReceiversIsEmpty"));
}
if (!Facade.PhoneNumber.InsertBulkNumbers(lstNumbers, userInfo.UserGuid))
{
throw new Exception(Language.GetString("ErrorRecord"));
}
ResponseMessage response = new ResponseMessage();
response.IsSuccessful = true;
return(Request.CreateResponse(HttpStatusCode.OK, response));
}