//------------------------------------------
/// <summary>
/// Converts the SMSArchive object properties to SQL paramters and executes the create SMSArchive procedure
/// and updates the SMSArchive object with the SQL data by reference.
/// <example>[Example]bool result=SMSArchiveSqlDataPrvider.Instance.Create(sMSArchive);.</example>
/// </summary>
/// <param name="sMSArchive">The SMSArchive object.</param>
/// <returns>The result of create query.</returns>
public bool Create(SMSArchiveEntity sMSArchive)
{
bool result = false;
using (SqlConnection myConnection = GetSqlConnection())
{
SqlCommand myCommand = new SqlCommand("SMSArchive_Create", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
// Set the parameters
myCommand.Parameters.Add("@ID", SqlDbType.Int, 4).Direction = ParameterDirection.Output;
myCommand.Parameters.Add("@Sender", SqlDbType.NVarChar, 20).Value = sMSArchive.Sender;
myCommand.Parameters.Add("@RecieverMobile", SqlDbType.NVarChar, 20).Value = sMSArchive.RecieverMobile;
myCommand.Parameters.Add("@Message", SqlDbType.NVarChar, 500).Value = sMSArchive.Message;
myCommand.Parameters.Add("@LangID", SqlDbType.Int, 4).Value = (int)sMSArchive.LangID;
//----------------------------------------------------------------------------------------------
//OwnerID
myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid();
//----------------------------------------------------------------------------------------------
// Execute the command
myConnection.Open();
if (myCommand.ExecuteNonQuery() > 0)
{
result = true;
//Get ID value from database and set it in object
sMSArchive.ID = (int)myCommand.Parameters["@ID"].Value;
}
myConnection.Close();
return(result);
}
}
//------------------------------------------
/// <summary>
/// Populates SMSArchive Entity From IDataReader .
/// <example>[Example]SMSArchiveEntitysMSArchive=PopulateSMSArchiveEntityFromIDataReader(reader);.</example>
/// </summary>
/// <param name="reader"></param>
/// <returns>SMSArchive object.</returns>
private SMSArchiveEntity PopulateSMSArchiveEntityFromIDataReader(IDataReader reader)
{
//Create a new SMSArchive object
SMSArchiveEntity sMSArchive = new SMSArchiveEntity();
//Fill the object with data
if (reader["ID"] != DBNull.Value)
{
sMSArchive.ID = (int)reader["ID"];
}
if (reader["Sender"] != DBNull.Value)
{
sMSArchive.Sender = (string)reader["Sender"];
}
if (reader["RecieverMobile"] != DBNull.Value)
{
sMSArchive.RecieverMobile = (string)reader["RecieverMobile"];
}
if (reader["Message"] != DBNull.Value)
{
sMSArchive.Message = (string)reader["Message"];
}
if (reader["LangID"] != DBNull.Value)
{
sMSArchive.LangID = (Languages)reader["LangID"];
}
//Return the populated object
return(sMSArchive);
}
//------------------------------------------
/// <summary>
/// Gets single SMSArchive object .
/// <example>[Example]SMSArchiveEntity sMSArchive=SMSArchiveSqlDataPrvider.Instance.GetSMSArchiveObject(id);.</example>
/// </summary>
/// <param name="id">The sMSArchive id.</param>
/// <returns>SMSArchive object.</returns>
public SMSArchiveEntity GetSMSArchiveObject(int id)
{
SMSArchiveEntity sMSArchive = null;
using (SqlConnection myConnection = GetSqlConnection())
{
SqlCommand myCommand = new SqlCommand("SMSArchive_GetOneByID", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
// Set the parameters
myCommand.Parameters.Add("@ID", SqlDbType.Int, 4).Value = id;
//----------------------------------------------------------------------------------------------
//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())
{
sMSArchive = PopulateSMSArchiveEntityFromIDataReader(dr);
}
dr.Close();
}
myConnection.Close();
return(sMSArchive);
}
}
public static bool Create(string msg, string to, string snder, Languages langID)
{
SMSArchiveEntity smsen = new SMSArchiveEntity();
smsen.LangID = langID;
smsen.Message = msg;
smsen.RecieverMobile = to;
smsen.Sender = snder;
return(SMSArchiveSqlDataPrvider.Instance.Create(smsen));
}
/// <summary>
/// Creates SMSArchive object by calling SMSArchive data provider create method.
/// <example>[Example]bool result=SMSArchiveFactory.Create(sMSArchive);.</example>
/// </summary>
/// <param name="sMSArchive">The SMSArchive object.</param>
/// <returns>The result of create operation.</returns>
public static bool Create(SMSArchiveEntity sMSArchive)
{
return(SMSArchiveSqlDataPrvider.Instance.Create(sMSArchive));
}
