/// <summary>
/// Load data
/// </summary>
private void LoadMail(string id)
{
MessagesData data = new MessagesData();
ITransaction tran = factory.GetLoadObject(data, id);
Execute(tran);
if (!HasError)
{
//Get Data
data = (MessagesData)tran.Result;
lblCC.Text = data.UserName;
lblSubject.Text = data.Subject;
ltrBody.Text = data.Body;
}
string sql = "Select A.* from UploadedFile A, UploadedFileMessageMap B Where A.UploadFileId = B.UploadFileId and B.MessageID = '" + id + "'";
SqlDatabase db = new SqlDatabase();
SqlCommand cm = db.CreateCommand(sql);
SqlDataAdapter da = new SqlDataAdapter(cm);
DataSet ds = new DataSet();
da.Fill(ds);
db.Close();
rptAttach.DataSource = ds.Tables[0].DefaultView;
rptAttach.DataBind();
//DataTable dt = new DataTable();
//dt = DbHelper.GetDataTable(sql);
//HtmlGenericControl newControl = new HtmlGenericControl("div");
//newControl.ID = "NEWControl" + 1 ;
//newControl.InnerHtml = "This is a dynamically created HTML server control.";
//lnkFile1.Text = "";
//lnkFile2.Text = "";
//lnkFile3.Text = "";
//lnkFile4.Text = "";
//lnkFile1.CommandArgument = "";
//lnkFile2.CommandArgument = "";
//lnkFile3.CommandArgument = "";
//lnkFile4.CommandArgument = "";
////int i = 1;
////foreach (DataRow dr in dt.Rows)
////{
//// string fileName = dr["fileName"].ToString();
//// string pathName = dr["pathFile"].ToString();
//// string orgFileName = dr["OrgFileName"].ToString();
//// switch (i)
//// {
//// case 1:
//// LinkButton lnkFile01 = new LinkButton();
//// lnkFile01.Text = orgFileName;
//// lnkFile01.CommandArgument = fileName;
//// lnkFile01.Command += new CommandEventHandler(btnFile_Click);
//// PlaceHolder1.Controls.Add(lnkFile01);
//// break;
//// case 2:
//// //lnkFile2.Text = orgFileName;
//// //lnkFile2.CommandArgument = fileName;
//// //PlaceHolder1.Controls.Add(newControl);
//// break;
//// case 3:
//// //lnkFile3.Text = orgFileName;
//// //lnkFile3.CommandArgument = fileName;
//// //PlaceHolder1.Controls.Add(newControl);
//// break;
//// case 4:
//// //lnkFile4.Text = orgFileName;
//// //lnkFile4.CommandArgument = fileName;
//// //PlaceHolder1.Controls.Add(newControl);
//// break;
//// case 5:
//// //lnkFile5.Text = orgFileName;
//// //lnkFile5.CommandArgument = fileName;
//// //PlaceHolder1.Controls.Add(newControl);
//// break;
//// }
//// i++;
////}
//lnkFile1.Text = "";
//lnkFile2.Text = "";
//lnkFile3.Text = "";
//lnkFile4.Text = "";
//lnkFile1.CommandArgument = "";
//lnkFile2.CommandArgument = "";
//lnkFile3.CommandArgument = "";
//lnkFile4.CommandArgument = "";
//int i = 1;
//foreach (DataRow dr in dt.Rows)
//{
// string fileName = dr["fileName"].ToString();
// string pathName = dr["pathFile"].ToString();
// string orgFileName = dr["OrgFileName"].ToString();
// switch (i)
// {
// case 1:
// lnkFile1.Text = orgFileName;
// lnkFile1.CommandArgument = fileName;
// btnFile1.CommandArgument = fileName;
// btnFile1.Visible = true;
// break;
// case 2:
// lnkFile2.Text = orgFileName;
// lnkFile2.CommandArgument = fileName;
// btnFile2.CommandArgument = fileName;
// btnFile2.Visible = true;
// break;
// case 3:
// lnkFile3.Text = orgFileName;
// lnkFile3.CommandArgument = fileName;
// btnFile3.CommandArgument = fileName;
// btnFile3.Visible = true;
// break;
// case 4:
// lnkFile4.Text = orgFileName;
// lnkFile4.CommandArgument = fileName;
// btnFile4.CommandArgument = fileName;
// btnFile4.Visible = true;
// break;
// case 5:
// lnkFile5.Text = orgFileName;
// lnkFile5.CommandArgument = fileName;
// btnFile5.CommandArgument = fileName;
// btnFile5.Visible = true;
// break;
// }
// i++;
//}
}
/// <summary>
/// Load data
/// </summary>
private void LoadMail(string id)
{
MessagesData data = new MessagesData();
ITransaction tran = factory.GetLoadObject(data, id);
Execute(tran);
if (!HasError)
{
//Get Data
data = (MessagesData)tran.Result;
lblCC.Text = data.UserName;
lblSubject.Text = data.Subject;
ltrBody.Text = data.Body;
}
string sql = "Select A.* from UploadedFile A, UploadedFileMessageMap B Where A.UploadFileId = B.UploadFileId and B.MessageID = '" + id + "'";
SqlDatabase db = new SqlDatabase();
SqlCommand cm = db.CreateCommand(sql);
SqlDataAdapter da = new SqlDataAdapter(cm);
DataSet ds = new DataSet();
da.Fill(ds);
db.Close();
rptAttach.DataSource = ds.Tables[0].DefaultView;
rptAttach.DataBind();
//DataTable dt = new DataTable();
//dt = DbHelper.GetDataTable(sql);
//lnkFile1.Text = "";
//lnkFile2.Text = "";
//lnkFile3.Text = "";
//lnkFile4.Text = "";
//lnkFile1.CommandArgument = "";
//lnkFile2.CommandArgument = "";
//lnkFile3.CommandArgument = "";
//lnkFile4.CommandArgument = "";
//int i = 1;
//foreach (DataRow dr in dt.Rows)
//{
// string fileName = dr["fileName"].ToString();
// string pathName = dr["pathFile"].ToString();
// string orgFileName = dr["OrgFileName"].ToString();
// switch (i)
// {
// case 1:
// lnkFile1.Text = orgFileName;
// lnkFile1.CommandArgument = fileName;
// btnFile1.CommandArgument = fileName;
// btnFile1.Visible = true;
// break;
// case 2:
// lnkFile2.Text = orgFileName;
// lnkFile2.CommandArgument = fileName;
// btnFile2.CommandArgument = fileName;
// btnFile2.Visible = true;
// break;
// case 3:
// lnkFile3.Text = orgFileName;
// lnkFile3.CommandArgument = fileName;
// btnFile3.CommandArgument = fileName;
// btnFile3.Visible = true;
// break;
// case 4:
// lnkFile4.Text = orgFileName;
// lnkFile4.CommandArgument = fileName;
// btnFile4.CommandArgument = fileName;
// btnFile4.Visible = true;
// break;
// case 5:
// lnkFile5.Text = orgFileName;
// lnkFile5.CommandArgument = fileName;
// btnFile5.CommandArgument = fileName;
// btnFile5.Visible = true;
// break;
// }
// i++;
//}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if ("1".Equals(hidReply.Value) && !String.IsNullOrEmpty(hidMessageId.Value))
{
DbHelper.ExecuteNonQuery("Update UsersMessagesMapped Set isReply = 1 Where UserName = '******' and MessageId = '" + hidMessageId.Value + "'");
}
mvMessage.CheckRequired(txtToCC, "Người nhận: cần nhập thông tin");
mvMessage.CheckRequired(txtSubject, "Tiêu đề: cần nhập thông tin");
string uploadFileId = "";
string[] cc = txtToCC.Text.Replace(System.Environment.NewLine, string.Empty).Split(';');
for (int i = 0; i < cc.Length; i++)
{
if (!String.IsNullOrEmpty(cc[i]))
{
int count = DbHelper.GetCount("Select count(*) from aspnet_Users where UserName = '******'");
if (count == 0)
mvMessage.AddError(cc[i] + ": User này không tồn tại");
}
}
if (!String.IsNullOrEmpty(txtToBCC.Text))
{
string[] bcc = txtToBCC.Text.Replace(System.Environment.NewLine, string.Empty).Split(';');
for (int i = 0; i < bcc.Length; i++)
{
if (!String.IsNullOrEmpty(bcc[i]))
{
int count = DbHelper.GetCount("Select count(*) from aspnet_Users where UserName = '******'");
if (count == 0)
mvMessage.AddError(bcc[i] + ": User này không tồn tại");
}
}
}
if (!mvMessage.IsValid)
return;
if ((File1.PostedFile != null) && (File1.PostedFile.ContentLength > 0))
{
string fn = System.IO.Path.GetFileName(File1.PostedFile.FileName);
string filename = DateTime.Now.ToString("yyyyMMddHHmmss") + fn;
string SaveLocation = Server.MapPath("Mail") + "\\File\\" + filename;
try
{
File1.PostedFile.SaveAs(SaveLocation);
UploadedFileData data = new UploadedFileData();
ITransaction tran = factory.GetInsertObject(data);
data.OrgFileName = fn;
data.FileName = filename;
data.PathFile = SaveLocation;
data.ModifiedBy = Page.User.Identity.Name;
data.CreatedBy = Page.User.Identity.Name;
data.Created = DateTime.Now.ToString("yyyyMMddHHmmss");
data.Modified = DateTime.Now.ToString("yyyyMMddHHmmss");
Execute(tran);
if (!HasError)
{
uploadFileId += ";" + data.UploadFileId;
}
else
{
mvMessage.AddError("Lỗi phát sinh");
return;
}
}
catch (Exception ex)
{
Response.Write("Error: " + ex.Message);
}
}
if ((File2.PostedFile != null) && (File2.PostedFile.ContentLength > 0))
{
string fn = System.IO.Path.GetFileName(File2.PostedFile.FileName);
string filename = DateTime.Now.ToString("yyyyMMddHHmmss") + fn;
string SaveLocation = Server.MapPath("Mail") + "\\File\\" + filename;
try
{
File2.PostedFile.SaveAs(SaveLocation);
UploadedFileData data = new UploadedFileData();
ITransaction tran = factory.GetInsertObject(data);
data.OrgFileName = fn;
data.FileName = filename;
data.PathFile = SaveLocation;
data.ModifiedBy = Page.User.Identity.Name;
data.CreatedBy = Page.User.Identity.Name;
data.Created = DateTime.Now.ToString("yyyyMMddHHmmss");
data.Modified = DateTime.Now.ToString("yyyyMMddHHmmss");
Execute(tran);
if (!HasError)
{
uploadFileId += ";" + data.UploadFileId;
}
else
{
mvMessage.AddError("Lỗi phát sinh");
return;
}
}
catch (Exception ex)
{
Response.Write("Error: " + ex.Message);
}
}
if ((File3.PostedFile != null) && (File3.PostedFile.ContentLength > 0))
{
string fn = System.IO.Path.GetFileName(File3.PostedFile.FileName);
string filename = DateTime.Now.ToString("yyyyMMddHHmmss") + fn;
string SaveLocation = Server.MapPath("Mail") + "\\File\\" + filename;
try
{
File3.PostedFile.SaveAs(SaveLocation);
UploadedFileData data = new UploadedFileData();
ITransaction tran = factory.GetInsertObject(data);
data.OrgFileName = fn;
data.FileName = filename;
data.PathFile = SaveLocation;
data.ModifiedBy = Page.User.Identity.Name;
data.CreatedBy = Page.User.Identity.Name;
data.Created = DateTime.Now.ToString("yyyyMMddHHmmss");
data.Modified = DateTime.Now.ToString("yyyyMMddHHmmss");
Execute(tran);
if (!HasError)
{
uploadFileId += ";" + data.UploadFileId;
}
else
{
mvMessage.AddError("Lỗi phát sinh");
return;
}
}
catch (Exception ex)
{
Response.Write("Error: " + ex.Message);
}
}
if ((File4.PostedFile != null) && (File4.PostedFile.ContentLength > 0))
{
string fn = System.IO.Path.GetFileName(File4.PostedFile.FileName);
string filename = DateTime.Now.ToString("yyyyMMddHHmmss") + fn;
string SaveLocation = Server.MapPath("Mail") + "\\File\\" + filename;
try
{
File4.PostedFile.SaveAs(SaveLocation);
UploadedFileData data = new UploadedFileData();
ITransaction tran = factory.GetInsertObject(data);
data.OrgFileName = fn;
data.FileName = filename;
data.PathFile = SaveLocation;
data.ModifiedBy = Page.User.Identity.Name;
data.CreatedBy = Page.User.Identity.Name;
data.Created = DateTime.Now.ToString("yyyyMMddHHmmss");
data.Modified = DateTime.Now.ToString("yyyyMMddHHmmss");
Execute(tran);
if (!HasError)
{
uploadFileId += ";" + data.UploadFileId;
}
else
{
mvMessage.AddError("Lỗi phát sinh");
return;
}
}
catch (Exception ex)
{
Response.Write("Error: " + ex.Message);
}
}
if ((File5.PostedFile != null) && (File5.PostedFile.ContentLength > 0))
{
string fn = System.IO.Path.GetFileName(File5.PostedFile.FileName);
string filename = DateTime.Now.ToString("yyyyMMddHHmmss") + fn;
string SaveLocation = Server.MapPath("Mail") + "\\File\\" + filename;
try
{
File5.PostedFile.SaveAs(SaveLocation);
UploadedFileData data = new UploadedFileData();
ITransaction tran = factory.GetInsertObject(data);
data.OrgFileName = fn;
data.FileName = filename;
data.PathFile = SaveLocation;
data.ModifiedBy = Page.User.Identity.Name;
data.CreatedBy = Page.User.Identity.Name;
data.Created = DateTime.Now.ToString("yyyyMMddHHmmss");
data.Modified = DateTime.Now.ToString("yyyyMMddHHmmss");
Execute(tran);
if (!HasError)
{
uploadFileId += ";" + data.UploadFileId;
}
else
{
mvMessage.AddError("Lỗi phát sinh");
return;
}
}
catch (Exception ex)
{
Response.Write("Error: " + ex.Message);
}
}
//using (SqlConnection con = new SqlConnection(Gnt.Configuration.ApplicationConfiguration.ConnectionString))
//{
// con.Open();
// SqlCommand cmd = new SqlCommand("insert into RichTextBoxData(RichTextData) values(@Richtextbox)", con);
// cmd.Parameters.AddWithValue("@Richtextbox", FreeTextBox1.Text);
// cmd.ExecuteNonQuery();
// con.Close();
// FreeTextBox1.Text = "";
// lbltxt.Text = "Data Inserted Successfully";
// BindGridview();
//}
MessagesData dataM = new MessagesData();
ITransaction tranM = factory.GetInsertObject(dataM);
dataM.Subject = txtSubject.Text.Trim();
dataM.Body = txtContent.Text;
dataM.UserName = Page.User.Identity.Name;
dataM.DelFlag = "0";
dataM.CcUser = txtToCC.Text;
dataM.BccUser = txtToBCC.Text;
dataM.FlagId = drpFlag.SelectedValue;
dataM.BuildingId = Func.ParseString(Session["__BUILDINGID__"]);
dataM.Updator = Page.User.Identity.Name;
dataM.Creator = Page.User.Identity.Name;
dataM.Created = DateTime.Now.ToString("yyyyMMddHHmmss");
dataM.Updated = DateTime.Now.ToString("yyyyMMddHHmmss");
Execute(tranM);
if (!HasError)
{
OperationLogger.WriteInfo(Constants.LogOperationAlbumId, Constants.LogActionInsertId, "Tạo Mới Thông Tin Thành Công", Page.User.Identity.Name);
string MessageId = dataM.MessageID;
using (SqlConnection rConn = new SqlConnection(Gnt.Configuration.ApplicationConfiguration.ConnectionString))
{
rConn.Open();
using (SqlCommand cm = new SqlCommand("sp_AddMail", rConn))
{
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("@MessageId", MessageId);
cm.Parameters.AddWithValue("@FlagId", drpFlag.SelectedValue);
cm.Parameters.AddWithValue("@UploadFileId", uploadFileId);
cm.Parameters.AddWithValue("@BuildingId", Func.ParseString(Session["__BUILDINGID__"]));
cm.Parameters.AddWithValue("@UserNames", txtToCC.Text.Replace(System.Environment.NewLine, string.Empty) + ";" + txtToBCC.Text.Replace(System.Environment.NewLine, string.Empty));
cm.Parameters.AddWithValue("@Created", DateTime.Now.ToString("yyyyMMddHHmmss"));
cm.Parameters.AddWithValue("@CreatedBy", Page.User.Identity.Name);
cm.ExecuteNonQuery();
}
rConn.Close();
mvMessage.SetCompleteMessage("Thực Hiện Thành Công");
}
}
else
{
OperationLogger.WriteError(Constants.LogOperationAlbumId, Constants.LogActionInsertId, "Tạo Mới Thông Tin Phát Sinh Lỗi", Page.User.Identity.Name);
mvMessage.AddError("Tạo Mới Thông Tin Phát Sinh Lỗi");
}
ShowData("1", "");
}
