public static string getFillGrid(string idea) { DataSet DS = new DataSet(); HOSModule hos = new HOSModule(); try { DS = hos.getEmailbySno(idea, "gridview"); } catch (Exception e) { } return(DS.GetXml()); }
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); } }