private static ProviderRate GetItemFromReader(IDataReader dataReader)
{
ProviderRate objItem = new ProviderRate();
objItem.ProviderID = SqlHelper.GetInt(dataReader, "ProviderID");
objItem.CompanyID = SqlHelper.GetInt(dataReader, "CompanyID");
objItem.RateID = SqlHelper.GetInt(dataReader, "RateID");
objItem.SharingPer = SqlHelper.GetInt(dataReader, "SharingPer");
objItem.Rate = SqlHelper.GetDecimal(dataReader, "Rate");
objItem.CreatedUser = SqlHelper.GetString(dataReader, "CreatedUser");
objItem.CreatedDate = SqlHelper.GetDateTime(dataReader, "CreatedDate");
if (SqlHelper.ColumnExists(dataReader, "TotalRecord"))
{
objItem.TotalRecord = SqlHelper.GetInt(dataReader, "TotalRecord");
}
return(objItem);
}
private static SqlParameter[] CreateSqlParameter(ProviderRate model)
{
return(new SqlParameter[]
{
new SqlParameter("@ProviderID", model.ProviderID),
new SqlParameter("@CompanyID", model.CompanyID),
new SqlParameter("@RateID", model.RateID),
new SqlParameter("@SharingPer", model.SharingPer),
new SqlParameter("@Rate", model.Rate),
new SqlParameter("@CreatedUser", model.CreatedUser),
new SqlParameter("@CreatedDate", model.CreatedDate),
});
}
public static ProviderRate UpdateItem(ProviderRate model)
{
String result = String.Empty;
using (var reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "ARProviderRate_Update", CreateSqlParameter(model)))
{
while (reader.Read())
{
result = (String)reader[0];
}
}
return(GetItemByID(model.RateID, model.CompanyID));
}
public static ProviderRateCollection Search(SearchFilter SearchKey)
{
ProviderRateCollection collection = new ProviderRateCollection();
using (var reader = SqlHelper.ExecuteReader("ARProviderRate_Search", SearchFilterManager.SqlSearchParam(SearchKey)))
{
while (reader.Read())
{
ProviderRate obj = new ProviderRate();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static ProviderRate GetItemByID(int RateID, int CompanyID)
{
ProviderRate item = new ProviderRate();
var sqlParams = new SqlParameter[]
{
new SqlParameter("@RateID", RateID),
new SqlParameter("@CompanyID", CompanyID),
};
using (var reader = SqlHelper.ExecuteReader("ARProviderRate_GetByID", sqlParams))
{
while (reader.Read())
{
item = GetItemFromReader(reader);
}
}
return(item);
}
public static ProviderRate AddItem(ProviderRate model)
{
int result = 0;
try
{
using (var reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "ARProviderRate_Add", CreateSqlParameter(model)))
{
while (reader.Read())
{
result = (int)reader[0];
}
}
}
catch (Exception ObjEx)
{
}
return(GetItemByID(result, model.CompanyID));
}
public static ProviderRateCollection GetAllItem(int CompanyID)
{
ProviderRateCollection collection = new ProviderRateCollection();
var sqlParams = new SqlParameter[]
{
new SqlParameter("@CompanyID", CompanyID),
};
using (var reader = SqlHelper.ExecuteReader("ARProviderRate_GetAll", sqlParams))
{
while (reader.Read())
{
ProviderRate obj = new ProviderRate();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
