public static GraphItems getReport()
        {
            AddSuggestion      A   = new AddSuggestion();
            NewSuggestionModel NSM = new NewSuggestionModel();
            Employee           E   = new Employee();


            GraphItems gra = new GraphItems();

            try
            {
                Mailling m  = new Mailling();
                DataSet  Ds = new DataSet();
                Ds      = m.Barchart_get_details();
                gra.Com = int.Parse(Ds.Tables[0].Rows[0].ItemArray[0].ToString());
                gra.Hod = int.Parse(Ds.Tables[0].Rows[0].ItemArray[1].ToString());
                gra.Imp = int.Parse(Ds.Tables[0].Rows[0].ItemArray[2].ToString());
                gra.Hos = int.Parse(Ds.Tables[0].Rows[0].ItemArray[3].ToString());
                gra.Ben = int.Parse(Ds.Tables[0].Rows[0].ItemArray[4].ToString());
                gra.Fin = int.Parse(Ds.Tables[0].Rows[0].ItemArray[5].ToString());

                return(gra);
            }
            catch (Exception ex)
            {
                return(gra);
            }
        }
Beispiel #2
0
        public virtual MailLogDTO SendMail(Domain.Entity.Client currentClient, MailModel entity, object param)
        {
            List <string>   recipients = new List <string>();
            List <Document> documents  = new List <Document>();
            MailLog         mailLog;

            ValidateNull(entity);
            if (!validation.PreValidatePost(validationDictionnary, currentClient, entity, param, repo, recipients, documents))
            {
                throw new ManahostValidationException(validationDictionnary);
            }
            IHomeRepository homeRepo   = ((MailController.AdditionalRepositories)param).HomeRepo;
            MailConfig      mailconfig = repo.GetMailConfigById(entity.MailConfigId, currentClient.Id);

            Mailling.SendMailBcc(new InfosMailling(mailconfig.Smtp, (int)mailconfig.SmtpPort, mailconfig.Email, homeRepo.GetHomeById(mailconfig.HomeId, currentClient.Id).Title,
                                                   Encoding.UTF8.GetString(Convert.FromBase64String(entity.Password)))
            {
                body        = entity.Body,
                prio        = System.Net.Mail.MailPriority.Normal,
                subject     = entity.Subject,
                toPeople    = recipients,
                ssl         = (bool)mailconfig.IsSSL,
                attachments = MailUtils.GetAttachments(documents, mailconfig.Home)
            }, mailLog = new MailLog()
            {
                DateSended = DateTime.UtcNow,
                To         = String.Join(",", recipients.ToArray()),
                Successful = true,
                HomeId     = mailconfig.HomeId
            });
            repo.Add <MailLog>(mailLog);
            return(GetMapper.Map <MailLog, MailLogDTO>(mailLog));
        }
 public void Barchart_details()
 {
     try
     {
         if (Session["UserId"] == null)
         {
             Response.Redirect("Main.aspx");
         }
         else
         {
             Mailling m  = new Mailling();
             DataSet  Ds = new DataSet();
             Ds  = m.Barchart_get_details();
             com = int.Parse(Ds.Tables[0].Rows[0].ItemArray[0].ToString());
             hod = int.Parse(Ds.Tables[0].Rows[0].ItemArray[1].ToString());
             imp = int.Parse(Ds.Tables[0].Rows[0].ItemArray[2].ToString());
             hos = int.Parse(Ds.Tables[0].Rows[0].ItemArray[3].ToString());
             ben = int.Parse(Ds.Tables[0].Rows[0].ItemArray[4].ToString());
             fin = int.Parse(Ds.Tables[0].Rows[0].ItemArray[5].ToString());
             string script = "Barchart('" + com + "','" + hod + "','" + imp + "','" + hos + "','" + ben + "','" + fin + "'); ";
             ClientScript.RegisterStartupScript(this.GetType(), "function", script, true);
         }
     }
     catch (Exception e1)
     {
     }
 }
Beispiel #4
0
        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);
            }
        }
Beispiel #5
0
        static public void sendTemplateMailLogError(String stacktrace, String message)
        {
            InfosMailling mail = new InfosMailling();

            mail.toPeople.Add(MANAHOST_EMAIL);
            mail.subject = "Error Manahost";
            mail.body    = "An error occured : </br></br>message error : " + message + "</br></br>stacktrace error : " + stacktrace;
            mail.prio    = MailPriority.High;
            Mailling.sendMail(mail, null);
        }
        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);
            }
        }
