/// <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", ""); }