public int InsertAndUpdateEmailDistribution(EmailDistribution emailDistribution, string type)
{
using (SqlConnection sqlConnection = new SqlConnection(this.ConnectionString))
{
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand("[spInsertUpdateEmailDistribution]", sqlConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@EmailDistributionID", emailDistribution.EmailDistributionID);
sqlCommand.Parameters.AddWithValue("@Jobnumber", emailDistribution.Jobnumber);
sqlCommand.Parameters.AddWithValue("@Projectnumber", emailDistribution.Projectnumber);
sqlCommand.Parameters.AddWithValue("@DistributionNumber", emailDistribution.DistributionNumber);
sqlCommand.Parameters.AddWithValue("@FromEmail", emailDistribution.FromEmail);
sqlCommand.Parameters.AddWithValue("@ToEmail", emailDistribution.ToEmail);
sqlCommand.Parameters.AddWithValue("@CC", emailDistribution.CC);
sqlCommand.Parameters.AddWithValue("@BCC", emailDistribution.BCC);
sqlCommand.Parameters.AddWithValue("@Subject", emailDistribution.Subject);
sqlCommand.Parameters.AddWithValue("@Createby", emailDistribution.Createby);
sqlCommand.Parameters.AddWithValue("@CreatedDateTime", emailDistribution.CreatedDateTime);
sqlCommand.Parameters.AddWithValue("@EmailMessageContent", emailDistribution.EmailMessageContent);
sqlCommand.Parameters.AddWithValue("@SendersLogin", emailDistribution.SendersLogin);
sqlCommand.Parameters.AddWithValue("@SendersDateTime", emailDistribution.SendersDateTime);
sqlCommand.Parameters.AddWithValue("@Send", emailDistribution.Send);
sqlCommand.Parameters.AddWithValue("@OperationMode", type);
SqlParameter IDParameter = new SqlParameter("@EmailDistribution_ID", SqlDbType.Int);
IDParameter.Direction = ParameterDirection.Output;
sqlCommand.Parameters.Add(IDParameter);
int email_Distribution = 0;
ExecuteNonQuery(sqlCommand);
return(email_Distribution = (int)IDParameter.Value);
}
}
protected virtual EmailDistribution GetEmailDistributionListFromreader(IDataReader reader)
{
EntityConverter <EmailDistribution> jobEmailDistributionExpenseEntity = new EntityConverter <EmailDistribution>();
EmailDistribution emailDistributionExpense = jobEmailDistributionExpenseEntity.Convert(reader);
return(emailDistributionExpense);
}
public List <EmailDistribution> GetEmailDistributionList(EmailDistribution emailDistribution, string type)
{
using (SqlConnection sqlConnection = new SqlConnection(this.ConnectionString))
{
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand("spGetEmailDistribution", sqlConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@EmailDistributionID", emailDistribution.EmailDistributionID);
sqlCommand.Parameters.AddWithValue("@Projectnumber", emailDistribution.Projectnumber);
sqlCommand.Parameters.AddWithValue("@OperationMode", type);
return(GetEmailDistributionCollectionFromReader(ExecuteReader(sqlCommand)));
}
}
