public void RejectByChecker() { var app = dbContext.tblRequests.Where(x => x.JR_Code == jrcode).FirstOrDefault(); if (app != null) { app.IsRejected = true; app.Checker = Session["FullName_FnameFirst"].ToString().Trim(); app.CheckerRemarks = "REJECTED"; app.DateChecked = DateTime.Now.Date; app.IsHold = false; app.RejectRemarks = tbRejectReasons.Text.Trim().Replace("\r\n", "<br />").Replace(" ", " ").Replace("\t", " ").Replace("'", "^"); app.HoldBy = DBNull.Value.ToString(); app.HoldRemarks = DBNull.Value.ToString(); app.CreationDateTime = DateTime.Now; dbContext.Entry(app).State = EntityState.Modified; dbContext.SaveChanges(); } SendRejectedEmail(); string script = "window.onload = function() { CloseWindow(); };"; ClientScript.RegisterStartupScript(this.GetType(), "CloseWindow", script, true); }
private Boolean SaveEmailLogs(string url, string role, string emailadd, string emailfrom, string sentto, string code) { var logs = dbContext.tblEmailLogs.Where(x => x.UserRole == role && x.JR_Code == code).FirstOrDefault(); if (logs != null) { logs.EmailUrl = url; logs.UserRole = role; logs.EmailAdd = emailadd; logs.EmailFrom = emailfrom; logs.SentTo = sentto; logs.JR_Code = code; logs.CreationDate = DateTime.Now; dbContext.Entry(logs).State = EntityState.Modified; } else { tblEmailLog tbl = new tblEmailLog() { EmailUrl = url, UserRole = role, EmailAdd = emailadd, EmailFrom = emailfrom, SentTo = sentto, JR_Code = code, CreationDate = DateTime.Now }; dbContext.tblEmailLogs.Add(tbl); } return(true); }
protected void Cancel(object sender, EventArgs e) { var query = dbContext.tblRequests.Where(x => x.JR_Code == jrcode).FirstOrDefault(); if (query != null) { query.IsCancelled = true; query.CreationDateTime = DateTime.Now; dbContext.Entry(query).State = EntityState.Modified; dbContext.SaveChanges(); } RadNotification1.Text = "Requests Successfully Cancelled"; RadNotification1.Title = "Notification"; RadNotification1.TitleIcon = string.Empty; RadNotification1.ContentIcon = string.Empty; RadNotification1.Show(); Response.Redirect("HomePage.aspx"); }
protected void btnaccept_Click(object sender, ImageClickEventArgs e) { var accept = dbContext.tblRequests.Where(x => x.JR_Code == jrcode).FirstOrDefault(); if (accept != null) { accept.Is_JobAccepted = true; accept.CreationDateTime = DateTime.Now; dbContext.Entry(accept).State = EntityState.Modified; dbContext.SaveChanges(); } divDetails.Visible = false; divRecords.Visible = true; jrcode = string.Empty; Session["RCode"] = null; gridRecords.Rebind(); Show("Successfully Accepted"); }
protected void btnaccept_Click(object sender, ImageClickEventArgs e) { var accept = dbContext.tblRequests.Where(x => x.JR_Code == jrcode).FirstOrDefault(); if (accept != null) { accept.FinalAcceptanceBy = Session["FullName_LnameFirst"].ToString().Trim(); accept.AcceptRemarks = "SIGNED"; accept.DateAccepted = DateTime.Now; accept.CreationDateTime = DateTime.Now; dbContext.Entry(accept).State = EntityState.Modified; dbContext.SaveChanges(); } SendToAssesstor(); divDetails.Visible = true; GetRequestDetails(); Show("Successfully Accepted"); }
protected void btnaccept_Click(object sender, ImageClickEventArgs e) { if (!dpAccomplish.SelectedDate.HasValue) { Show("Please set date accomplish."); } //else if (gridAttachment2.MasterTableView.Items.Count == 0) //{ // Show("Please add an attachment."); //} else { var completed = dbContext.tblRequests.Where(x => x.JR_Code == jrcode).FirstOrDefault(); if (completed != null) { completed.IsCompleted = true; completed.CompletionRemarks = tbRemarks.Text.Trim(); completed.Completion_Date = dpAccomplish.SelectedDate.Value; completed.CreationDateTime = DateTime.Now; dbContext.Entry(completed).State = EntityState.Modified; dbContext.SaveChanges(); } EmailRequestor(); Show("Request Has Been Successfully Finished"); divDetails.Visible = false; divRecords.Visible = true; jrcode = string.Empty; Session["RCode"] = null; gridRecords.Rebind(); } }
protected void ChangeIncharge(object sender, EventArgs e) { string link = string.Empty, body = string.Empty; dbContext = new JobRequestDBEntities(); var a = dbContext.tblRequests.Where(x => x.JR_Code == jrcode).FirstOrDefault(); if (a != null) { tblRequest tbldata = a as tblRequest; tbldata.Incharge_ID = incharge; dbContext.Entry(tbldata).State = EntityState.Modified; dbContext.SaveChanges(); } link = Environment.NewLine + "http://" + HttpContext.Current.Request.Url.Authority + "/DirectAssessment.aspx"; var asstr = (from data in dbContext.tblUsers join inchargePerson in dbContext.tblInchargePersons on data.EmpID equals inchargePerson.EmpID into UP from inchargePerson in UP.DefaultIfEmpty() where inchargePerson.Incharge_ID == rdoInCharge.SelectedValue && inchargePerson.IsAssesstor == true select new { EmpID = data.EmpID, EmailAdd = data.EmailAdd, InchargeCode = inchargePerson.Incharge_ID, IsAssesstor = inchargePerson.IsAssesstor, IsNoter = inchargePerson.IsNoter } ).ToList(); foreach (DataRow dr in ConvertToDataTable(asstr).Rows) { Boolean ress; ress = SaveEmailLogs(link + "?EmpID=" + dr["EmpID"].ToString().Trim() + "&RCode=" + jrcode , "Assesstor", dr["EmailAdd"].ToString().Trim(), approverfullname_fnamefirst.ToString().Trim() , dr["EmpID"].ToString().Trim(), Session["RCode"].ToString().Trim()); body = "Dear Sir/Ma'am," + "<br /><br />" + "Good Day!"; body += "<br /><br />" + "I Have Prepared A Job Order Request For Your Assessment."; body += "<br /><br />" + "You may click the link below to redirect to main page. "; body += "<br /><br />" + link + "?EmpID=" + dr["EmpID"].ToString().Trim() + "&RCode=" + jrcode; body += "<br /><br />" + "Thank You."; body += "<br /><br />" + "Note: This is a system generated email. Please do not reply. Thank you"; var rx = new Regex(@"(?<=\w)\w"); var newString2 = rx.Replace(Session["FullName_FnameFirst"].ToString(), new MatchEvaluator(m => m.Value.ToLowerInvariant())); using (MailMessage mm = new MailMessage()) { string sub = "Online Job Order Request: Requesting For Approval"; mm.Subject = sub.ToUpper(); mm.Body = body; var newString = rx.Replace(Session["FullName_FnameFirst"].ToString(), new MatchEvaluator(m => m.Value.ToLowerInvariant())); mm.From = new MailAddress(ConfigurationManager.AppSettings["MailSenderEmailAddress"].ToString(), ConfigurationManager.AppSettings["MailSenderName"].ToString()); mm.To.Add(dr["EmailAdd"].ToString().Trim()); SmtpClient smtp = new SmtpClient(); smtp.Host = ConfigurationManager.AppSettings["MailServer"].ToString(); smtp.EnableSsl = true; mm.IsBodyHtml = true; NetworkCredential NetworkCred = new NetworkCredential(ConfigurationManager.AppSettings["MailSenderEmailAddress"].ToString(), ConfigurationManager.AppSettings["MailSenderEmailPassword"].ToString()); smtp.Credentials = NetworkCred; smtp.Port = Convert.ToInt32(ConfigurationManager.AppSettings["SMTPPort"]); ServicePointManager.ServerCertificateValidationCallback = delegate(object s, X509Certificate certificate, X509Chain chain, SslPolicyErrors sslPolicyErrors) { return(true); }; smtp.Send(mm); } } dbContext.SaveChanges(); SendToRequestor_Transferred(); Show("Record Successfully Transferred"); divRecords.Visible = true; gridRecords.Rebind(); }