public static UserTran UpdateItem(UserTran model) { String result = String.Empty; using (var reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "tblUserTran_Update", CreateSqlParameter(model))) { while (reader.Read()) { result = (String)reader[0]; } } return(GetItemByID(result)); }
public static UserTranCollection GetAllItem() { UserTranCollection collection = new UserTranCollection(); using (var reader = SqlHelper.ExecuteReader("tblUserTran_GetAll", null)) { while (reader.Read()) { UserTran obj = new UserTran(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static UserTran GetItemByID(String tranCode) { UserTran item = new UserTran(); var sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@TranCode", tranCode); using (var reader = SqlHelper.ExecuteReader("tblUserTran_GetByID", sqlParams)) { while (reader.Read()) { item = GetItemFromReader(reader); } } return(item); }
private static SqlParameter[] CreateSqlParameter(UserTran model) { return(new SqlParameter[] { new SqlParameter("@TranCode", model.TranCode), new SqlParameter("@TranType", model.TranType), new SqlParameter("@RefNbr", model.RefNbr), new SqlParameter("@TranDesc", model.TranDesc), new SqlParameter("@Amt", model.Amt), new SqlParameter("@CuryAmt", model.CuryAmt), new SqlParameter("@CuryId", model.CuryId), new SqlParameter("@PayDate", model.PayDate), new SqlParameter("@TranDate", model.TranDate), new SqlParameter("@FinPeriod", model.FinPeriod), new SqlParameter("@Release", model.Release), new SqlParameter("@CreatedUser", model.CreatedUser), new SqlParameter("@CreatedDate", model.CreatedDate), }); }
public static UserTran AddItem(UserTran model) { String result = String.Empty; try { using (var reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "tblUserTran_Add", CreateSqlParameter(model))) { while (reader.Read()) { result = (String)reader[0]; } } } catch (Exception Objex) { } return(GetItemByID(result)); }
private static UserTran GetItemFromReader(IDataReader dataReader) { UserTran objItem = new UserTran(); objItem.TranCode = SqlHelper.GetString(dataReader, "TranCode"); objItem.TranType = SqlHelper.GetString(dataReader, "TranType"); objItem.RefNbr = SqlHelper.GetString(dataReader, "RefNbr"); objItem.TranDesc = SqlHelper.GetString(dataReader, "TranDesc"); objItem.Amt = SqlHelper.GetDecimal(dataReader, "Amt"); objItem.CuryAmt = SqlHelper.GetDecimal(dataReader, "CuryAmt"); objItem.CuryId = SqlHelper.GetString(dataReader, "CuryId"); objItem.PayDate = SqlHelper.GetDateTime(dataReader, "PayDate"); objItem.TranDate = SqlHelper.GetDateTime(dataReader, "TranDate"); objItem.FinPeriod = SqlHelper.GetString(dataReader, "FinPeriod"); objItem.Release = SqlHelper.GetBoolean(dataReader, "Release"); objItem.IsIncome = SqlHelper.GetBoolean(dataReader, "IsIncome"); objItem.CreatedUser = SqlHelper.GetString(dataReader, "CreatedUser"); objItem.CreatedDate = SqlHelper.GetDateTime(dataReader, "CreatedDate"); objItem.PaymentName = SqlHelper.GetString(dataReader, "PaymentName"); objItem.RevieveName = SqlHelper.GetString(dataReader, "RevieveName"); objItem.Rate = SqlHelper.GetDecimal(dataReader, "Rate"); return(objItem); }