예제 #1
0
        public static dynamic AddNewProject(Mst_Project objnewproject)
        {
            CustomResponse objres = new CustomResponse();

            try
            {
                using (var objcontext = new Db_Zon_Test_techsupportEntities())
                {
                    objcontext.Mst_Project.Add(objnewproject);
                    objcontext.SaveChanges();
                    objres.Message  = "Success";
                    objres.Response = objnewproject;
                    objres.Status   = CustomResponseStatus.Successful;
                    return(objres);
                }
            }
            catch (Exception ex)

            {
                objres.Message  = ex.Message;
                objres.Response = null;
                objres.Status   = CustomResponseStatus.UnSuccessful;
                return(objres);
            }
        }
        public dynamic Put(CreateProjectDTO objupdateProject)
        {
            Mst_Project objprojectNew = new Mst_Project {
                ID = objupdateProject.objProject.ID, Name = objupdateProject.objProject.Name, Description = objupdateProject.objProject.Description, ShortName = objupdateProject.objProject.ShortName, Duration = objupdateProject.objProject.Duration, ClientID = objupdateProject.objProject.ClientID, PManagerID = objupdateProject.objProject.PManagerID, ProposedEndDate = objupdateProject.objProject.ProposedEndDate, SignUpDate = objupdateProject.objProject.SignUpDate, StartDate = objupdateProject.objProject.StartDate, Status = objupdateProject.objProject.Status, CreatedBy = objupdateProject.objProject.CreatedBy, UpdatedBy = objupdateProject.objProject.UpdatedBy
            };
            List <Mst_ProjectUsers> objusers = new List <Mst_ProjectUsers>();

            foreach (string user in objupdateProject.Users)
            {
                objprojectNew.Mst_ProjectUsers.Add(new Mst_ProjectUsers {
                    UserID = user
                });
            }
            return(ProjectRepository.UpdateProject(objprojectNew));
        }
        internal static void ProjectCreationMail(Mst_Project objproject, string ToMail)
        {
            MailMessage Msg = new MailMessage();

            Msg.From    = new MailAddress(ConfigurationManager.AppSettings["Email"]);
            Msg.Subject = "Zon Ticketing System - New Ticket Information";

            StreamReader reader     = new StreamReader(HttpContext.Current.Server.MapPath("/Email Templates/EmailTemplate.html"));//EmailTemplate1.html
            string       readFile   = reader.ReadToEnd();
            string       StrContent = "";

            StrContent = readFile;

            StringBuilder sb = new StringBuilder();

            sb.Append("<table width=100%>");
            sb.Append("<tr><td>Project  Name<center></td><td>" + objproject.Name + "</td></tr>");
            sb.Append("<tr><td>Project Description<center></td><td><center>" + objproject.Description + "</td></tr>");
            sb.Append("<tr><td>Project Manager<center></td><td><center>" + UserRepository.GetFnamebyUid(objproject.PManagerID) + "</td></tr>");
            sb.Append("<tr><td>Client <center></td><td><center>" + UserRepository.GetFnamebyUid(objproject.ClientID) + "</td></tr>");
            sb.Append("<tr><td>Project Manager<center></td><td><center>" + UserRepository.GetFnamebyUid(objproject.CreatedBy) + "</td></tr>");
            sb.Append("<tr><td>Project Manager<center></td><td><center>" + objproject.StartDate + "</td></tr>");
            sb.Append("<tr><td>Project Manager<center></td><td><center>" + objproject.ProposedEndDate + "</td></tr>");
            sb.Append("</table>");
            StrContent = StrContent.Replace("$$TemplateBody$$", "<span>  A New Task is created in the Project  <b>" + objproject.Name + "</b> by <b>" + UserRepository.GetFnamebyUid(objproject.CreatedBy) + "</b>.\n Please find the Details below. </span></br><div>" + sb.ToString());
            Msg.To.Add(ToMail.ToString());
            StrContent     = StrContent.Replace("$$User$$", ToMail.ToString());
            Msg.Body       = StrContent.ToString();
            Msg.IsBodyHtml = true;
            // your remote SMTP server IP.
            SmtpClient smtp = new SmtpClient();

            smtp.Host = ConfigurationManager.AppSettings["MailServer"];
            System.Net.NetworkCredential NetworkCred = new System.Net.NetworkCredential();
            NetworkCred.UserName       = ConfigurationManager.AppSettings["UserName"];
            NetworkCred.Password       = ConfigurationManager.AppSettings["Password"];
            smtp.UseDefaultCredentials = true;
            smtp.Credentials           = NetworkCred;
            object mailstate = Msg;

            smtp.SendCompleted += new SendCompletedEventHandler(smtpClient_SendCompleted);
            smtp.Port           = int.Parse(ConfigurationManager.AppSettings["MailPort"]);
            smtp.EnableSsl      = Convert.ToBoolean(ConfigurationManager.AppSettings["IsSSLEnabled"].ToString());
            smtp.SendAsync(Msg, mailstate);
        }
        public dynamic Post(CreateProjectDTO objcreateProject)
        {
            Mst_Project objprojectNew = new Mst_Project {
                Name            = objcreateProject.objProject.Name,
                Description     = objcreateProject.objProject.Description,
                ShortName       = objcreateProject.objProject.ShortName,
                Duration        = objcreateProject.objProject.Duration,
                ClientID        = objcreateProject.objProject.ClientID,
                PManagerID      = objcreateProject.objProject.PManagerID,
                ProposedEndDate = objcreateProject.objProject.ProposedEndDate,
                SignUpDate      = objcreateProject.objProject.SignUpDate,
                StartDate       = objcreateProject.objProject.StartDate,
                Status          = objcreateProject.objProject.Status,
                CreatedBy       = objcreateProject.objProject.CreatedBy
            };


            List <Mst_ProjectUsers> objusers = new List <Mst_ProjectUsers>();


            foreach (string user in objcreateProject.Users)
            {
                objprojectNew.Mst_ProjectUsers.Add(new Mst_ProjectUsers {
                    UserID = user
                });
            }

            List <string> ObjToAddresses         = new List <string>();
            List <string> ObjFilteredToAddresses = new List <string>();

            ObjToAddresses.Add(objcreateProject.objProject.CreatedBy);
            ObjToAddresses.Add(objcreateProject.objProject.ClientID);
            ObjToAddresses.Add(objcreateProject.objProject.PManagerID);
            // ObjToAddresses.AddRange(ProjectRepository.GetProjectUsers(objtaskdto.ProjectID));
            ObjFilteredToAddresses = ObjToAddresses.Distinct().ToList();
            ObjFilteredToAddresses = UserRepository.GetEmailAddressesByUserIds(ObjFilteredToAddresses);
            foreach (var toMail in ObjFilteredToAddresses)
            {
                MailSender.ProjectCreationMail(objprojectNew, toMail);
            }


            return(ProjectRepository.AddNewProject(objprojectNew));
        }
