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);
}
}
