public void Insert(ApprovalEntity entity) { Parameters = new List<SqlParameter>(); Parameters.Add(new SqlParameter("@ApprovalID", entity.ApprovalID)); Parameters.Add(new SqlParameter("@AgreementTypeID", entity.AgreementTypeID)); Parameters.Add(new SqlParameter("@Actions", entity.Actions)); Parameters.Add(new SqlParameter("@Comments", entity.Comments)); Parameters.Add(new SqlParameter("@Status", entity.Status)); Parameters.Add(new SqlParameter("@Action", "EA")); ExecCommand(DBCommands.Approval); }
protected void btnReject_Click(object sender, EventArgs e) { ApprovalEntity entity = new ApprovalEntity(); entity.AgreementTypeID = SessionManager.AgreementTypeID; entity.ApprovalID = SessionManager.ApprovalID; entity.Comments = txtComment.Text.Trim(); entity.Actions = txtAction.Text.Trim(); entity.Status = "R"; ApprovalBI approver = new ApprovalBI(); approver.Insert(entity); /*#TODO:Get user's email id based on the agreement id.*/ AgreementTypeBI agreementTypeBI = new AgreementTypeBI(); AgreementTypeEntity agreemententity = agreementTypeBI.ReadTitle(SessionManager.AgreementTypeID); string email = agreemententity.Email; string agreementTitle = agreemententity.Title; string approverName = SessionManager.UsersEntity.FullName; string body = null; //body = using (StreamReader sr = new StreamReader(Server.MapPath("Templates\\EmailTemplete.txt"))) { body = sr.ReadToEnd(); } body = body.Replace("[APPROVER_NAME]", approverName); body = body.Replace("[AGREEMENT_TITLE]", agreementTitle); body = body.Replace("[APPROVER_NAME]", approverName); body = body.Replace("[COMMENTS]", txtComment.Text.Trim()); body = body.Replace("[ACTIONS]", txtAction.Text.Trim()); EmailHelper.SendEmail(new List<string>() { email }, agreementTitle + " Agreement Rejected", body, null); ClientScript.RegisterStartupScript(Page.GetType(), "_Rejected_", "alert('Agreement Rejected');window.location='home.aspx';", true); //ClearData(); //btnApprove.Visible = false; //btnReject.Visible = false; //btnCancel.Text = "Go To Home"; }
protected void btnApprove_Click(object sender, EventArgs e) { ApprovalEntity entity = new ApprovalEntity(); int approvalID = Convert.ToInt32(SessionManager.ApprovalID); entity.ApprovalID = (approvalID); entity.AgreementTypeID = SessionManager.AgreementTypeID; entity.Comments = txtComment.Text.Trim(); entity.Actions = txtAction.Text.Trim(); entity.Status = "A"; ApprovalBI approver = new ApprovalBI(); approver.Insert(entity); ClientScript.RegisterStartupScript( Page.GetType(), "_Approved_", "alert('Agreement Approved');window.location='home.aspx';", true); //ClearData(); //btnApprove.Visible = false; //btnReject.Visible = false; //btnCancel.Text = "Go TO Home"; }
public ApprovalEntity Read(int id, int approvalID) { Parameters = new List<SqlParameter>(); Parameters.Add(new SqlParameter("@AgreementTypeID", id)); Parameters.Add(new SqlParameter("@ApprovalID", approvalID)); ApprovalEntity entity = null; SqlDataReader reader = null; try { Parameters.Add(new SqlParameter("@Action", "R")); reader = ExecDataReader(DBCommands.Approval); if (reader.Read()) { entity = new ApprovalEntity(); entity.Status = reader["Status"].ToStr(); entity.Actions = reader["Actions"].ToStr(); entity.Comments = reader["Comments"].ToStr(); if (reader.NextResult()) { if (reader.Read()) { entity.Title = reader["Title"].ToStr(); } } } } finally { if (reader != null) { reader.Close(); reader.Dispose(); } } return entity; }
public void Insert(ApprovalEntity entity) { ApprovalDao approvalDao = new ApprovalDao(); approvalDao.Insert(entity); }