public static EmpEmailContents MailContent(string idea) { EmpEmailContents EECS = new EmpEmailContents(); Mailling M = new Mailling(); DataSet DS = new DataSet(); try { M.IdeaId = idea.ToString(); DS = M.Repeatersearch(M); 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.IdeaIdTag = idea.ToString(); EECS.empname = DS.Tables[0].Rows[0].ItemArray[1].ToString(); EECS.empid = DS.Tables[0].Rows[0].ItemArray[0].ToString(); EECS.Department = DS.Tables[0].Rows[0].ItemArray[2].ToString(); EECS.Designation = DS.Tables[0].Rows[0].ItemArray[3].ToString(); EECS.Date = DS.Tables[0].Rows[0].ItemArray[4].ToString(); EECS.category = DS.Tables[0].Rows[0].ItemArray[5].ToString(); EECS.subject = DS.Tables[0].Rows[0].ItemArray[6].ToString(); EECS.Before = DS.Tables[0].Rows[0].ItemArray[7].ToString(); EECS.After = DS.Tables[0].Rows[0].ItemArray[8].ToString(); EECS.Benifit = DS.Tables[0].Rows[0].ItemArray[9].ToString(); EECS.UpLoad1 = DS.Tables[0].Rows[0].ItemArray[11].ToString(); // EEC.upload1 = "/PIMS/UI/Image/" + EEC.UpLoad1; EECS.upload1 = "../UI/Image/" + EECS.UpLoad1; EECS.UpLoad2 = DS.Tables[0].Rows[0].ItemArray[12].ToString(); //EEC.upload2 = "/PIMS/UI/Image/" + EEC.UpLoad2; EECS.upload2 = "../UI/Image/" + EECS.UpLoad2; EECS.UpLoad3 = DS.Tables[0].Rows[0].ItemArray[13].ToString(); // EEC.upload3 = "/PIMS/UI/Image/" + EEC.UpLoad3; EECS.upload3 = "../UI/Image/" + EECS.UpLoad3; EECS.Description = DS.Tables[0].Rows[0].ItemArray[14].ToString(); return(EECS); } catch (Exception ex) { throw new Exception("Error Initializing Data Class." + Environment.NewLine + ex.Message); } }
public static EmpEmailContents Checking(string emp) { EmpEmailContents EE = new EmpEmailContents(); Manager M = new Manager(); DataSet DS = new DataSet(); int count; string ei; string en; string em; try { try { if (emp != "" && emp != "System.Data.DataRowView") { M.IEmpId = emp.ToString(); DS = M.EmployeeEmailDashBoard(M); count = DS.Tables[0].Rows.Count; if (DS != null || DS.Tables[0].Rows.Count > 0) { if (count == 1) { EE.EmployeeId = DS.Tables[0].Rows[0].ItemArray[5].ToString(); EE.EmployeeName = DS.Tables[0].Rows[0].ItemArray[3].ToString(); EE.Email = DS.Tables[0].Rows[0].ItemArray[4].ToString(); } else { for (int i = 0; i < count; i++) { ei = DS.Tables[0].Rows[i].ItemArray[5].ToString(); en = DS.Tables[0].Rows[i].ItemArray[3].ToString(); em = DS.Tables[0].Rows[i].ItemArray[4].ToString(); if (i < count - 1) { EE.EmployeeId = EE.EmployeeId + ei + ", "; EE.EmployeeName = EE.EmployeeName + en + ", "; EE.Email = EE.Email + em + ", "; } else { EE.EmployeeId = EE.EmployeeId + ei; EE.EmployeeName = EE.EmployeeName + en; EE.Email = EE.Email + em; } } } EE.ErrorLabel = "0"; } else if (emp == "") { EE.ErrorLabel = "Check the Employee ID "; } else { EE.ErrorLabel = "1"; } } else { string err = "Check the Input Record is not Exit "; } } catch (Exception ex) { string err = "Check the Input Record is not Exit "; } return(EE); } catch (Exception ex) { throw new Exception("Error Initializing Data Class." + Environment.NewLine + ex.Message); } }