public int tblSendEventDetail_insert(SendEventDetailDTO dt) { return srdDao.tblSendEventDetail_insert(dt); }
public int tblSendEventDetail_insert(SendEventDetailDTO dt) { try { string sql = "INSERT INTO tblContentSendEventDetail(ContentSendEventID, Email, StartDate, EndDate, DayEnd, HoursEnd, MinuteEnd, SecondEnd, Status, ErrorType, MailSend,CustomerName) " + "VALUES(@ContentSendEventID, @Email, @StartDate, @EndDate, @DayEnd, @HoursEnd, @MinuteEnd, @SecondEnd, @Status, @ErrorType, @MailSend, @CustomerName) SELECT SCOPE_IDENTITY()"; SqlCommand cmd = new SqlCommand(sql, ConnectionData._MyConnection); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@ContentSendEventID", SqlDbType.Int).Value = dt.ContentSendEventID; cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = dt.Email; cmd.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = dt.StartDate; cmd.Parameters.Add("@EndDate", SqlDbType.DateTime).Value = dt.EndDate; cmd.Parameters.Add("@DayEnd", SqlDbType.Int).Value = dt.DayEnd; cmd.Parameters.Add("@HoursEnd", SqlDbType.Int).Value = dt.HoursEnd; cmd.Parameters.Add("@MinuteEnd", SqlDbType.Int).Value = dt.MinuteEnd; cmd.Parameters.Add("@SecondEnd", SqlDbType.Int).Value = dt.SecondEnd; cmd.Parameters.Add("@Status", SqlDbType.Bit).Value = dt.Status; cmd.Parameters.Add("@ErrorType", SqlDbType.VarChar).Value = dt.ErrorType; cmd.Parameters.Add("@MailSend", SqlDbType.NVarChar).Value = dt.MailSend; cmd.Parameters.Add("@CustomerName", SqlDbType.NVarChar).Value = dt.CustomerName; if (ConnectionData._MyConnection.State == ConnectionState.Closed) { ConnectionData._MyConnection.Open(); } cmd.ExecuteNonQuery(); return 1; } catch (Exception) { return 1; } }
private void logHistoryForSendEvent(int Id, string mailTo, string mailFrom, string name, bool status) { try { SendEventDetailDTO srdDto = new SendEventDetailDTO(); srdDto.ContentSendEventID = Id; srdDto.Email = mailTo; srdDto.StartDate = DateTime.Now; srdDto.EndDate = DateTime.Now; srdDto.DayEnd = DateTime.Now.Day; srdDto.HoursEnd = DateTime.Now.Hour; srdDto.MinuteEnd = DateTime.Now.Minute; srdDto.SecondEnd = DateTime.Now.Second; srdDto.MailSend = mailFrom; srdDto.CustomerName = name; srdDto.ErrorType = ""; srdDto.Status = status; sendDetailBUS.tblSendEventDetail_insert(srdDto); } catch (Exception) { } }