public static ACC_Voucher GetACC_VoucherByVoucherID(int VoucherID) { ACC_Voucher aCC_Voucher = new ACC_Voucher(); SqlACC_VoucherProvider sqlACC_VoucherProvider = new SqlACC_VoucherProvider(); aCC_Voucher = sqlACC_VoucherProvider.GetACC_VoucherByVoucherID(VoucherID); return aCC_Voucher; }
public static ACC_Voucher GetACC_RowStatusByRowStatusID(int RowStatusID) { ACC_Voucher aCC_Voucher = new ACC_Voucher(); SqlACC_VoucherProvider sqlACC_VoucherProvider = new SqlACC_VoucherProvider(); aCC_Voucher = sqlACC_VoucherProvider.GetACC_VoucherByRowStatusID(RowStatusID); return aCC_Voucher; }
public static ACC_Voucher GetACC_HeadByHeadID(int HeadID) { ACC_Voucher aCC_Voucher = new ACC_Voucher(); SqlACC_VoucherProvider sqlACC_VoucherProvider = new SqlACC_VoucherProvider(); aCC_Voucher = sqlACC_VoucherProvider.GetACC_VoucherByHeadID(HeadID); return aCC_Voucher; }
private void showACC_VoucherData() { ACC_Voucher aCC_Voucher = new ACC_Voucher(); aCC_Voucher = ACC_VoucherManager.GetACC_VoucherByVoucherID(Int32.Parse(Request.QueryString["ID"])); }
public ACC_Voucher GetACC_VoucherFromReader(IDataReader reader) { try { ACC_Voucher aCC_Voucher = new ACC_Voucher ( DataAccessObject.IsNULL<int>(reader["VoucherID"]), DataAccessObject.IsNULL<string>(reader["VoucherNo"]), DataAccessObject.IsNULL<int>(reader["HeadID"]), DataAccessObject.IsNULL<string>(reader["DebitOrCredit"]), DataAccessObject.IsNULL<string>(reader["FromTo"]), DataAccessObject.IsNULL<decimal>(reader["Amount"]), DataAccessObject.IsNULL<string>(reader["OnAccountOf"]), DataAccessObject.IsNULL<string>(reader["InWord"]), DataAccessObject.IsNULL<bool>(reader["IsApproved"]), DataAccessObject.IsNULL<DateTime>(reader["ApprovalDate"]), DataAccessObject.IsNULL<DateTime>(reader["VoucherDate"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["UpdateDate"]), DataAccessObject.IsNULL<int>(reader["RowStatusID"]), DataAccessObject.IsNULL<string>(reader["Remarks"]) ); return aCC_Voucher; } catch (Exception ex) { return null; } }
public bool UpdateACC_Voucher(ACC_Voucher aCC_Voucher) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateACC_Voucher", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@VoucherID", SqlDbType.Int).Value = aCC_Voucher.VoucherID; cmd.Parameters.Add("@VoucherNo", SqlDbType.NVarChar).Value = aCC_Voucher.VoucherNo; cmd.Parameters.Add("@HeadID", SqlDbType.Int).Value = aCC_Voucher.HeadID; cmd.Parameters.Add("@DebitOrCredit", SqlDbType.NVarChar).Value = aCC_Voucher.DebitOrCredit; cmd.Parameters.Add("@FromTo", SqlDbType.NVarChar).Value = aCC_Voucher.FromTo; cmd.Parameters.Add("@Amount", SqlDbType.Decimal).Value = aCC_Voucher.Amount; cmd.Parameters.Add("@OnAccountOf", SqlDbType.NVarChar).Value = aCC_Voucher.OnAccountOf; cmd.Parameters.Add("@InWord", SqlDbType.NText).Value = aCC_Voucher.InWord; cmd.Parameters.Add("@IsApproved", SqlDbType.Bit).Value = aCC_Voucher.IsApproved; cmd.Parameters.Add("@ApprovalDate", SqlDbType.DateTime).Value = aCC_Voucher.ApprovalDate; cmd.Parameters.Add("@VoucherDate", SqlDbType.DateTime).Value = aCC_Voucher.VoucherDate; cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = aCC_Voucher.UpdatedBy; cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = aCC_Voucher.UpdateDate; cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = aCC_Voucher.RowStatusID; cmd.Parameters.Add("@Remarks", SqlDbType.NText).Value = aCC_Voucher.Remarks; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public static int InsertACC_Voucher(ACC_Voucher aCC_Voucher) { SqlACC_VoucherProvider sqlACC_VoucherProvider = new SqlACC_VoucherProvider(); return sqlACC_VoucherProvider.InsertACC_Voucher(aCC_Voucher); }
public static bool UpdateACC_Voucher(ACC_Voucher aCC_Voucher) { SqlACC_VoucherProvider sqlACC_VoucherProvider = new SqlACC_VoucherProvider(); return sqlACC_VoucherProvider.UpdateACC_Voucher(aCC_Voucher); }