public static HBankRateCollection HBankRateGetAllItemByHouseCode(string HouseCode) { HBankRateCollection ItemCollection = new HBankRateCollection(); HBankRate item; try { Database db = SqlHelper.CreateConnection(SqlHelper.MyConnection); DbCommand dbCommand = db.GetStoredProcCommand("HBankRate_GetByHouseCode"); db.AddInParameter(dbCommand, "HousceCode", DbType.String, HouseCode); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { item = GetItemFromReader(dataReader); ItemCollection.Add(item); } } } catch (Exception objEx) { item = new HBankRate() { HousceCode = objEx.Message }; ItemCollection.Add(item); } return(ItemCollection); }
public static HBankRate AddItem(HBankRate model) { //int result = 0; //using (var reader = SqlHelper.ExecuteReader("HBankRate_Add", CreateSqlParameter(model))) //{ // while (reader.Read()) // { // result = int.Parse(reader[0].ToString()); // } //} //return GetItemByID(result); HBankRate item = null; Database db = SqlHelper.CreateConnection(SqlHelper.MyConnection); DbCommand dbCommand = db.GetStoredProcCommand("HBankRate_Add"); db.AddOutParameter(dbCommand, "HouseRateID", DbType.Int32, 0); db.AddInParameter(dbCommand, "HousceCode", DbType.String, model.HousceCode); db.AddInParameter(dbCommand, "Year", DbType.Int32, model.Year); db.AddInParameter(dbCommand, "Rate", DbType.Decimal, model.Rate); if (db.ExecuteNonQuery(dbCommand) > 0) { int itemID = Convert.ToInt32(db.GetParameterValue(dbCommand, "@HouseRateID")); item = GetItemByID(itemID); } return(item); }
public static HBankRate UpdateItem(HBankRate model) { //string result = string.Empty; //using (var reader = SqlHelper.ExecuteReader("HBankRate_Update", CreateSqlParameter(model))) //{ // while (reader.Read()) // { // result = reader[0].ToString(); // } //} //return GetItemByID(model.HouseRateID); HBankRate item = null; Database db = SqlHelper.CreateConnection(SqlHelper.MyConnection); DbCommand dbCommand = db.GetStoredProcCommand("HBankRate_Update"); db.AddInParameter(dbCommand, "HouseRateID", DbType.Int32, model.HouseRateID); db.AddInParameter(dbCommand, "Year", DbType.Int32, model.Year); db.AddInParameter(dbCommand, "HousceCode", DbType.String, model.HousceCode); db.AddInParameter(dbCommand, "Rate", DbType.Decimal, model.Rate); if (db.ExecuteNonQuery(dbCommand) > 0) { item = GetItemByID(model.HouseRateID); } //if (item != null) //{ // RemoveCache(item); //} return(item); }
private static SqlParameter[] CreateSqlParameter(HBankRate model) { return(new SqlParameter[] { new SqlParameter("@HouseRateID", model.HouseRateID), new SqlParameter("@HousceCode", model.HousceCode), new SqlParameter("@Year", model.Year), new SqlParameter("@Rate", model.Rate), }); }
private static HBankRate GetItemFromReader(IDataReader dataReader) { HBankRate objItem = new HBankRate(); objItem.HouseRateID = SqlHelper.GetInt(dataReader, "HouseRateID"); objItem.HousceCode = SqlHelper.GetString(dataReader, "HousceCode"); objItem.Year = SqlHelper.GetInt(dataReader, "Year"); objItem.Rate = SqlHelper.GetDecimal(dataReader, "Rate"); return(objItem); }
public static HBankRate GetItemByID(Int64 houseRateID) { HBankRate item = new HBankRate(); Database db = SqlHelper.CreateConnection(SqlHelper.MyConnection); DbCommand dbCommand = db.GetStoredProcCommand("HBankRate_GetByID"); db.AddInParameter(dbCommand, "HouseRateID", DbType.Int64, houseRateID); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { item = GetItemFromReader(dataReader); } } return(item); }
public static HBankRateCollection HBankRateDefaultByHouseCode(DBtblHouseBanking objHouseItem) { HBankRateCollection collection = new HBankRateCollection(); if (objHouseItem != null) { HBankRate objItem; for (int i = 0; i < objHouseItem.BYear; i++) { objItem = new HBankRate() { HouseRateID = 0, Year = i + 1, Rate = objHouseItem.BRate }; collection.Add(objItem); } } return(collection); }