protected void Resend(object sender, EventArgs e) { var signerQuery = dbContext.tblEmailLogs.Where(x => x.JR_Code == jrcode && x.UserRole.Trim() == "Approver").ToList(); if (signerQuery.Count == 0) { RadNotification1.Text = "No Email To Send. Please Contact The IT Officer To Resend Your Email."; RadNotification1.TitleIcon = string.Empty; RadNotification1.ContentIcon = string.Empty; RadNotification1.Show(); } else { foreach (var item in signerQuery) { tblEmailLog tblData = item as tblEmailLog; SendEmailToApprover(tblData.SentTo.ToString().Trim(), tblData.JR_Code.ToString().Trim(), tblData.EmailAdd.ToString().Trim()); } RadNotification1.Text = "Request Has Been Sent To Approver"; RadNotification1.TitleIcon = string.Empty; RadNotification1.ContentIcon = string.Empty; RadNotification1.Show(); } }
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); }