Beispiel #7
0
        public void SendOneMailServerWithoutPasswordShouldWork()
        {
            InfosMailling info = new InfosMailling();

            info.toPeople.Add("*****@*****.**");
            info.subject = "subject";
            info.prio    = MailPriority.High;
            info.ssl     = false;
            info.modifyTimeOut(200000);
            MailLog log = new MailLog();

            Mailling.sendMail(info, log);
            Assert.AreEqual(1, _Server.ReceivedEmailCount);
        }
Beispiel #8
0
        static public void sendTemplateMailWarningConnection(String locale, String civility, String firstname, String lastname, String email)
        {
            InfosMailling mail = new InfosMailling();
            String        forgotPasswordLink = String.Format(FORGOT_LINK_FORMAT, email);

            ManahostManager.Utils.MailingUtils.Resources.MailTemplate.Culture = Thread.CurrentThread.CurrentCulture;

            mail.toPeople.Add(email);
            mail.subject = ManahostManager.Utils.MailingUtils.Resources.MailTemplate.SubjectConnectionWarning;
            mail.body    = String.Format(ManahostManager.Utils.MailingUtils.Resources.MailTemplate.BodyConnectionWarning, civility, firstname, lastname, forgotPasswordLink);
            mail.body   += ManahostManager.Utils.MailingUtils.Resources.MailTemplate.Footer;
            mail.prio    = MailPriority.Normal;
            Mailling.sendMail(mail, null);
        }
Beispiel #9
0
        static public void sendTemplateMailCreationAccount(String locale, String firstname, String lastName, String civility, String email, String tokenActivation)
        {
            InfosMailling mail               = new InfosMailling();
            String        activationLink     = String.Format(ACTIVATION_LINK_FORMAT, email, tokenActivation);
            String        forgotPasswordLink = String.Format(FORGOT_LINK_FORMAT, email);

            mail.toPeople.Add(email);
            //Thread.CurrentThread.CurrentUICulture = new CultureInfo(locale);
            ManahostManager.Utils.MailingUtils.Resources.MailTemplate.Culture = Thread.CurrentThread.CurrentCulture;
            mail.subject = ManahostManager.Utils.MailingUtils.Resources.MailTemplate.SubjectAccountCreation;
            mail.body    = String.Format(ManahostManager.Utils.MailingUtils.Resources.MailTemplate.BodyAccountCreation, civility, firstname, lastName, activationLink, email, forgotPasswordLink);
            mail.body   += ManahostManager.Utils.MailingUtils.Resources.MailTemplate.Footer;
            mail.prio    = MailPriority.Normal;
            Mailling.sendMail(mail, null);
        }
Beispiel #10
0
        private void SendMail(InfosMailling mail, MailLog log, BookingStepBooking b, bool ssl, String body, List <Attachment> attachments)
        {
            mail.toPeople.Add(b.Booking.People.Email);
            mail.ssl     = ssl;
            mail.prio    = System.Net.Mail.MailPriority.High;
            mail.subject = b.CurrentStep.MailSubject;
            //TODO transform mail body template with the template generator
            mail.body        = body;
            mail.attachments = attachments;
            Mailling.sendMail(mail, log);

            log.HomeId = b.HomeId;
            b.MailLog  = log;
            if (b.MailLog.Successful)
            {
                b.MailSent++;
            }
        }
Beispiel #11
0
        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 ADSEmpEmailContents MailContent(string idea)
        {
            ADSEmpEmailContents EECS = new ADSEmpEmailContents();
            Mailling            M    = new Mailling();
            DataSet             DS   = new DataSet();

            try
            {
                //RepeaterItem item = (sender as TextBox).Parent as RepeaterItem;
                //index = int.Parse((item.FindControl("lblImageNameTextBox") as Label).Text);

                M.IdeaId = idea.ToString();
                //Session["IdeaID"] = idea.ToString();
                DS = M.DBMSenderRepeatersearch(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.SfromTag = "From : ";
                EECS.SEIDTag  = "Employee ID : ";
                EECS.SDepTag  = "Department : ";
                //EECS.DesTag = "Designaton : ";

                EECS.IdeaIdTag = 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.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();


                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 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);
            }
        }
Beispiel #14
0
        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);
            }
        }