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;
}
