public static List <ClaimSku> GetReportClaimSkuSubCategoryNational(int accountId, string claimMonth, string supplier /*, int locationId*/)
{
List <ClaimSku> list = new List <ClaimSku>();
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetReportClaimSkuSubCategoryNational";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@AccountId", DbType.Int32, accountId);
db.AddInParameter(dbCommand, "@ClaimMonth", DbType.String, claimMonth);
db.AddInParameter(dbCommand, "@Supplier", DbType.String, supplier);
//db.AddInParameter(dbCommand, "@LocationId", DbType.Int32, locationId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
ClaimSku claimSku = new ClaimSku();
claimSku.ClaimSkuSubCategory = dataReader["LineItem"].ToString();
claimSku.Quantity = Convert.ToInt32(dataReader["Quantity"]);
list.Add(claimSku);
}
}
return(list);
}
public static List <ClaimSku> GetClaimSkuListByClaimNumberAndUserName(string claimNumber, string userName)
{
List <ClaimSku> list = new List <ClaimSku>();
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetClaimSkuListByClaimNumberAndUserName";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@ClaimNumber", DbType.String, claimNumber);
db.AddInParameter(dbCommand, "@UserName", DbType.String, userName);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
ClaimSku claimSku = new ClaimSku();
claimSku.ClaimSkuId = Convert.ToInt32(dataReader["ClaimSkuId"]);
claimSku.StoreId = Convert.ToInt32(dataReader["StoreId"]);
claimSku.ClaimDate = Convert.ToDateTime(dataReader["ClaimDate"]);
claimSku.ClaimNumber = dataReader["ClaimNumber"].ToString();
claimSku.Store = dataReader["Store"].ToString();
list.Add(claimSku);
}
}
return(list);
}
public static List <ClaimSku> GetClaimSkuDetailListByClaimNumberAndUserName(string claimNumber, int storeId, string userName)
{
List <ClaimSku> list = new List <ClaimSku>();
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetClaimSkuDetailListByClaimNumberAndUserName";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@ClaimNumber", DbType.String, claimNumber);
db.AddInParameter(dbCommand, "@UserName", DbType.String, userName);
db.AddInParameter(dbCommand, "@StoreId", DbType.Int32, storeId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
ClaimSku claimSku = new ClaimSku();
claimSku.ClaimSkuDetailId = Convert.ToInt32(dataReader["ClaimSkuDetailId"]);
claimSku.ClaimSkuCategory = dataReader["ClaimSkuCategory"].ToString();
claimSku.ClaimSkuSubCategory = dataReader["ClaimSkuSubCategory"].ToString();
claimSku.Quantity = Convert.ToInt32(dataReader["Quantity"]);
claimSku.TotalQuantity = Convert.ToInt32(dataReader["TotalQuantity"]);
list.Add(claimSku);
}
}
return(list);
}
public static ClaimSku GetClaimSkuByClaimSkuId(int claimSkuId)
{
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetClaimSkuByClaimSkuId";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@ClaimSkuId", DbType.Int32, claimSkuId);
db.AddOutParameter(dbCommand, "@StoreId", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "@ClaimDate", DbType.DateTime, 4);
db.AddOutParameter(dbCommand, "@ClaimNumber", DbType.String, 50);
db.AddOutParameter(dbCommand, "@ModifiedUser", DbType.String, 50);
db.AddOutParameter(dbCommand, "@CompanyId", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "@Supplier", DbType.String, 50);
db.AddOutParameter(dbCommand, "@CreatedDate", DbType.DateTime, 8);
db.ExecuteNonQuery(dbCommand);
ClaimSku claimSku = new ClaimSku();
claimSku.ClaimSkuId = claimSkuId;
claimSku.StoreId = Convert.ToInt32(db.GetParameterValue(dbCommand, "StoreId"));
claimSku.ClaimDate = Convert.ToDateTime(db.GetParameterValue(dbCommand, "ClaimDate"));
claimSku.ClaimNumber = db.GetParameterValue(dbCommand, "ClaimNumber").ToString();
claimSku.ModifiedUser = db.GetParameterValue(dbCommand, "ModifiedUser").ToString();
claimSku.CompanyId = Convert.ToInt32(db.GetParameterValue(dbCommand, "CompanyId"));
claimSku.Supplier = db.GetParameterValue(dbCommand, "Supplier").ToString();
claimSku.CreatedDate = Convert.ToDateTime(db.GetParameterValue(dbCommand, "CreatedDate"));
return(claimSku);
}
public static ClaimSku GetClaimSkuDetailByClaimNumberAndStoreId(string claimNumber, int storeId)
{
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetClaimSkuDetailByClaimNumberAndStoreId";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@ClaimNumber", DbType.String, claimNumber);
db.AddInParameter(dbCommand, "@StoreId", DbType.Int32, storeId);
db.AddOutParameter(dbCommand, "@ClamSkuCategoryId", DbType.Int32, 4);
db.ExecuteNonQuery(dbCommand);
ClaimSku claimSku = new ClaimSku();
claimSku.ClaimSkuCategoryId = Convert.ToInt32(db.GetParameterValue(dbCommand, "ClamSkuCategoryId"));
return(claimSku);
}
public static ClaimSku GetClaimSkuByClaimNumberAndAccountAndStoreId(string claimNumber, int accountId, int storeId)
{
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetClaimSkuByClaimNumberAndAccountAndStoreId";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@ClaimNumber", DbType.String, claimNumber);
db.AddInParameter(dbCommand, "@AccountId", DbType.Int32, accountId);
db.AddInParameter(dbCommand, "@StoreId", DbType.Int32, storeId);
db.AddOutParameter(dbCommand, "@Supplier", DbType.String, 50);
db.ExecuteNonQuery(dbCommand);
ClaimSku claimSku = new ClaimSku();
claimSku.Supplier = db.GetParameterValue(dbCommand, "Supplier").ToString();
return(claimSku);
}
public static ClaimSku GetClaimSkuDetailByClaimSkuDetailId(int claimSkuDetailId)
{
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetClaimSkuDetailByClaimSkuDetailId";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@ClaimSkuDetailId", DbType.Int32, claimSkuDetailId);
db.AddOutParameter(dbCommand, "@ClaimSkuCategoryId", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "@ClaimSkuSubCategoryId", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "@Quantity", DbType.Int32, 4);
db.ExecuteNonQuery(dbCommand);
ClaimSku claimSku = new ClaimSku();
claimSku.ClaimSkuCategoryId = Convert.ToInt32(db.GetParameterValue(dbCommand, "ClaimSkuCategoryId"));
claimSku.ClaimSkuSubCategoryId = Convert.ToInt32(db.GetParameterValue(dbCommand, "ClaimSkuSubCategoryId"));
claimSku.Quantity = Convert.ToInt32(db.GetParameterValue(dbCommand, "Quantity"));
return(claimSku);
}
public static List <ClaimSku> GetClaimSkuCategoryList()
{
List <ClaimSku> list = new List <ClaimSku>();
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetClaimSkuCategoryList";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
ClaimSku claimSku = new ClaimSku();
claimSku.ClaimSkuCategoryId = Convert.ToInt32(dataReader["claimSkuCategoryId"]);
claimSku.Description = dataReader["Description"].ToString();
list.Add(claimSku);
}
}
return(list);
}
public static List <ClaimSku> GetClaimNumberListByAccountId(int accountId)
{
List <ClaimSku> list = new List <ClaimSku>();
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetClaimNumberListByAccountId";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@AccountId", DbType.Int32, accountId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
ClaimSku claimSku = new ClaimSku();
claimSku.ClaimNumberStoreId = dataReader["ClaimNumberStoreId"].ToString();
claimSku.ClaimStore = dataReader["ClaimStore"].ToString();
list.Add(claimSku);
}
}
return(list);
}
public static List <ClaimSku> GetClaimSkuMonthByStore(int storeId, int accountId)
{
List <ClaimSku> list = new List <ClaimSku>();
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetClaimSkuMonthByStore";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@StoreId", DbType.Int32, storeId);
db.AddInParameter(dbCommand, "@AccountId", DbType.Int32, accountId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
ClaimSku claimSku = new ClaimSku();
//claimSku.ClaimSkuId = Convert.ToInt32(dataReader["ClaimSkuId"]);
//claimSku.StoreId = Convert.ToInt32(dataReader["StoreId"]);
claimSku.ClaimDate = Convert.ToDateTime(dataReader["ClaimDate"]);
list.Add(claimSku);
}
}
return(list);
}
