public static UserHistory UpdateItem(UserHistory model) { String result = String.Empty; using (var reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "tblUserHistory_Update", CreateSqlParameter(model))) { while (reader.Read()) { result = (String)reader[0]; } } return(GetItemByID(result)); }
public static UserHistoryCollection GetAllItem() { UserHistoryCollection collection = new UserHistoryCollection(); using (var reader = SqlHelper.ExecuteReader("tblUserHistory_GetAll", null)) { while (reader.Read()) { UserHistory obj = new UserHistory(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static UserHistory GetItemByID(String userName) { UserHistory item = new UserHistory(); var sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@UserName", userName); using (var reader = SqlHelper.ExecuteReader("tblUserHistory_GetByID", sqlParams)) { while (reader.Read()) { item = GetItemFromReader(reader); } } return(item); }
public static UserHistory AddItem(UserHistory model) { String result = String.Empty; try { using (var reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "tblUserHistory_Add", CreateSqlParameter(model))) { while (reader.Read()) { result = (String)reader[0]; } } } catch (Exception objEx) { result = objEx.Message; } return(GetItemByID(result)); }
private static UserHistory GetItemFromReader(IDataReader dataReader) { UserHistory objItem = new UserHistory(); objItem.UserName = SqlHelper.GetString(dataReader, "UserName"); objItem.CuryId = SqlHelper.GetString(dataReader, "CuryId"); objItem.ToCuryId = SqlHelper.GetString(dataReader, "ToCuryId"); objItem.FinPeriod = SqlHelper.GetString(dataReader, "FinPeriod"); objItem.Payment = SqlHelper.GetDecimal(dataReader, "Payment"); objItem.CuryPayment = SqlHelper.GetDecimal(dataReader, "CuryPayment"); objItem.ReceiveAmt = SqlHelper.GetDecimal(dataReader, "ReceiveAmt"); objItem.CuryReceiveAmt = SqlHelper.GetDecimal(dataReader, "CuryReceiveAmt"); objItem.SaleAmt = SqlHelper.GetDecimal(dataReader, "SaleAmt"); objItem.CurySaleAmt = SqlHelper.GetDecimal(dataReader, "CurySaleAmt"); objItem.PurchaseAmt = SqlHelper.GetDecimal(dataReader, "PurchaseAmt"); objItem.CuryPurchaseAmt = SqlHelper.GetDecimal(dataReader, "CuryPurchaseAmt"); objItem.BalanceAmt = SqlHelper.GetDecimal(dataReader, "BalanceAmt"); objItem.CuryBalanceAmt = SqlHelper.GetDecimal(dataReader, "CuryBalanceAmt"); objItem.CreatedUser = SqlHelper.GetString(dataReader, "CreatedUser"); objItem.CreatedDate = SqlHelper.GetDateTime(dataReader, "CreatedDate"); objItem.UpdatedDate = SqlHelper.GetDateTime(dataReader, "UpdatedDate"); return(objItem); }
private static SqlParameter[] CreateSqlParameter(UserHistory model) { return(new SqlParameter[] { new SqlParameter("@UserName", model.UserName), new SqlParameter("@CuryId", model.CuryId), new SqlParameter("@ToCuryId", model.ToCuryId), new SqlParameter("@FinPeriod", model.FinPeriod), new SqlParameter("@Payment", model.Payment), new SqlParameter("@CuryPayment", model.CuryPayment), new SqlParameter("@ReceiveAmt", model.ReceiveAmt), new SqlParameter("@CuryReceiveAmt", model.CuryReceiveAmt), new SqlParameter("@SaleAmt", model.SaleAmt), new SqlParameter("@CurySaleAmt", model.CurySaleAmt), new SqlParameter("@PurchaseAmt", model.PurchaseAmt), new SqlParameter("@CuryPurchaseAmt", model.CuryPurchaseAmt), new SqlParameter("@BalanceAmt", model.BalanceAmt), new SqlParameter("@CuryBalanceAmt", model.CuryBalanceAmt), new SqlParameter("@CreatedUser", model.CreatedUser), new SqlParameter("@CreatedDate", model.CreatedDate), new SqlParameter("@UpdatedDate", model.UpdatedDate), }); }