public void Insert() { DataSet Ds = new DataSet(); try { NSM.IdeaId = SIdeaId.ToString().Trim(); NSM.IDepID = SIDepID.ToString(); NSM.IDesID = SIDesID.ToString(); NSM.IEmpId = EmployeeIdTextBox.Text.ToString().TrimStart().TrimEnd(); NSM.Date = System.DateTime.Now.ToString("yyyy-MM-dd").ToString().Trim(); NSM.Subject = SubjectTextBox.Text.ToString().TrimStart().TrimEnd(); NSM.Benefits = BenefitsTextBox.Text.ToString().TrimStart().TrimEnd(); for (int i = 0; i < CategoryCheckBoxList.Items.Count; i++) { if (CategoryCheckBoxList.Items[i].Selected) { k = k + CategoryCheckBoxList.Items[i].Text + ", "; } } NSM.Category = k.ToString().TrimStart().TrimEnd(); NSM.Before = BeforeTextBox.Text.ToString().TrimStart().TrimEnd(); NSM.After = AfterTextBox.Text.ToString().TrimStart().TrimEnd(); if (ImageFileUpload1.HasFile) { extn = System.IO.Path.GetExtension(ImageFileUpload1.FileName); //path = Server.MapPath("\\PIMS\\UI\\Image\\"); path = Server.MapPath("..\\UI\\Image\\"); ImageName = ImageFileUpload1.FileName; ImageFileUpload1.SaveAs(path + ImageName); etn = ImageName; //Label1.Text = path; } else { etn = "No File"; } NSM.FileUpload1 = etn.ToString(); if (ImageFileUpload2.HasFile) { extn = System.IO.Path.GetExtension(ImageFileUpload2.FileName); // path = Server.MapPath("\\PIMS\\UI\\Image\\"); path = Server.MapPath("..\\UI\\Image\\"); ImageName = ImageFileUpload2.FileName; ImageFileUpload2.SaveAs(path + ImageName); etn = ImageName; //Label1.Text = path; } else { etn = "No File"; } NSM.FileUpload2 = etn.ToString(); if (ImageFileUpload3.HasFile) { extn = System.IO.Path.GetExtension(ImageFileUpload3.FileName); // path = Server.MapPath("\\PIMS\\UI\\Image\\"); path = Server.MapPath("..\\UI\\Image\\"); ImageName = ImageFileUpload3.FileName; ImageFileUpload3.SaveAs(path + ImageName); etn = ImageName; //Label1.Text = path; } else { etn = "No File"; } NSM.FileUpload3 = etn.ToString(); NSM.Status = status.ToString().TrimStart().TrimEnd(); NSM.Approved = Approved.ToString().Trim(); NSM.Remark2 = "UnRead"; NSM.Remark2 = Remark2.ToString().Trim(); NSM.Remark3 = Remark3.ToString().Trim(); NSM.Remark4 = Remark4.ToString().Trim(); NSM.SuggestionInsert(NSM); ClientScript.RegisterStartupScript(this.GetType(), "randomtext", "alertme('Your Suggestion Posted')", true); //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Your Suggestion Posted')", true); i = 1; Response.Redirect("Default.aspx?value=" + NSM.IEmpId, false); } catch (Exception) { //throw new Exception("Error Initializing Data Class." + Environment.NewLine + ex.Message); } }
public void TeamEvaluvationInsert() { CEmpEmailContents EECS = new CEmpEmailContents(); DataSet Ds = new DataSet(); try { int i = 0; int j = 0; string array1 = MailIdIMPTextBox.Text.ToString(); //string array = EmpDepTextBox.Text.ToString(); string ds = EmpIDIMPTextBox.Text.ToString(); string[] breakMysentence = ds.Split(','); string[] breakMysentence1 = array1.Split(','); string[] ena1 = new string[breakMysentence.Length]; string[] mail1 = new string[breakMysentence.Length]; foreach (string data in breakMysentence) { ena1[i] = data; i = i + 1; } foreach (string data1 in breakMysentence1) { mail1[j] = data1; j = j + 1; } DepIdAutoGeneretion(); for (int x = 0; x < ena1.Length; x++) { ComEvalInboxIDAutoGeneration(); DBM.SendId = SendID.ToString(); DBM.IdeaId = IMPIdeaIdTextBox.Text.ToString(); DBM.HEmployeeName = us1.ToString(); DBM.TempMail = array1.ToString(); DBM.TempId = ds.ToString(); DBM.Date = System.DateTime.Now.ToString("yyyy-MM-dd").ToString().Trim(); DBM.HEmployeeID = ena1[x].ToString().TrimStart().TrimEnd(); DBM.Email = mail1[x].ToString().TrimStart().TrimEnd(); DBM.Subject = SubjectIMPTextBox.Text.TrimStart().TrimEnd().ToString(); DBM.Discription = ContectIMPTextBox.Text.TrimStart().TrimEnd().ToString(); if (ImageFileUpload3.HasFile) { extn = System.IO.Path.GetExtension(ImageFileUpload3.FileName); // path = Server.MapPath("\\PIMS\\UI\\Image\\"); path = Server.MapPath("..\\UI\\Image\\"); ImageName = ImageFileUpload3.FileName; ImageFileUpload3.SaveAs(path + ImageName); etn = ImageName; //Label1.Text = path; } else { etn = "No File"; } DBM.FileUpload3 = etn.ToString(); DBM.Remark1 = "i"; DBM.Remark2 = "HOS"; string idof = txtHODid.Text;//Request.Form["hodid2"]; DBM.HODID = idof; DBM.ComInboxID = ComEvalInboxID.ToString(); DBM.DBMEmail = Session["Email"].ToString(); DBM.HosInboxInsert(DBM); } DBM.ImplTeamEvaInsert(DBM); string myscript = "alert ('Mail Send HOS');"; Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "MyScript", myscript, true); z = 1; //E.EmployeeInsert(E); //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('New Employee Record Is Added')", true); } catch (Exception e1) { //throw new Exception("Error Initializing Data Class." + Environment.NewLine + ex.Message); } }