public static CESEmpEmailContentsfin Checking(string IdeaID) { CommiteeEvalSend NM = new CommiteeEvalSend(); Mailling M = new Mailling(); Employee E = new Employee(); CESEmpEmailContentsfin EEC = new CESEmpEmailContentsfin(); 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 CESEmpEmailContentsfin GetFinanceDetails(string emp) { CommiteeEvalSend NM = new CommiteeEvalSend(); Manager MM = new Manager(); CESEmpEmailContentsfin EEC = new CESEmpEmailContentsfin(); RegistrationLogin RL = new RegistrationLogin(); //Console.Write(emp); //Console.Write("My first ASP script!"); try { try { if ((emp != "") && (emp != "System.Data.DataRowView")) { Console.Write(emp); MM.IdeaId = emp.ToString().Trim(); DataSet DS = new DataSet(); DS = MM.PaymentDetails(MM); EEC.RIdeaID = DS.Tables[0].Rows[0].ItemArray[0].ToString(); EEC.Date = DS.Tables[0].Rows[0].ItemArray[1].ToString(); EEC.REmpID = DS.Tables[0].Rows[0].ItemArray[2].ToString(); EEC.REmpName = DS.Tables[0].Rows[0].ItemArray[3].ToString(); EEC.Finname = DS.Tables[0].Rows[0].ItemArray[4].ToString(); EEC.Amount = DS.Tables[0].Rows[0].ItemArray[5].ToString(); EEC.CashMode = DS.Tables[0].Rows[0].ItemArray[6].ToString(); } 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 CESEmpEmailContentsfin MChecking(string emp) { DataBankManager DBM = new DataBankManager(); CESEmpEmailContentsfin EEC = new CESEmpEmailContentsfin(); DataSet DS = new DataSet(); Manager M = new Manager(); try { try { if (emp != "" && emp != "System.Data.DataRowView") { M.IdeaId = emp.ToString(); DS = M.EmployeeNameSelect(M); EEC.HEmployeeID = DS.Tables[0].Rows[0].ItemArray[0].ToString(); EEC.HEmployeeName = DS.Tables[0].Rows[0].ItemArray[1].ToString(); EEC.Email = DS.Tables[0].Rows[0].ItemArray[2].ToString(); EEC.Amount = DS.Tables[0].Rows[0].ItemArray[3].ToString(); EEC.ErrorLabel = "0"; } else if (emp == "") { EEC.ErrorLabel = "Check the Employee ID "; } else { string err = "Check the Input Record is not Exit "; } } catch (Exception ex) { string err = "Check the Input Record is not Exit "; } return(EEC); } catch (Exception ex) { throw new Exception("Error Initializing Data Class." + Environment.NewLine + ex.Message); } }