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