public static List <StoreBankingDetail> GetReportClaimBankingMMS(string claimMonth, int companyId, int locationId, int claimSupplierId, int claimTypeId) { List <StoreBankingDetail> list = new List <StoreBankingDetail>(); Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep"); string sqlCommand = "GetReportClaimBankingMMS"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@ClaimMonth", DbType.String, claimMonth); db.AddInParameter(dbCommand, "@CompanyId", DbType.Int32, companyId); db.AddInParameter(dbCommand, "@LocationId", DbType.Int32, locationId); db.AddInParameter(dbCommand, "@ClaimSupplierId", DbType.Int32, claimSupplierId); db.AddInParameter(dbCommand, "@ClaimTypeId", DbType.Int32, claimTypeId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { StoreBankingDetail storeBankingDetail = new StoreBankingDetail(); storeBankingDetail.StoreName = dataReader["StoreName"].ToString(); storeBankingDetail.AccountNumber = dataReader["AccountNumber"].ToString(); storeBankingDetail.AccountType = dataReader["AccountType"].ToString(); storeBankingDetail.BranchNumber = dataReader["BranchNumber"].ToString(); storeBankingDetail.OwnReference = dataReader["OwnReference"].ToString(); storeBankingDetail.RecipientReference = dataReader["RecipientReference"].ToString(); storeBankingDetail.EmailNotify1 = dataReader["EmailNotify1"].ToString(); storeBankingDetail.EmailAddress1 = dataReader["EmailAddress1"].ToString(); storeBankingDetail.EmailSubject1 = dataReader["EmailSubject1"].ToString(); storeBankingDetail.Amount = Convert.ToDecimal(dataReader["Amount"]); list.Add(storeBankingDetail); } } return(list); }
public static StoreBankingDetail GetStoreBankingDetailByStoreBankingDetailId(int storeBankingDetailId) { Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep"); string sqlCommand = "GetStoreBankingDetailByStoreBankingDetailId"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@StoreBankingDetailId", DbType.Int32, storeBankingDetailId); db.AddOutParameter(dbCommand, "@StoreId", DbType.Int32, 4); db.AddOutParameter(dbCommand, "@BranchNumber", DbType.Int32, 4); db.AddOutParameter(dbCommand, "@AccountNumber", DbType.Int64, 4); db.AddOutParameter(dbCommand, "@CompanyId", DbType.Int32, 4); db.AddOutParameter(dbCommand, "@StoreBankAccountTypeId", DbType.Int32, 4); db.AddOutParameter(dbCommand, "@EmailNotify1", DbType.String, 50); db.AddOutParameter(dbCommand, "@EmailAddress1", DbType.String, 50); db.ExecuteNonQuery(dbCommand); StoreBankingDetail storeBankingDetail = new StoreBankingDetail(); storeBankingDetail.StoreBankingDetailId = storeBankingDetailId; storeBankingDetail.StoreId = Convert.ToInt32(db.GetParameterValue(dbCommand, "StoreId")); storeBankingDetail.BranchNumber = db.GetParameterValue(dbCommand, "BranchNumber").ToString(); storeBankingDetail.AccountNumber = db.GetParameterValue(dbCommand, "AccountNumber").ToString(); storeBankingDetail.CompanyId = Convert.ToInt32(db.GetParameterValue(dbCommand, "CompanyId")); storeBankingDetail.StoreBankAccountTypeId = Convert.ToInt32(db.GetParameterValue(dbCommand, "StoreBankAccountTypeId")); storeBankingDetail.EmailNotify1 = db.GetParameterValue(dbCommand, "EmailNotify1").ToString(); storeBankingDetail.EmailAddress1 = db.GetParameterValue(dbCommand, "EmailAddress1").ToString(); return(storeBankingDetail); }