internal DataTable DataApproved(PendingVouchersModel objPendingVouchersModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPPendingVouchers"; ClsCon.cmd.Parameters.AddWithValue("@Ind", objPendingVouchersModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objPendingVouchersModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", objPendingVouchersModel.BrID); ClsCon.cmd.Parameters.AddWithValue("@YrCD", objPendingVouchersModel.YrCD); ClsCon.cmd.Parameters.AddWithValue("@TransactionNo", objPendingVouchersModel.TransactionNo); ClsCon.cmd.Parameters.AddWithValue("@TransactionDate", objPendingVouchersModel.TransactionDate); ClsCon.cmd.Parameters.AddWithValue("@BankPayTNo", objPendingVouchersModel.BankPayTNo); ClsCon.cmd.Parameters.AddWithValue("@BankPayVType", objPendingVouchersModel.BankPayVType); ClsCon.cmd.Parameters.AddWithValue("@VchType", objPendingVouchersModel.VchType); ClsCon.cmd.Parameters.AddWithValue("@ApprovalDate", objPendingVouchersModel.ApprovalDate); ClsCon.cmd.Parameters.AddWithValue("@ApprovalRemark", objPendingVouchersModel.ApprovalRemark); ClsCon.cmd.Parameters.AddWithValue("@User", objPendingVouchersModel.User); ClsCon.cmd.Parameters.AddWithValue("@IPAddress", objPendingVouchersModel.IP); ClsCon.cmd.Parameters.AddWithValue("@IsFinal", objPendingVouchersModel.IsFinal); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtPendingVouchers = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtPendingVouchers); dtPendingVouchers.TableName = "success"; } catch (Exception) { dtPendingVouchers = new DataTable(); dtPendingVouchers.TableName = "error"; return(dtPendingVouchers); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtPendingVouchers); }
internal DataSet BindPendingVouchers(PendingVouchersModel objPendingVouchersModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPPendingVouchers"; ClsCon.cmd.Parameters.AddWithValue("@Ind", objPendingVouchersModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objPendingVouchersModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", objPendingVouchersModel.BrID); ClsCon.cmd.Parameters.AddWithValue("@YrCD", objPendingVouchersModel.YrCD); ClsCon.cmd.Parameters.AddWithValue("@UserLevel", objPendingVouchersModel.UserLevel); //ClsCon.cmd.Parameters.AddWithValue("@User", objPendingVouchersModel.User); //ClsCon.cmd.Parameters.AddWithValue("@IsAdmin", objPendingVouchersModel.IsAdmin); //ClsCon.cmd.Parameters.AddWithValue("@DepartmentID", objPendingVouchersModel.DepartmentID); //ClsCon.cmd.Parameters.AddWithValue("@SubDepartmentID", objPendingVouchersModel.SubDepartmentID); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dsPendingVouchers = new DataSet(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dsPendingVouchers); dsPendingVouchers.DataSetName = "success"; } catch (Exception) { dsPendingVouchers = new DataSet(); dsPendingVouchers.DataSetName = "error"; return(dsPendingVouchers); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dsPendingVouchers); }
internal DataTable AuditPendingRecords(PendingVouchersModel objPendingVouchersModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPPendingVouchers"; ClsCon.cmd.Parameters.AddWithValue("@Ind", objPendingVouchersModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objPendingVouchersModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", objPendingVouchersModel.BrID); ClsCon.cmd.Parameters.AddWithValue("@YrCD", objPendingVouchersModel.YrCD); ClsCon.cmd.Parameters.AddWithValue("@TransactionNo", objPendingVouchersModel.TransactionNo); ClsCon.cmd.Parameters.AddWithValue("@TransactionDate", objPendingVouchersModel.TransactionDate); ClsCon.cmd.Parameters.AddWithValue("@VchType", objPendingVouchersModel.VchType); ClsCon.cmd.Parameters.AddWithValue("@IsAudit", objPendingVouchersModel.IsAudit); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtPendingVouchers = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtPendingVouchers); dtPendingVouchers.TableName = "success"; } catch (Exception) { dtPendingVouchers = new DataTable(); dtPendingVouchers.TableName = "error"; return(dtPendingVouchers); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtPendingVouchers); }
public DataTable AuditPendingRecords(PendingVouchersModel objPendingVouchersModel) { DataTable dtApproved = objPendingVouchersDA.AuditPendingRecords(objPendingVouchersModel); return(dtApproved); }
public DataTable FinalApproval(PendingVouchersModel objPendingVouchersModel) { DataTable dtApproved = objPendingVouchersDA.FinalApproval(objPendingVouchersModel); return(dtApproved); }
public DataTable DataApproved(PendingVouchersModel objPendingVouchersModel) { DataTable dtApproved = objPendingVouchersDA.DataApproved(objPendingVouchersModel); return(dtApproved); }
public DataSet BindPendingVouchers(PendingVouchersModel objPendingVouchersModel) { DataSet dsPendingVouchers = objPendingVouchersDA.BindPendingVouchers(objPendingVouchersModel); return(dsPendingVouchers); }