public void tblContentSendEvent_insert(ContentSendEventDTO dt)
{
string sql = "INSERT INTO tblContentSendEvent(EventId, ContentId, HourSend) " +
"VALUES(@EventId, @ContentId, @HourSend)";
SqlCommand cmd = new SqlCommand(sql, ConnectionData._MyConnection);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@EventId", SqlDbType.Int).Value = dt.EventId;
cmd.Parameters.Add("@ContentId", SqlDbType.NVarChar).Value = dt.ContentId;
cmd.Parameters.Add("@HourSend", SqlDbType.NVarChar).Value = dt.HourSend;
cmd.ExecuteNonQuery();
cmd.Dispose();
}
public int tblContentSendEvent_Update(ContentSendEventDTO dt)
{
return cseDao.tblContentSendEvent_Update(dt);
}
public void tblContentSendEvent_insert(ContentSendEventDTO dt)
{
cseDao.tblContentSendEvent_insert(dt);
}
public int tblContentSendEvent_Update(ContentSendEventDTO dt)
{
string sql = "UPDATE tblContentSendEvent SET " +
"EventId = @EventId, " +
"ContentId = @ContentId, " +
"HourSend = @HourSend " +
" 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("@EventId", SqlDbType.Int).Value = dt.EventId;
cmd.Parameters.Add("@ContentId", SqlDbType.NVarChar).Value = dt.ContentId;
cmd.Parameters.Add("@HourSend", SqlDbType.NVarChar).Value = dt.HourSend;
int rs = cmd.ExecuteNonQuery();
cmd.Dispose();
return rs;
}
protected void saveContentSendEvent(int eventId)
{
try
{
ContentSendEventBUS cseBus = new ContentSendEventBUS();
DataTable dtContent = (DataTable)Session["listContentSendEvent"];
if (dtContent.Rows.Count > 0)
{
for (int i = 0; i < dtContent.Rows.Count; i++)
{
DataRow row = dtContent.Rows[i];
ContentSendEventDTO cseDto = new ContentSendEventDTO();
cseDto.Id = int.Parse(row["Id"].ToString());
cseDto.EventId = eventId;
cseDto.ContentId = int.Parse(row["ContentId"].ToString());
cseDto.HourSend = int.Parse(row["HourSend"].ToString());
cseDto.Subject = row["Subject"] + "";
cseDto.Body = row["Body"] + "";
int rsUpdate = cseBus.tblContentSendEvent_Update(cseDto);
if (rsUpdate <= 0)
{
cseBus.tblContentSendEvent_insert(cseDto);
SendContentDTO scDTO = new SendContentDTO();
scDTO = getContentDTO();
int contentID = new SendContentBUS().tblSendContent_insert(scDTO);
}
}
}
}
catch (Exception ex)
{
logs.Error(userLogin.Username + "Create-Event - btnSaveContent_Click", ex);
}
}
