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