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