public ApproversEntity Read(int agreementID) { Parameters = new List<SqlParameter>(); Parameters.Add(new SqlParameter("@AgreementTypeID", agreementID)); ApproversEntity entity = null; SqlDataReader reader = null; try { Parameters.Add(new SqlParameter("@Action", "R")); reader = ExecDataReader(DBCommands.Approvers); if (reader.Read()) { entity = new ApproversEntity(); entity.AgreementApproversID = reader["AgreementApproversID"].ToInt32(); entity.AgreementReviewer = reader["AgreementReviewer"].ToInt32(); entity.BusinessReviewer = reader["BusinessReviewer"].ToInt32(); entity.LawyerApprover = reader["LawyerApprover"].ToInt32(); entity.OtherApprover = reader["OtherApprover"].ToInt32(); } } finally { if (reader != null) { reader.Close(); reader.Dispose(); } } return entity; }
public int Insert(ApproversEntity entity) { Parameters = new List<SqlParameter>(); Parameters.Add(new SqlParameter("@AgreementApproversID", entity.AgreementApproversID)); Parameters.Add(new SqlParameter("@AgreementTypeID", entity.AgreementTypeID)); Parameters.Add(new SqlParameter("@AgreementReviewer", entity.AgreementReviewer)); Parameters.Add(new SqlParameter("@BusinessReviewer", entity.BusinessReviewer)); Parameters.Add(new SqlParameter("@LawyerApprover", entity.LawyerApprover)); Parameters.Add(new SqlParameter("@OtherApprover", entity.OtherApprover)); object aggrementApproversID = null; if (entity.AgreementApproversID == 0) { Parameters.Add(new SqlParameter("@Action", "C")); aggrementApproversID = ExecuteScalar(DBCommands.Approvers); } else { Parameters.Add(new SqlParameter("@Action", "U")); ExecCommand(DBCommands.Approvers); aggrementApproversID = entity.AgreementApproversID; } return Convert.ToInt32(aggrementApproversID); }
public int Insert(ApproversEntity entity) { ApproversDao approverDao = new ApproversDao(); return approverDao.Insert(entity); }
private int SaveData() { ApproversEntity entity = new ApproversEntity(); // int agreementID = SessionManager.AgreementTypeID int agreementID = SessionManager.AgreementTypeID; entity.AgreementTypeID = agreementID; if (hdnAgreementApproversID.Value != string.Empty) { entity.AgreementApproversID = Convert.ToInt32(hdnAgreementApproversID.Value); } if (ddlAgreementReviewer.SelectedValue == string.Empty) entity.AgreementReviewer = null; else entity.AgreementReviewer = Convert.ToInt32(ddlAgreementReviewer.SelectedValue); if (ddlBusinessTypeApprover.SelectedValue == string.Empty) entity.BusinessReviewer = null; else //entity.BusinessReviewer = Convert.ToInt32(ddlBusinessTypeApprover.SelectedIndex); entity.BusinessReviewer = Convert.ToInt32(ddlBusinessTypeApprover.SelectedValue); if (ddlLawyerApprover.SelectedValue == string.Empty) entity.LawyerApprover = null; else //entity.LawyerApprover = Convert.ToInt32(ddlBusinessTypeApprover.SelectedValue); entity.LawyerApprover = Convert.ToInt32(ddlLawyerApprover.SelectedValue); if (ddlOtherApprover.SelectedValue == string.Empty) entity.OtherApprover = null; else //entity.OtherApprover = Convert.ToInt32(ddlBusinessTypeApprover.SelectedValue); entity.OtherApprover = Convert.ToInt32(ddlOtherApprover.SelectedValue); ApproverBI approver = new ApproverBI(); int agreementApproverID = approver.Insert(entity); Status(); return agreementApproverID; }