public ACC_OpeningBalance GetACC_OpeningBalanceFromReader(IDataReader reader) { try { ACC_OpeningBalance aCC_OpeningBalance = new ACC_OpeningBalance ( DataAccessObject.IsNULL<int>(reader["OpeningBalanceID"]), DataAccessObject.IsNULL<string>(reader["OpeningBalanceName"]), DataAccessObject.IsNULL<decimal>(reader["Amount"]), DataAccessObject.IsNULL<bool>(reader["IsUsed"]), DataAccessObject.IsNULL<int>(reader["HeadID"]), 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"]) ); return aCC_OpeningBalance; } catch(Exception ex) { return null; } }
public bool UpdateACC_OpeningBalance(ACC_OpeningBalance aCC_OpeningBalance) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateACC_OpeningBalance", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@OpeningBalanceID", SqlDbType.Int).Value = aCC_OpeningBalance.OpeningBalanceID; cmd.Parameters.Add("@OpeningBalanceName", SqlDbType.NVarChar).Value = aCC_OpeningBalance.OpeningBalanceName; cmd.Parameters.Add("@Amount", SqlDbType.Decimal).Value = aCC_OpeningBalance.Amount; cmd.Parameters.Add("@IsUsed", SqlDbType.Bit).Value = aCC_OpeningBalance.IsUsed; cmd.Parameters.Add("@HeadID", SqlDbType.Int).Value = aCC_OpeningBalance.HeadID; cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = aCC_OpeningBalance.UpdatedBy; cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = aCC_OpeningBalance.UpdateDate; cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = aCC_OpeningBalance.RowStatusID; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }