public static ARCustomerWLTran UpdateItem(ARCustomerWLTran model)
{
String result = String.Empty;
using (var reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "ARCustomerWLTran_Update", CreateSqlParameter(model)))
{
while (reader.Read())
{
result = (String)reader[0];
}
}
return(GetItemByID(model.TranID, model.CompanyID));
}
public static ARCustomerWLTranCollection Search(SearchFilter SearchKey)
{
ARCustomerWLTranCollection collection = new ARCustomerWLTranCollection();
using (var reader = SqlHelper.ExecuteReader("ARCustomerWLTran_Search", SearchFilterManager.SqlSearchDynParam(SearchKey)))
{
while (reader.Read())
{
ARCustomerWLTran obj = new ARCustomerWLTran();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
private static ARCustomerWLTran GetItemFromReader(IDataReader dataReader)
{
ARCustomerWLTran objItem = new ARCustomerWLTran();
objItem.CompanyID = SqlHelper.GetInt(dataReader, "CompanyID");
objItem.TranID = SqlHelper.GetInt64(dataReader, "TranID");
objItem.CustomerID = SqlHelper.GetString(dataReader, "CustomerID");
objItem.ProviderID = SqlHelper.GetInt(dataReader, "ProviderID");
objItem.CuryWinlossAmt = SqlHelper.GetDecimal(dataReader, "CuryWinlossAmt");
objItem.WinlossAmt = SqlHelper.GetDecimal(dataReader, "WinlossAmt");
objItem.CuryPaymentAmt = SqlHelper.GetDecimal(dataReader, "CuryPaymentAmt");
objItem.PaymentAmt = SqlHelper.GetDecimal(dataReader, "PaymentAmt");
objItem.TranDate = SqlHelper.GetDateTime(dataReader, "TranDate");
objItem.Rate = SqlHelper.GetDecimal(dataReader, "Rate");
objItem.CreatedUser = SqlHelper.GetString(dataReader, "CreatedUser");
objItem.CreatedDate = SqlHelper.GetDateTime(dataReader, "CreatedDate");
objItem.LastModifiedUser = SqlHelper.GetString(dataReader, "LastModifiedUser");
objItem.LastModifiedDate = SqlHelper.GetDateTime(dataReader, "LastModifiedDate");
objItem.SettleAmount = SqlHelper.GetDecimal(dataReader, "SettleAmount");
objItem.IsPayment = SqlHelper.GetBoolean(dataReader, "IsPayment");
if (SqlHelper.ColumnExists(dataReader, "CuryRateID"))
{
objItem.CuryRateID = SqlHelper.GetInt(dataReader, "CuryRateID");
}
if (SqlHelper.ColumnExists(dataReader, "TotalRecord"))
{
objItem.TotalRecord = SqlHelper.GetInt(dataReader, "TotalRecord");
}
return(objItem);
}
public static ARCustomerWLTran GetItemByID(Int64 TranID, int CompanyID)
{
ARCustomerWLTran item = new ARCustomerWLTran();
var sqlParams = new SqlParameter[]
{
new SqlParameter("@TranID", TranID),
new SqlParameter("@CompanyID", CompanyID),
};
using (var reader = SqlHelper.ExecuteReader("ARCustomerWLTran_GetByID", sqlParams))
{
while (reader.Read())
{
item = GetItemFromReader(reader);
}
}
return(item);
}
public static ARCustomerWLTran AddItem(ARCustomerWLTran model)
{
Int64 result = 0;
try
{
using (var reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "ARCustomerWLTran_Add", CreateSqlParameter(model)))
{
while (reader.Read())
{
result = (Int64)reader[0];
}
}
}
catch (Exception ObjEx)
{
}
return(GetItemByID(result, model.CompanyID));
}
public static ARCustomerWLTranCollection GetAllItem(int CompanyID)
{
ARCustomerWLTranCollection collection = new ARCustomerWLTranCollection();
var sqlParams = new SqlParameter[]
{
new SqlParameter("@CompanyID", CompanyID),
};
using (var reader = SqlHelper.ExecuteReader("ARCustomerWLTran_GetAll", sqlParams))
{
while (reader.Read())
{
ARCustomerWLTran obj = new ARCustomerWLTran();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
private static SqlParameter[] CreateSqlParameter(ARCustomerWLTran model)
{
return(new SqlParameter[]
{
new SqlParameter("@CompanyID", model.CompanyID),
new SqlParameter("@TranID", model.TranID),
new SqlParameter("@CustomerID", model.CustomerID),
new SqlParameter("@ProviderID", model.ProviderID),
new SqlParameter("@CuryWinlossAmt", model.CuryWinlossAmt),
new SqlParameter("@WinlossAmt", model.WinlossAmt),
new SqlParameter("@CuryPaymentAmt", model.CuryPaymentAmt),
new SqlParameter("@PaymentAmt", model.PaymentAmt),
new SqlParameter("@TranDate", model.TranDate),
new SqlParameter("@Rate", model.Rate),
new SqlParameter("@CuryRateID", model.CuryRateID),
new SqlParameter("@SettleAmount", model.SettleAmount),
new SqlParameter("@IsPayment", model.IsPayment),
new SqlParameter("@CreatedUser", model.CreatedUser),
new SqlParameter("@CreatedDate", model.CreatedDate),
new SqlParameter("@LastModifiedUser", model.LastModifiedUser),
new SqlParameter("@LastModifiedDate", model.LastModifiedDate),
});
}