예제 #5
0
        public static dynamic UpdateProject(Mst_Project objupdateproject)
        {
            CustomResponse objres = new CustomResponse();

            try
            {
                using (var objcontext = new Db_Zon_Test_techsupportEntities())
                {
                    int         pid          = objupdateproject.ID;
                    Mst_Project objdbproject = objcontext.Mst_Project.Where(x => x.ID == pid).FirstOrDefault();

                    objdbproject.Name            = objupdateproject.Name;
                    objdbproject.Description     = objupdateproject.Description;
                    objdbproject.PManagerID      = objupdateproject.PManagerID;
                    objdbproject.ClientID        = objupdateproject.ClientID;
                    objdbproject.SignUpDate      = objupdateproject.SignUpDate;
                    objdbproject.StartDate       = objupdateproject.StartDate;
                    objdbproject.Duration        = objupdateproject.Duration;
                    objdbproject.ShortName       = objupdateproject.ShortName;
                    objdbproject.ProposedEndDate = objupdateproject.ProposedEndDate;
                    for (int i = 0; i < objdbproject.Mst_ProjectUsers.Count(); i++)
                    {
                        objdbproject.Mst_ProjectUsers.ElementAt(i).Status = false;
                    }
                    objdbproject.Mst_ProjectUsers = objupdateproject.Mst_ProjectUsers;
                    objcontext.SaveChanges();
                    objres.Message  = "Success";
                    objres.Response = objdbproject;
                    objres.Status   = CustomResponseStatus.Successful;
                    return(objres);
                }
            }
            catch (Exception ex)
            {
                objres.Message  = ex.Message;
                objres.Response = null;
                objres.Status   = CustomResponseStatus.UnSuccessful;
                return(objres);
            }
        }
예제 #6
0
        // get particular project detail
        public static List <string> GetProjectUsers(int projectid)
        {
            CustomResponse objres = new CustomResponse();

            try
            {
                List <string> objUserIds = new List <string>();
                using (var objcontext = new Db_Zon_Test_techsupportEntities())
                {
                    // Add ProjectManager and Client Info
                    Mst_Project objproject = objcontext.Mst_Project.Where(x => x.ID == projectid).FirstOrDefault();
                    objUserIds.Add(objproject.PManagerID);
                    objUserIds.Add(objproject.ClientID);
                    // Add ProjectUsers info
                    objUserIds.AddRange(objcontext.Mst_ProjectUsers.Where(x => x.ProjectID == projectid).Select(x => x.UserID).ToList());
                    return(objUserIds);
                }
            }
            catch (Exception ex)
            {
                return(null);
            }
        }