public static CEmpEmailContents CheckingUpdate(string emp)
{
NewSuggestionModel NSM = new NewSuggestionModel();
Employee E = new Employee();
CEmpEmailContents tdp = new CEmpEmailContents();
DataBankManager DBM = new DataBankManager();
//Console.Write(emp);
//Console.Write("My first ASP script!");
try
{
try
{
if (emp != "" && emp != "System.Data.DataRowView")
{
Console.Write(emp);
DBM.IdeaId = emp.ToString().Trim();
DataSet DS = new DataSet();
DS = DBM.ComEvalUpdateDashboardProcess(DBM);
tdp.Type = DS.Tables[0].Rows[0].ItemArray[0].ToString();
tdp.Reason = DS.Tables[0].Rows[0].ItemArray[1].ToString();
//SIDepID = DS.Tables[0].Rows[0].ItemArray[1].ToString();
tdp.Response = DS.Tables[0].Rows[0].ItemArray[2].ToString();
tdp.Sempid = DS.Tables[0].Rows[0].ItemArray[3].ToString();
tdp.Sempname = DS.Tables[0].Rows[0].ItemArray[4].ToString();
//SIDesID = DS.Tables[0].Rows[0].ItemArray[3].ToString();
}
else
{
}
return(tdp);
}
catch (Exception ex)
{
throw new Exception("Error Initializing Data Class." + Environment.NewLine + ex.Message);
}
}
catch (Exception ex)
{
throw new Exception("Error Initializing Data Class." + Environment.NewLine + ex.Message);
}
}
public void TeamEvaluvationInsert()
{
CEmpEmailContents EECS = new CEmpEmailContents();
DataSet Ds = new DataSet();
try
{
int i = 0;
int j = 0;
string array1 = MailIdIMPTextBox.Text.ToString();
//string array = EmpDepTextBox.Text.ToString();
string ds = EmpIDIMPTextBox.Text.ToString();
string[] breakMysentence = ds.Split(',');
string[] breakMysentence1 = array1.Split(',');
string[] ena1 = new string[breakMysentence.Length];
string[] mail1 = new string[breakMysentence.Length];
foreach (string data in breakMysentence)
{
ena1[i] = data;
i = i + 1;
}
foreach (string data1 in breakMysentence1)
{
mail1[j] = data1;
j = j + 1;
}
DepIdAutoGeneretion();
for (int x = 0; x < ena1.Length; x++)
{
ComEvalInboxIDAutoGeneration();
DBM.SendId = SendID.ToString();
DBM.IdeaId = IMPIdeaIdTextBox.Text.ToString();
DBM.HEmployeeName = us1.ToString();
DBM.TempMail = array1.ToString();
DBM.TempId = ds.ToString();
DBM.Date = System.DateTime.Now.ToString("yyyy-MM-dd").ToString().Trim();
DBM.HEmployeeID = ena1[x].ToString().TrimStart().TrimEnd();
DBM.Email = mail1[x].ToString().TrimStart().TrimEnd();
DBM.Subject = SubjectIMPTextBox.Text.TrimStart().TrimEnd().ToString();
DBM.Discription = ContectIMPTextBox.Text.TrimStart().TrimEnd().ToString();
if (ImageFileUpload3.HasFile)
{
extn = System.IO.Path.GetExtension(ImageFileUpload3.FileName);
// path = Server.MapPath("\\PIMS\\UI\\Image\\");
path = Server.MapPath("..\\UI\\Image\\");
ImageName = ImageFileUpload3.FileName;
ImageFileUpload3.SaveAs(path + ImageName);
etn = ImageName;
//Label1.Text = path;
}
else
{
etn = "No File";
}
DBM.FileUpload3 = etn.ToString();
DBM.Remark1 = "i";
DBM.Remark2 = "HOS";
string idof = txtHODid.Text;//Request.Form["hodid2"];
DBM.HODID = idof;
DBM.ComInboxID = ComEvalInboxID.ToString();
DBM.DBMEmail = Session["Email"].ToString();
DBM.HosInboxInsert(DBM);
}
DBM.ImplTeamEvaInsert(DBM);
string myscript = "alert ('Mail Send HOS');";
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "MyScript", myscript, true);
z = 1;
//E.EmployeeInsert(E);
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('New Employee Record Is Added')", true);
}
catch (Exception e1)
{
//throw new Exception("Error Initializing Data Class." + Environment.NewLine + ex.Message);
}
}
public static CEmpEmailContents MailContent(string idea)
{
CEmpEmailContents EECS = new CEmpEmailContents();
Mailling M = new Mailling();
DataBankManager DBM = new Models.DataBankManager();
DataSet DS = new DataSet();
try
{
//RepeaterItem item = (sender as TextBox).Parent as RepeaterItem;
//index = int.Parse((item.FindControl("lblImageNameTextBox") as Label).Text);
index = idea.ToString();
DBM.IdeaId = idea.ToString();
//Session["IdeaID"] = idea.ToString();
DS = DBM.ComtEvalRepViewUpatePannel(DBM);
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 = " Reply ";
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);
}
//DataSet DS = new DataSet();
//DS = M.Repeatersearch(M);
//fromTag.InnerHtml = "From : ";
//EIDTag.InnerHtml = "Employee ID : ";
//DepTag.InnerHtml = "Department : ";
//DesTag.InnerHtml = "Designaton : ";
//CatTag.InnerHtml = "Category : ";
//BefTag.InnerHtml = "Before : ";
//AftTag.InnerHtml = "After : ";
//BenTag.InnerHtml = "Benefits : ";
//EmployeeNameTag.InnerHtml = DS.Tables[0].Rows[0].ItemArray[1].ToString();
//EmployeeIDTag.InnerHtml = DS.Tables[0].Rows[0].ItemArray[0].ToString();
//DepartmentTag.InnerHtml = DS.Tables[0].Rows[0].ItemArray[2].ToString();
//DesignationTag.InnerHtml = DS.Tables[0].Rows[0].ItemArray[3].ToString();
//TimeTag.InnerHtml = DS.Tables[0].Rows[0].ItemArray[4].ToString();
//CategoryTag.InnerHtml = DS.Tables[0].Rows[0].ItemArray[5].ToString();
//SubjectTag.InnerHtml = DS.Tables[0].Rows[0].ItemArray[6].ToString();
//BeforeTag.InnerHtml = DS.Tables[0].Rows[0].ItemArray[7].ToString();
//AfterTag.InnerHtml = DS.Tables[0].Rows[0].ItemArray[8].ToString();
//BenefitsTag.InnerHtml = DS.Tables[0].Rows[0].ItemArray[9].ToString();
}
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);
}
}
