public void search() { try { if (EmployeeIDTextBox.Text != "" && EmployeeIDTextBox.Text != "System.Data.DataRowView") { RL.HEmployeeID = EmployeeIDTextBox.Text.ToString().Trim(); DataSet DS = new DataSet(); DS = RL.LoginSearch(RL); P = DS.Tables[0].Rows[0].ItemArray[0].ToString(); EM = DS.Tables[0].Rows[0].ItemArray[1].ToString(); mailid = DS.Tables[0].Rows[0].ItemArray[2].ToString(); chk = DS.Tables[0].Rows[0].ItemArray[3].ToString(); firstlogin = DS.Tables[0].Rows[0].ItemArray[4].ToString(); Rmk = DS.Tables[0].Rows[0].ItemArray[5].ToString(); } else { // Label1.Visible = true; // Label1.Text = "Enter the Employee Id"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "swal('Enter the Employee Id','','warning')", true); } } catch (Exception e) { //Label1.Visible = true; //Label1.Text = "User Name and Password Incorrect"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "swal('User Name and Password Incorrect','','warning')", true); } }
public static CESEmpEmailContents Checking(string IdeaID) { CommiteeEvalSend NM = new CommiteeEvalSend(); Mailling M = new Mailling(); Employee E = new Employee(); CESEmpEmailContents EEC = new CESEmpEmailContents(); string chk; RegistrationLogin RL = new RegistrationLogin(); //Console.Write(emp); //Console.Write("My first ASP script!"); try { try { if ((IdeaID != "") && (IdeaID != "System.Data.DataRowView")) { Console.Write(IdeaID); M.IdeaId = IdeaID.ToString().Trim(); DataSet DS = new DataSet(); DS = M.DBMReplyCE(M); chk = DS.Tables[0].Rows[0].ItemArray[0].ToString(); if (chk != "Empty") { EEC.RIdeaID = DS.Tables[0].Rows[0].ItemArray[0].ToString(); EEC.REmpID = DS.Tables[0].Rows[0].ItemArray[1].ToString(); EEC.RMail = DS.Tables[0].Rows[0].ItemArray[2].ToString(); EEC.RSub = DS.Tables[0].Rows[0].ItemArray[3].ToString(); EEC.RCon = DS.Tables[0].Rows[0].ItemArray[4].ToString(); RL.HEmployeeID = EEC.REmpID; DS = RL.LoginSearch(RL); EEC.REmpName = DS.Tables[0].Rows[0].ItemArray[1].ToString(); } } else if (IdeaID == "") { EEC.ErrorLabel = "Check the Employee ID "; } else { EEC.ErrorLabel = "1"; } } catch (Exception ex) { EEC.ErrorLabel = "1"; } return(EEC); } catch (Exception ex) { throw new Exception("Error Initializing Data Class." + Environment.NewLine + ex.Message); } }
public static EmpEmailContent MailContent(string idea) { EmpEmailContent EEC = new EmpEmailContent(); Mailling M = new Mailling(); DataSet DS = new DataSet(); RegistrationLogin RL = new RegistrationLogin(); try { int i = 0; //RepeaterItem item = (sender as TextBox).Parent as RepeaterItem; //index = int.Parse((item.FindControl("lblImageNameTextBox") as Label).Text); M.IdeaId = idea.ToString(); DS = M.Repeatersearch(M); EEC.fromTag = "From : "; EEC.EIDTag = "Employee ID : "; EEC.DepTag = "Department : "; EEC.DesTag = "Designaton : "; EEC.CatTag = "Category : "; EEC.IdIdTag = "Idea ID: "; EEC.BefTag = "Before : "; EEC.AftTag = "After : "; EEC.BenTag = "Benefits : "; EEC.upl1Tag = "FileUpload1"; EEC.upl2Tag = "FileUpload2"; EEC.upl3Tag = "FileUpload3"; EEC.IdeaIdTag = idea.ToString(); EEC.empname = DS.Tables[0].Rows[0].ItemArray[1].ToString(); EEC.empid = DS.Tables[0].Rows[0].ItemArray[0].ToString(); EEC.Department = DS.Tables[0].Rows[0].ItemArray[2].ToString(); EEC.Designation = DS.Tables[0].Rows[0].ItemArray[3].ToString(); EEC.Date = DS.Tables[0].Rows[0].ItemArray[4].ToString(); EEC.category = DS.Tables[0].Rows[0].ItemArray[5].ToString(); EEC.subject = DS.Tables[0].Rows[0].ItemArray[6].ToString(); EEC.Before = DS.Tables[0].Rows[0].ItemArray[7].ToString(); EEC.After = DS.Tables[0].Rows[0].ItemArray[8].ToString(); EEC.Benifit = DS.Tables[0].Rows[0].ItemArray[9].ToString(); EEC.UpLoad1 = DS.Tables[0].Rows[0].ItemArray[11].ToString(); // EEC.upload1 = "/PIMS/UI/Image/" + EEC.UpLoad1; EEC.upload1 = "../UI/Image/" + EEC.UpLoad1; EEC.UpLoad2 = DS.Tables[0].Rows[0].ItemArray[12].ToString(); //EEC.upload2 = "/PIMS/UI/Image/" + EEC.UpLoad2; EEC.upload2 = "../UI/Image/" + EEC.UpLoad2; EEC.UpLoad3 = DS.Tables[0].Rows[0].ItemArray[13].ToString(); // EEC.upload3 = "/PIMS/UI/Image/" + EEC.UpLoad3; EEC.upload3 = "../UI/Image/" + EEC.UpLoad3; DS = M.DBMReplyCE(M); chk = DS.Tables[0].Rows[0].ItemArray[0].ToString(); if (chk != "Empty") { EEC.RIdeaID = DS.Tables[0].Rows[0].ItemArray[0].ToString(); EEC.REmpID = DS.Tables[0].Rows[0].ItemArray[1].ToString(); EEC.RMail = DS.Tables[0].Rows[0].ItemArray[2].ToString(); EEC.RSub = DS.Tables[0].Rows[0].ItemArray[3].ToString(); EEC.RCon = DS.Tables[0].Rows[0].ItemArray[4].ToString(); string[] breakMysentence = EEC.REmpID.Split(','); string[] ena1 = new string[breakMysentence.Length]; string n = ""; foreach (string data in breakMysentence) { ena1[i] = data; i = i + 1; RL.HEmployeeID = data.ToString().TrimStart().TrimEnd(); DS = RL.LoginSearch(RL); if (n != "") { n = n + ", " + DS.Tables[0].Rows[0].ItemArray[1].ToString(); } else { n = n + DS.Tables[0].Rows[0].ItemArray[1].ToString(); } } EEC.REmpName = n; } return(EEC); } catch (Exception ex) { throw new Exception("Error Initializing Data Class." + Environment.NewLine + ex.Message); } }