public static CEmpEmailContents CheckingUpdate(string emp) { NewSuggestionModel NSM = new NewSuggestionModel(); Employee E = new Employee(); CEmpEmailContents tdp = new CEmpEmailContents(); DataBankManager DBM = new DataBankManager(); //Console.Write(emp); //Console.Write("My first ASP script!"); try { try { if (emp != "" && emp != "System.Data.DataRowView") { Console.Write(emp); DBM.IdeaId = emp.ToString().Trim(); DataSet DS = new DataSet(); DS = DBM.ComEvalUpdateDashboardProcess(DBM); tdp.Type = DS.Tables[0].Rows[0].ItemArray[0].ToString(); tdp.Reason = DS.Tables[0].Rows[0].ItemArray[1].ToString(); //SIDepID = DS.Tables[0].Rows[0].ItemArray[1].ToString(); tdp.Response = DS.Tables[0].Rows[0].ItemArray[2].ToString(); tdp.Sempid = DS.Tables[0].Rows[0].ItemArray[3].ToString(); tdp.Sempname = DS.Tables[0].Rows[0].ItemArray[4].ToString(); //SIDesID = DS.Tables[0].Rows[0].ItemArray[3].ToString(); } else { } return(tdp); } catch (Exception ex) { throw new Exception("Error Initializing Data Class." + Environment.NewLine + ex.Message); } } catch (Exception ex) { 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); } }
public static CEmpEmailContents MailContent(string idea) { CEmpEmailContents EECS = new CEmpEmailContents(); Mailling M = new Mailling(); DataBankManager DBM = new Models.DataBankManager(); DataSet DS = new DataSet(); try { //RepeaterItem item = (sender as TextBox).Parent as RepeaterItem; //index = int.Parse((item.FindControl("lblImageNameTextBox") as Label).Text); index = idea.ToString(); DBM.IdeaId = idea.ToString(); //Session["IdeaID"] = idea.ToString(); DS = DBM.ComtEvalRepViewUpatePannel(DBM); EECS.fromTag = "From : "; EECS.EIDTag = "Employee ID : "; EECS.DepTag = "Department : "; //EECS.DesTag = "Designaton : "; EECS.CatTag = "Category : "; EECS.IdIdTag = "Idea ID: "; EECS.BefTag = "Before : "; EECS.AftTag = "After : "; EECS.BenTag = "Benefits : "; EECS.upl1Tag = "FileUpload1"; EECS.upl2Tag = "FileUpload2"; EECS.upl3Tag = "FileUpload3"; EECS.SfromTag = "From : "; EECS.SEIDTag = "Employee ID : "; EECS.SDepTag = "Department : "; //EECS.DesTag = "Designaton : "; EECS.cmtid = idea.ToString(); EECS.IdeaIdTag = DS.Tables[0].Rows[0].ItemArray[8].ToString(); idea = DS.Tables[0].Rows[0].ItemArray[8].ToString(); EECS.Sempname = DS.Tables[0].Rows[0].ItemArray[2].ToString(); EECS.MailID = DS.Tables[0].Rows[0].ItemArray[5].ToString(); EECS.Sempid = DS.Tables[0].Rows[0].ItemArray[3].ToString(); EECS.SDepartment = DS.Tables[0].Rows[0].ItemArray[4].ToString(); //EECS.Designation = DS.Tables[0].Rows[0].ItemArray[3].ToString(); EECS.SDate = DS.Tables[0].Rows[0].ItemArray[1].ToString(); EECS.SSubject = DS.Tables[0].Rows[0].ItemArray[6].ToString(); EECS.SContent = DS.Tables[0].Rows[0].ItemArray[7].ToString(); EECS.empid = DS.Tables[0].Rows[0].ItemArray[9].ToString(); EECS.empname = DS.Tables[0].Rows[0].ItemArray[10].ToString(); EECS.Department = DS.Tables[0].Rows[0].ItemArray[11].ToString(); EECS.Designation = DS.Tables[0].Rows[0].ItemArray[12].ToString(); EECS.category = DS.Tables[0].Rows[0].ItemArray[13].ToString(); EECS.Benifit = DS.Tables[0].Rows[0].ItemArray[14].ToString(); EECS.Date = DS.Tables[0].Rows[0].ItemArray[15].ToString(); EECS.UpLoad1 = DS.Tables[0].Rows[0].ItemArray[24].ToString(); // EEC.upload1 = "/PIMS/UI/Image/" + EEC.UpLoad1; EECS.upload1 = "../UI/Image/" + EECS.UpLoad1; EECS.UpLoad2 = DS.Tables[0].Rows[0].ItemArray[25].ToString(); //EEC.upload2 = "/PIMS/UI/Image/" + EEC.UpLoad2; EECS.upload2 = "../UI/Image/" + EECS.UpLoad2; EECS.UpLoad3 = DS.Tables[0].Rows[0].ItemArray[26].ToString(); // EEC.upload3 = "/PIMS/UI/Image/" + EEC.UpLoad3; EECS.upload3 = "../UI/Image/" + EECS.UpLoad3; EECS.subject = DS.Tables[0].Rows[0].ItemArray[16].ToString(); EECS.Before = DS.Tables[0].Rows[0].ItemArray[17].ToString(); EECS.After = DS.Tables[0].Rows[0].ItemArray[18].ToString(); EECS.Reply = " Reply "; EECS.Status = DS.Tables[0].Rows[0].ItemArray[20].ToString(); EECS.SReason = DS.Tables[0].Rows[0].ItemArray[22].ToString(); EECS.SResponse = DS.Tables[0].Rows[0].ItemArray[21].ToString(); EECS.SenderID = DS.Tables[0].Rows[0].ItemArray[23].ToString(); return(EECS); } catch (Exception ex) { throw new Exception("Error Initializing Data Class." + Environment.NewLine + ex.Message); } //DataSet DS = new DataSet(); //DS = M.Repeatersearch(M); //fromTag.InnerHtml = "From : "; //EIDTag.InnerHtml = "Employee ID : "; //DepTag.InnerHtml = "Department : "; //DesTag.InnerHtml = "Designaton : "; //CatTag.InnerHtml = "Category : "; //BefTag.InnerHtml = "Before : "; //AftTag.InnerHtml = "After : "; //BenTag.InnerHtml = "Benefits : "; //EmployeeNameTag.InnerHtml = DS.Tables[0].Rows[0].ItemArray[1].ToString(); //EmployeeIDTag.InnerHtml = DS.Tables[0].Rows[0].ItemArray[0].ToString(); //DepartmentTag.InnerHtml = DS.Tables[0].Rows[0].ItemArray[2].ToString(); //DesignationTag.InnerHtml = DS.Tables[0].Rows[0].ItemArray[3].ToString(); //TimeTag.InnerHtml = DS.Tables[0].Rows[0].ItemArray[4].ToString(); //CategoryTag.InnerHtml = DS.Tables[0].Rows[0].ItemArray[5].ToString(); //SubjectTag.InnerHtml = DS.Tables[0].Rows[0].ItemArray[6].ToString(); //BeforeTag.InnerHtml = DS.Tables[0].Rows[0].ItemArray[7].ToString(); //AfterTag.InnerHtml = DS.Tables[0].Rows[0].ItemArray[8].ToString(); //BenefitsTag.InnerHtml = DS.Tables[0].Rows[0].ItemArray[9].ToString(); }
public static CEmpEmailContents getDetails(string idea) { CEmpEmailContents EECS = new CEmpEmailContents(); Mailling M = new Mailling(); DataBankManager DBM = new Models.DataBankManager(); Employee em = new Employee(); DataSet DS = new DataSet(); HOSModule hos = new HOSModule(); try { index = idea.ToString(); em.IdeaID = idea.ToString(); //Session["IdeaID"] = idea.ToString(); DS = hos.getEmailbySno(idea, "header"); EECS.fromTag = "From : "; EECS.EIDTag = "Employee ID : "; EECS.DepTag = "Department : "; //EECS.DesTag = "Designaton : "; EECS.CatTag = "Category : "; EECS.IdIdTag = "Idea ID: "; EECS.BefTag = "Before : "; EECS.AftTag = "After : "; EECS.BenTag = "Benefits : "; EECS.upl1Tag = "FileUpload1"; EECS.upl2Tag = "FileUpload2"; EECS.upl3Tag = "FileUpload3"; EECS.SfromTag = "From : "; EECS.SEIDTag = "Employee ID : "; EECS.SDepTag = "Department : "; //EECS.DesTag = "Designaton : "; EECS.cmtid = idea.ToString(); EECS.IdeaIdTag = DS.Tables[0].Rows[0].ItemArray[8].ToString(); idea = DS.Tables[0].Rows[0].ItemArray[8].ToString(); EECS.Sempname = DS.Tables[0].Rows[0].ItemArray[2].ToString(); EECS.MailID = DS.Tables[0].Rows[0].ItemArray[5].ToString(); EECS.Sempid = DS.Tables[0].Rows[0].ItemArray[3].ToString(); EECS.SDepartment = DS.Tables[0].Rows[0].ItemArray[4].ToString(); //EECS.Designation = DS.Tables[0].Rows[0].ItemArray[3].ToString(); EECS.SDate = DS.Tables[0].Rows[0].ItemArray[1].ToString(); EECS.SSubject = DS.Tables[0].Rows[0].ItemArray[6].ToString(); EECS.SContent = DS.Tables[0].Rows[0].ItemArray[7].ToString(); EECS.empid = DS.Tables[0].Rows[0].ItemArray[9].ToString(); EECS.empname = DS.Tables[0].Rows[0].ItemArray[10].ToString(); EECS.Department = DS.Tables[0].Rows[0].ItemArray[11].ToString(); EECS.Designation = DS.Tables[0].Rows[0].ItemArray[12].ToString(); EECS.category = DS.Tables[0].Rows[0].ItemArray[13].ToString(); EECS.Benifit = DS.Tables[0].Rows[0].ItemArray[14].ToString(); EECS.Date = DS.Tables[0].Rows[0].ItemArray[15].ToString(); EECS.UpLoad1 = DS.Tables[0].Rows[0].ItemArray[24].ToString(); // EEC.upload1 = "/PIMS/UI/Image/" + EEC.UpLoad1; EECS.upload1 = "../UI/Image/" + EECS.UpLoad1; EECS.UpLoad2 = DS.Tables[0].Rows[0].ItemArray[25].ToString(); //EEC.upload2 = "/PIMS/UI/Image/" + EEC.UpLoad2; EECS.upload2 = "../UI/Image/" + EECS.UpLoad2; EECS.UpLoad3 = DS.Tables[0].Rows[0].ItemArray[26].ToString(); // EEC.upload3 = "/PIMS/UI/Image/" + EEC.UpLoad3; EECS.upload3 = "../UI/Image/" + EECS.UpLoad3; EECS.subject = DS.Tables[0].Rows[0].ItemArray[16].ToString(); EECS.Before = DS.Tables[0].Rows[0].ItemArray[17].ToString(); EECS.After = DS.Tables[0].Rows[0].ItemArray[18].ToString(); EECS.Reply = " Implementation Team Information "; EECS.Status = DS.Tables[0].Rows[0].ItemArray[20].ToString(); EECS.SReason = DS.Tables[0].Rows[0].ItemArray[22].ToString(); EECS.SResponse = DS.Tables[0].Rows[0].ItemArray[21].ToString(); EECS.SenderID = DS.Tables[0].Rows[0].ItemArray[23].ToString(); return(EECS); } catch (Exception ex) { throw new Exception("Error Initializing Data Class." + Environment.NewLine + ex.Message); } }