//------------------------------------------ /// <summary> /// Converts the SMSGroups object properties to SQL paramters and executes the update SMSGroups procedure. /// <example>[Example]bool result=SMSGroupsSqlDataPrvider.Instance.Update(smsGroups);.</example> /// </summary> /// <param name="smsGroups">The SMSGroups object.</param> /// <returns>The result of update query.</returns> public bool Update(SMSGroupsEntity smsGroups) { bool result = false; using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("SMSGroups_Update", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@GroupID", SqlDbType.Int, 4).Value = smsGroups.GroupID; myCommand.Parameters.Add("@Name", SqlDbType.NVarChar, 100).Value = smsGroups.Name; //---------------------------------------------------------------------------------------------- //OwnerID myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid(); //---------------------------------------------------------------------------------------------- // Execute the command myConnection.Open(); if (myCommand.ExecuteNonQuery() > 0) { result = true; } myConnection.Close(); return(result); } }
//------------------------------------------ /// <summary> /// Gets single SMSGroups object . /// <example>[Example]SMSGroupsEntity smsGroups=SMSGroupsSqlDataPrvider.Instance.GetSMSGroupsObject(GroupID);.</example> /// </summary> /// <param name="GroupID">The smsGroups id.</param> /// <returns>SMSGroups object.</returns> public SMSGroupsEntity GetSMSGroupsObject(int GroupID) { SMSGroupsEntity smsGroups = null; using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("SMSGroups_GetOneByID", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@GroupID", SqlDbType.Int, 4).Value = GroupID; //---------------------------------------------------------------------------------------------- //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()) { smsGroups = PopulateEntity(dr); } dr.Close(); } myConnection.Close(); return(smsGroups); } }
//------------------------------------------ /// <summary> /// Populates SMSGroups Entity From DataRowView . /// <example>[Example]SMSGroupsEntitysmsGroups=PopulateSMSGroupsEntityFromDataRowView(obj);.</example> /// </summary> /// <param name="obj"></param> /// <returns>SMSGroups object.</returns> private SMSGroupsEntity PopulateSMSGroupsEntityFromDataRowView(DataRowView obj) { //Create a new SMSGroups object SMSGroupsEntity smsGroups = new SMSGroupsEntity(); //Fill the object with data if (obj["GroupID"] != DBNull.Value) { smsGroups.GroupID = (int)obj["GroupID"]; } if (obj["Name"] != DBNull.Value) { smsGroups.Name = (string)obj["Name"]; } //Return the populated object return(smsGroups); }
//------------------------------------------ /// <summary> /// Populates SMSGroups Entity From IDataReader . /// <example>[Example]SMSGroupsEntitysmsGroups=PopulateEntity(reader);.</example> /// </summary> /// <param name="reader"></param> /// <returns>SMSGroups object.</returns> private SMSGroupsEntity PopulateEntity(IDataReader reader) { //Create a new SMSGroups object SMSGroupsEntity smsGroups = new SMSGroupsEntity(); //Fill the object with data if (reader["GroupID"] != DBNull.Value) { smsGroups.GroupID = (int)reader["GroupID"]; } if (reader["Name"] != DBNull.Value) { smsGroups.Name = (string)reader["Name"]; } //Return the populated object return(smsGroups); }
//------------------------------------------ /// <summary> /// Updates SMSGroups object by calling SMSGroups data provider update method. /// <example>[Example]bool result=SMSGroupsFactory.Update(smsGroups);.</example> /// </summary> /// <param name="smsGroups">The SMSGroups object.</param> /// <returns>The result of update operation.</returns> public static bool Update(SMSGroupsEntity smsGroups) { return(SMSGroupsSqlDataPrvider.Instance.Update(smsGroups)); }