protected SendRegisterDTO getSendRegister()
{
try
{
UserLoginDTO userLogin = getUserLogin();
string fromMail = drlMailConfig.SelectedValue;
string groupTo = drlMailGroup.SelectedValue;
string startDate = txtStartDate.Text;
int contentId = int.Parse(drlContent.SelectedValue);
SendRegisterDTO srDto = new SendRegisterDTO()
{
AccountId = userLogin.UserId.ToString(),
ErrorType = 0,
SendContentId = contentId,
MailConfigID = int.Parse(fromMail),
GroupTo = int.Parse(groupTo),
SendType = 1,// Loại gửi bình thường
EndDate = DateTime.Now,
Status = 0 /*chua gui.*/
};
return srDto;
}
catch (Exception ex)
{
return null;
}
}
public void tblSendRegister_Update(SendRegisterDTO dt)
{
string sql = "UPDATE tblSendRegister SET " +
"AccountId = @AccountId, " +
"StartDate = @StartDate, " +
"EndDate = @EndDate, " +
"SendContentId = @SendContentId, " +
"SendType = @SendType, " +
"Status = @Status, " +
"MailConfigID = @MailConfigID, " +
"GroupTo = @GroupTo, " +
"ErrorType = @ErrorType WHERE Id = @Id";
SqlCommand cmd = new SqlCommand(sql, ConnectionData._MyConnection);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@Id", SqlDbType.Int).Value = dt.Id;
cmd.Parameters.Add("@AccountId", SqlDbType.VarChar).Value = dt.AccountId;
cmd.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = dt.StartDate;
cmd.Parameters.Add("@EndDate", SqlDbType.DateTime).Value = dt.EndDate;
cmd.Parameters.Add("@SendContentId", SqlDbType.Int).Value = dt.SendContentId;
cmd.Parameters.Add("@SendType", SqlDbType.Int).Value = dt.SendType;
cmd.Parameters.Add("@Status", SqlDbType.Int).Value = dt.Status;
cmd.Parameters.Add("@ErrorType", SqlDbType.Int).Value = dt.ErrorType;
cmd.Parameters.Add("@MailConfigID", SqlDbType.Int).Value = dt.MailConfigID;
cmd.Parameters.Add("@GroupTo", SqlDbType.Int).Value = dt.GroupTo;
if (ConnectionData._MyConnection.State == ConnectionState.Closed)
{
ConnectionData._MyConnection.Open();
}
cmd.ExecuteNonQuery();
cmd.Dispose();
}
public void tblSendRegister_Update(SendRegisterDTO dt)
{
srDao.tblSendRegister_Update(dt);
}
public void tblSendRegister_insert(SendRegisterDTO dt)
{
string sql = "INSERT INTO tblSendRegister(AccountId, StartDate, EndDate, SendContentId, SendType, Status, ErrorType, MailConfigID, GroupTo, subject, body) " +
"VALUES(@AccountId, @StartDate, @EndDate, @SendContentId, @SendType, @Status, @ErrorType, @MailConfigID, @GroupTo, @subject, @body)";
SqlCommand cmd = new SqlCommand(sql, ConnectionData._MyConnection);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@AccountId", SqlDbType.VarChar).Value = dt.AccountId;
cmd.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = dt.StartDate;
cmd.Parameters.Add("@EndDate", SqlDbType.DateTime).Value = dt.EndDate;
cmd.Parameters.Add("@SendContentId", SqlDbType.Int).Value = dt.SendContentId;
cmd.Parameters.Add("@SendType", SqlDbType.Int).Value = dt.SendType;
cmd.Parameters.Add("@Status", SqlDbType.Int).Value = dt.Status;
cmd.Parameters.Add("@ErrorType", SqlDbType.Int).Value = dt.ErrorType;
cmd.Parameters.Add("@MailConfigID", SqlDbType.Int).Value = dt.MailConfigID;
cmd.Parameters.Add("@GroupTo", SqlDbType.Int).Value = dt.GroupTo;
cmd.Parameters.Add("@subject", SqlDbType.NVarChar).Value = dt.Subject;
cmd.Parameters.Add("@body", SqlDbType.NVarChar).Value = dt.Body;
if (ConnectionData._MyConnection.State == ConnectionState.Closed)
{
ConnectionData._MyConnection.Open();
}
cmd.ExecuteNonQuery();
cmd.Dispose();
}
public void tblSendRegister_insert(SendRegisterDTO dt)
{
srDao.tblSendRegister_insert(dt);
}
