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