//----------------------------------------------------------
#endregion
#region ----------------InsertTestingDataForSmsList---------------
//----------------------------------------------------------
//InsertTestingDataForSmsList
//----------------------------------------------------------
public void InsertTestingDataForSmsList()
{
//----------------------------------------------------------------------
SMSNumbersEntity ArSmsListUsers = new SMSNumbersEntity();
string arNumber = "0111234567{0}";
string arName = "إسم {0}";
ArSmsListUsers.IsActive = true;
ArSmsListUsers.ModuleTypeID = (int)StandardItemsModuleTypes.SMS;
ArSmsListUsers.LangID = Languages.Ar;
//----------------------------------------------------------------------
SMSNumbersEntity EnSmsListUsers = new SMSNumbersEntity();
string enNumber = "09661234567{0}";
string enName = "Name {0}";
EnSmsListUsers.IsActive = true;
EnSmsListUsers.ModuleTypeID = (int)StandardItemsModuleTypes.SMS;
EnSmsListUsers.LangID = Languages.Ar;
//----------------------------------------------------------------------
for (int i = 1; i <= 5; i++)
{
if (SiteSettings.Languages_HasArabicLanguages)
{
ArSmsListUsers.Numbers = string.Format(arNumber, i.ToString());
ArSmsListUsers.Name = string.Format(arName, i.ToString());
SMSNumbersFactory.Create(ArSmsListUsers);
}
if (SiteSettings.Languages_HasEnglishLanguages)
{
EnSmsListUsers.Numbers = string.Format(enNumber, i.ToString());
EnSmsListUsers.Name = string.Format(enName, i.ToString());
SMSNumbersFactory.Create(EnSmsListUsers);
}
}
}
//------------------------------------------
/// <summary>
/// Converts the SMSNumbers object properties to SQL paramters and executes the create SMSNumbers procedure
/// and updates the SMSNumbers object with the SQL data by reference.
/// <example>[Example]bool result=SMSNumbersSqlDataPrvider.Instance.Create(sMSNumbers);.</example>
/// </summary>
/// <param name="sMSNumbers">The SMSNumbers object.</param>
/// <returns>The result of create query.</returns>
public ExecuteCommandStatus Create(SMSNumbersEntity sMSNumbers)
{
using (SqlConnection myConnection = GetSqlConnection())
{
SqlCommand myCommand = new SqlCommand("SMSNumbers_Create", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
// Set the parameters
myCommand.Parameters.Add("@NumID", SqlDbType.BigInt, 8).Direction = ParameterDirection.Output;
myCommand.Parameters.Add("@Numbers", SqlDbType.NVarChar, 20).Value = sMSNumbers.Numbers;
myCommand.Parameters.Add("@Name", SqlDbType.NVarChar, 200).Value = sMSNumbers.Name;
myCommand.Parameters.Add("@GroupID", SqlDbType.Int, 4).Value = sMSNumbers.GroupID;
//--------------------------------------------------------------------------------
myCommand.Parameters.Add("@IsActive", SqlDbType.Bit, 1).Value = sMSNumbers.IsActive;
//myCommand.Parameters.Add("@JoinDate", SqlDbType.DateTime,8).Value = mailListUsers.JoinDate;
myCommand.Parameters.Add("@ModuleTypeID", SqlDbType.Int, 4).Value = (int)sMSNumbers.ModuleTypeID;
myCommand.Parameters.Add("@LangID", SqlDbType.Int, 4).Value = (int)sMSNumbers.LangID;
//----------------------------------------------------------------------------------------------
//OwnerID
myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid();
//----------------------------------------------------------------------------------------------
// Execute the command
myConnection.Open();
ExecuteCommandStatus status = (ExecuteCommandStatus)myCommand.ExecuteScalar();
if (status == ExecuteCommandStatus.Done)
{
//Get ID value from database and set it in object
sMSNumbers.NumID = (long)myCommand.Parameters["@NumID"].Value;
}
myConnection.Close();
return(status);
}
}
//------------------------------------------
public SMSNumbersEntity GetSMSNumbersObjectByNumber(int ModuleTypeID, string mobileNo)
{
SMSNumbersEntity sMSNumbers = null;
using (SqlConnection myConnection = GetSqlConnection())
{
SqlCommand myCommand = new SqlCommand("SMSNumbers_GetOneByID", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
// Set the parameters
myCommand.Parameters.Add("@ModuleTypeID", SqlDbType.Int, 4).Value = (int)ModuleTypeID;
myCommand.Parameters.Add("@Numbers", SqlDbType.NVarChar, 20).Value = mobileNo;
//----------------------------------------------------------------------------------------------
//OwnerID
myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid();
//----------------------------------------------------------------------------------------------
// Execute the command
myConnection.Open();
using (SqlDataReader dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection))
{
if (dr.Read())
{
sMSNumbers = PopulateEntity(dr);
}
dr.Close();
}
myConnection.Close();
return(sMSNumbers);
}
}
//----------------------------------------------------------------------------
/// <summary>
/// Gets single SMSNumbers object .
/// <example>[Example]SMSNumbersEntity sMSNumbers=SMSNumbersSqlDataPrvider.Instance.GetObject(numID);.</example>
/// </summary>
/// <param name="numID">The sMSNumbers id.</param>
/// <returns>SMSNumbers object.</returns>
public SMSNumbersEntity GetObject(long numID)
{
SMSNumbersEntity sMSNumbers = null;
using (SqlConnection myConnection = GetSqlConnection())
{
SqlCommand myCommand = new SqlCommand("SMSNumbers_GetOneByID", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
// Set the parameters
myCommand.Parameters.Add("@NumID", SqlDbType.BigInt, 8).Value = numID;
//----------------------------------------------------------------------------------------------
//OwnerID
myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid();
//----------------------------------------------------------------------------------------------
// Execute the command
myConnection.Open();
using (SqlDataReader dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection))
{
if (dr.Read())
{
sMSNumbers = PopulateEntity(dr);
}
dr.Close();
}
myConnection.Close();
return(sMSNumbers);
}
}
//------------------------------------------
//-----------------------------------------------------------------------
public static ExecuteCommandStatus RegisterInSms(int moduleID, string mobile, Languages langID, bool isActive)
{
SMSNumbersEntity newSmsUser = new SMSNumbersEntity();
newSmsUser.Numbers = mobile;
newSmsUser.LangID = langID;
newSmsUser.ModuleTypeID = moduleID;
newSmsUser.IsActive = isActive;
ExecuteCommandStatus status = SMSNumbersFactory.Create(newSmsUser);
return(status);
}
/// <summary>
/// Populates SMSNumbers Entity From IDataReader .
/// <example>[Example]SMSNumbersEntitysMSNumbers=PopulateEntity(reader);.</example>
/// </summary>
/// <param name="reader"></param>
/// <returns>SMSNumbers object.</returns>
private SMSNumbersEntity PopulateEntity(IDataReader reader)
{
//Create a new SMSNumbers object
SMSNumbersEntity sMSNumbers = new SMSNumbersEntity();
//Fill the object with data
if (reader["NumID"] != DBNull.Value)
{
sMSNumbers.NumID = (long)reader["NumID"];
}
if (reader["Numbers"] != DBNull.Value)
{
sMSNumbers.Numbers = (string)reader["Numbers"];
}
if (reader["GroupID"] != DBNull.Value)
{
sMSNumbers.GroupID = (int)reader["GroupID"];
}
if (reader["Name"] != DBNull.Value)
{
sMSNumbers.Name = (string)reader["Name"];
}
//IsActive
if (reader["IsActive"] != DBNull.Value)
{
sMSNumbers.IsActive = (bool)reader["IsActive"];
}
//JoinDate
if (reader["JoinDate"] != DBNull.Value)
{
sMSNumbers.JoinDate = (DateTime)reader["JoinDate"];
}
//LangID
if (reader["LangID"] != DBNull.Value)
{
sMSNumbers.LangID = (Languages)reader["LangID"];
}
//ModuleTypeID
if (reader["ModuleTypeID"] != DBNull.Value)
{
sMSNumbers.ModuleTypeID = (int)reader["ModuleTypeID"];
}
//Return the populated object
return(sMSNumbers);
}
//------------------------------------------
/// <summary>
/// Populates SMSNumbers Entity From DataRowView .
/// <example>[Example]SMSNumbersEntitysMSNumbers=PopulateSMSNumbersEntityFromDataRowView(obj);.</example>
/// </summary>
/// <param name="obj"></param>
/// <returns>SMSNumbers object.</returns>
private SMSNumbersEntity PopulateSMSNumbersEntityFromDataRowView(DataRowView obj)
{
//Create a new SMSNumbers object
SMSNumbersEntity sMSNumbers = new SMSNumbersEntity();
//Fill the object with data
if (obj["NumID"] != DBNull.Value)
{
sMSNumbers.NumID = (long)obj["NumID"];
}
if (obj["Numbers"] != DBNull.Value)
{
sMSNumbers.Numbers = (string)obj["Numbers"];
}
if (obj["GroupID"] != DBNull.Value)
{
sMSNumbers.GroupID = (int)obj["GroupID"];
}
//Return the populated object
return(sMSNumbers);
}
//---------------------------------------------------------------------------
public static void UpdateSmsMobileNo(string oldMobile, UsersDataEntity usersDataObject)
{
SMSNumbersEntity smsUser = SMSNumbersFactory.GetObject(usersDataObject.ModuleTypeID, oldMobile);
if (smsUser != null)
{
if (!string.IsNullOrEmpty(usersDataObject.Mobile))
{
smsUser.Numbers = usersDataObject.Mobile;
SMSNumbersFactory.Update(smsUser);
}
else
{
SMSNumbersFactory.Delete(smsUser.NumID);
}
}
else
{
UsersDataFactory.RegisterInSms(usersDataObject);
}
}
//---------------------------------------------------------------------------
public static void UpdateSmsMobileNo(string oldMobile, MessagesEntity msg)
{
SMSNumbersEntity smsUser = SMSNumbersFactory.GetObject(msg.ModuleTypeID, oldMobile);
if (smsUser != null)
{
if (!string.IsNullOrEmpty(msg.Mobile))
{
smsUser.Numbers = msg.Mobile;
SMSNumbersFactory.Update(smsUser);
}
else
{
SMSNumbersFactory.Delete(smsUser.NumID);
}
}
else
{
MessagesFactory.RegisterInSms(msg);
}
}
//------------------------------------------
/// <summary>
/// Converts the SMSNumbers object properties to SQL paramters and executes the update SMSNumbers procedure.
/// <example>[Example]bool result=SMSNumbersSqlDataPrvider.Instance.Update(sMSNumbers);.</example>
/// </summary>
/// <param name="sMSNumbers">The SMSNumbers object.</param>
/// <returns>The result of update query.</returns>
public ExecuteCommandStatus Update(SMSNumbersEntity sMSNumbers)
{
using (SqlConnection myConnection = GetSqlConnection())
{
SqlCommand myCommand = new SqlCommand("SMSNumbers_Update", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
// Set the parameters
myCommand.Parameters.Add("@NumID", SqlDbType.BigInt, 8).Value = sMSNumbers.NumID;
myCommand.Parameters.Add("@Numbers", SqlDbType.NVarChar, 20).Value = sMSNumbers.Numbers;
myCommand.Parameters.Add("@GroupID", SqlDbType.Int, 4).Value = sMSNumbers.GroupID;
myCommand.Parameters.Add("@Name", SqlDbType.NVarChar, 200).Value = sMSNumbers.Name;
myCommand.Parameters.Add("@IsActive", SqlDbType.Bit, 1).Value = sMSNumbers.IsActive;
myCommand.Parameters.Add("@ModuleTypeID", SqlDbType.Int, 4).Value = (int)sMSNumbers.ModuleTypeID;
//----------------------------------------------------------------------------------------------
//OwnerID
myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid();
//----------------------------------------------------------------------------------------------
// Execute the command
myConnection.Open();
ExecuteCommandStatus status = (ExecuteCommandStatus)myCommand.ExecuteScalar();
myConnection.Close();
return(status);
}
}
//------------------------------------------
/// <summary>
/// Updates SMSNumbers object by calling SMSNumbers data provider update method.
/// <example>[Example]bool result=SMSNumbersFactory.Update(sMSNumbers);.</example>
/// </summary>
/// <param name="sMSNumbers">The SMSNumbers object.</param>
/// <returns>The result of update operation.</returns>
public static ExecuteCommandStatus Update(SMSNumbersEntity sMSNumbers)
{
return(SMSNumbersSqlDataPrvider.Instance.Update(sMSNumbers));
}
