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