public int UpdateObj(MailTemplateFile obj)
{
int kq = 0;
SqlTransaction transaction = null;
try
{
if (obj != null)
{
SqlConnection sqlConnect = dbclass.taoketnoi();
SqlCommand sqlCommand = sqlConnect.CreateCommand();
transaction = sqlConnect.BeginTransaction("Transaction");
sqlCommand.Connection = sqlConnect;
sqlCommand.Transaction = transaction;
sqlCommand.CommandText = "update MAIL_TEMPLATE set Name=N'" + obj.Name + "', [Description] =N'" + obj.Description + "', [Subject]=N'" + obj.Subject + "', Content=N'" + obj.Content + "', MailSendId=" + obj.MailSendId + ", ListMailReceiveId='" + obj.ListMailReceiveId + "' where Id =" + obj.Id + " and IsDeleted=0";
var result1 = sqlCommand.ExecuteNonQuery();
if (result1 != 0)
{
if (obj.listFileId != null && obj.listFileId.Count > 0)
{
sqlCommand.CommandText = "select Id from MAIL_T_M where IsDeleted=0 and MailTemplateId=" + obj.Id;
SqlDataReader dr = sqlCommand.ExecuteReader();
List <string> listId = new List <string>();
while (dr.Read())
{
listId.Add(dr[0].ToString().Trim());
}
sqlCommand.Dispose();
dr.Dispose();
if (listId.Count > 0)
{
foreach (var id in listId)
{
sqlCommand.CommandText = "update MAIL_T_M set IsDeleted=1 where Id =" + id;
sqlCommand.ExecuteNonQuery();
}
}
foreach (var fileId in obj.listFileId)
{
sqlCommand.CommandText = "insert into MAIL_T_M (MailTemplateId, MailFileId) values(" + obj.Id + ", " + fileId + ")";
sqlCommand.ExecuteNonQuery();
}
}
}
transaction.Commit();
sqlConnect.Close();
kq = 1;
}
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
return(kq);
}
public int AddObj(MailTemplateFile obj)
{
int kq = 0;
SqlTransaction transaction = null;
try
{
if (obj != null)
{
SqlConnection sqlConnect = dbclass.taoketnoi();
SqlCommand sqlCommand = sqlConnect.CreateCommand();
transaction = sqlConnect.BeginTransaction("Transaction");
sqlCommand.Connection = sqlConnect;
sqlCommand.Transaction = transaction;
sqlCommand.CommandText = "insert into MAIL_TEMPLATE (Name, Description, Subject, Content, MailSendId, ListMailReceiveId) values(N'" + obj.Name + "', N'" + obj.Description + "', N'" + obj.Subject + "', N'" + obj.Content + "', " + obj.MailSendId + ", '" + obj.ListMailReceiveId + "' )";
var result1 = sqlCommand.ExecuteNonQuery();
if (result1 != 0)
{
if (obj.listFileId != null && obj.listFileId.Count > 0)
{
DataTable dt = new DataTable();
sqlCommand.CommandText = "select TOP 1 * from MAIL_TEMPLATE where Name like N'" + obj.Name + "' and MailSendId=" + obj.MailSendId + " and IsDeleted=0 order by Id desc";
dt.Load(sqlCommand.ExecuteReader());
if (dt != null && dt.Rows.Count > 0)
{
int id = 0;
int.TryParse(dt.Rows[0]["Id"].ToString(), out id);
if (id != 0)
{
foreach (var fileId in obj.listFileId)
{
sqlCommand.CommandText = "insert into MAIL_T_M (MailTemplateId, MailFileId) values(" + id + ", " + fileId + ")";
sqlCommand.ExecuteNonQuery();
}
}
}
}
}
transaction.Commit();
sqlConnect.Close();
kq = 1;
}
}
catch (Exception ex)
{
try
{
transaction.Rollback();
}
catch (Exception ex2)
{
throw ex2;
}
throw ex;
}
return(kq);
}
