public static CESEmpEmailContents Checking(string IdeaID)
{
CommiteeEvalSend NM = new CommiteeEvalSend();
Mailling M = new Mailling();
Employee E = new Employee();
CESEmpEmailContents EEC = new CESEmpEmailContents();
string chk;
RegistrationLogin RL = new RegistrationLogin();
//Console.Write(emp);
//Console.Write("My first ASP script!");
try
{
try
{
if ((IdeaID != "") && (IdeaID != "System.Data.DataRowView"))
{
Console.Write(IdeaID);
M.IdeaId = IdeaID.ToString().Trim();
DataSet DS = new DataSet();
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();
RL.HEmployeeID = EEC.REmpID;
DS = RL.LoginSearch(RL);
EEC.REmpName = DS.Tables[0].Rows[0].ItemArray[1].ToString();
}
}
else if (IdeaID == "")
{
EEC.ErrorLabel = "Check the Employee ID ";
}
else
{
EEC.ErrorLabel = "1";
}
}
catch (Exception ex)
{
EEC.ErrorLabel = "1";
}
return(EEC);
}
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);
}
}