public ApprovalModel UpdateApproval(ApprovalModel approval)
{
int i = -1;
using (OleDbCommand command = new OleDbCommand())
{
i = base.ExecuteNonQuery(ApprovalStringsInner.UpdateApproval(approval));
}
return(GetOneApprovalByCode(approval.approvalCode));
}
public int DeleteApprovalById(string approvalPersonId)
{
int i = 0;
using (OleDbCommand command = new OleDbCommand())
{
i = base.ExecuteNonQuery(ApprovalStringsInner.DeleteApprovalById(approvalPersonId));
}
return(i);
}
public int DeleteApproval(int approvalNumber)
{
int i = 0;
using (OleDbCommand command = new OleDbCommand())
{
i = base.ExecuteNonQuery(ApprovalStringsInner.DeleteApproval(approvalNumber));
}
return(i);
}
public ApprovalModel GetOneApprovalByNumber(int approvalNumber)
{
DataTable dt = new DataTable();
ApprovalModel app = new ApprovalModel();
using (OleDbCommand command = new OleDbCommand())
{
dt = GetMultipleQuery(ApprovalStringsInner.GetOneApprovalByNumber(approvalNumber));
}
foreach (DataRow ms in dt.Rows)
{
app = ApprovalModel.ToObject(ms);
}
return(app);
}
public List <ApprovalModel> GetAllApprovals()
{
DataTable dt = new DataTable();
List <ApprovalModel> apv = new List <ApprovalModel>();
using (OleDbCommand command = new OleDbCommand())
{
dt = GetMultipleQuery(ApprovalStringsInner.GetAllApprovals());
}
foreach (DataRow ms in dt.Rows)
{
apv.Add(ApprovalModel.ToObject(ms));
}
return(apv);
}
