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