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