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;
}
}
public bool InsertNumber(Common.GeneralNumber generalNumber)
{
Guid guid = Guid.NewGuid();
return(base.ExecuteSPCommand("InsertNumber", "@Guid", guid,
"@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,
"@CreateDate", generalNumber.CreateDate,
"@Sex", generalNumber.Sex,
"@GeneralPhoneBookGuid", generalNumber.GeneralPhoneBookGuid));
}
public Common.GeneralNumber LoadNumber(Guid numberGuid)
{
Common.GeneralNumber generalNumber = new Common.GeneralNumber();
DataRow dataRowNumberInfo = base.FetchDataTable("SELECT * FROM [GeneralNumbers] WHERE [IsDeleted]=0 AND [Guid]=@Guid", "@Guid", numberGuid).Rows[0];
generalNumber.FirstName = Helper.GetString(dataRowNumberInfo["FirstName"]);
generalNumber.LastName = Helper.GetString(dataRowNumberInfo["LastName"]);
generalNumber.BirthDate = Helper.GetDateTime(dataRowNumberInfo["Birthdate"].ToString());
generalNumber.Telephone = Helper.GetString(dataRowNumberInfo["Telephone"]);
generalNumber.CellPhone = Helper.GetString(dataRowNumberInfo["CellPhone"]);
generalNumber.FaxNumber = Helper.GetString(dataRowNumberInfo["FaxNumber"]);
generalNumber.Job = Helper.GetString(dataRowNumberInfo["Job"]);
generalNumber.Address = Helper.GetString(dataRowNumberInfo["Address"]);
generalNumber.Email = Helper.GetString(dataRowNumberInfo["Email"]);
if (!Helper.CheckDataConditions(dataRowNumberInfo["Sex"]).IsEmpty)
{
generalNumber.Sex = Helper.GetInt(dataRowNumberInfo["Sex"]);
}
return(generalNumber);
}
public DataTable GetPagedNumbers(Common.GeneralNumber generalNumber, string sortField, int pageNo, int pageSize, ref int resultCount)
{
DataSet numbersInfo = base.FetchSPDataSet("GetPagedNumbers",
"@GeneralPhoneBookGuid", generalNumber.GeneralPhoneBookGuid,
"@FirstName", generalNumber.FirstName,
"@LastName", generalNumber.LastName,
"@BirthDate", generalNumber.BirthDate,
"@Sex", generalNumber.Sex,
"@CellPhone", generalNumber.CellPhone,
"@Email", generalNumber.Email,
"@Job", generalNumber.Job,
"@Telephone", generalNumber.Telephone,
"@FaxNumber", generalNumber.FaxNumber,
"@Address", generalNumber.Address,
"@PageNo", pageNo,
"@PageSize", pageSize,
"@SortField", sortField);
resultCount = Helper.GetInt(numbersInfo.Tables[0].Rows[0]["RowCount"]);
return(numbersInfo.Tables[1]);
}