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