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