public static List <ReportDetail> GetReportStoreNotLinked(int companyId, string location, string region, string format) { List <ReportDetail> list = new List <ReportDetail>(); Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep"); string sqlCommand = "GetReportStoreNotLinked"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@CompanyId", DbType.Int32, companyId); db.AddInParameter(dbCommand, "@Location", DbType.String, location); db.AddInParameter(dbCommand, "@Region", DbType.String, region); db.AddInParameter(dbCommand, "@Format", DbType.String, format); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { ReportDetail reportDetail = new ReportDetail(); reportDetail.Location = dataReader["Location"].ToString(); reportDetail.Region = dataReader["Region"].ToString(); reportDetail.Store = dataReader["Store"].ToString(); reportDetail.Format = dataReader["Format"].ToString(); reportDetail.Format = dataReader["Format"].ToString(); reportDetail.Cluster = dataReader["Cluster"].ToString(); list.Add(reportDetail); } } return(list); }
public static List <ReportDetail> GetReportCountSummaryByLocationRegion(string roleName, string location, string region, int accountId) { List <ReportDetail> list = new List <ReportDetail>(); Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep"); string sqlCommand = "GetReportCountSummaryByLocationRegion"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@RoleName", DbType.String, roleName); db.AddInParameter(dbCommand, "@Location", DbType.String, location); db.AddInParameter(dbCommand, "@Region", DbType.String, region); db.AddInParameter(dbCommand, "@AccountId", DbType.Int32, accountId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { ReportDetail reportDetail = new ReportDetail(); reportDetail.EmployeeNumber = dataReader["EmployeeNumber"].ToString(); reportDetail.FirstName = dataReader["FirstName"].ToString(); reportDetail.LastName = dataReader["LastName"].ToString(); reportDetail.RoleName = dataReader["RoleName"].ToString(); list.Add(reportDetail); } } return(list); }
public static List <ReportDetail> GetReportDetailByFilter(string store, string region, string format, string employeeId, int accountId, string roleName, string location) { List <ReportDetail> list = new List <ReportDetail>(); Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep"); string sqlCommand = "GetReportDetailByFilter"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@Store", DbType.String, store); db.AddInParameter(dbCommand, "@Region", DbType.String, region); db.AddInParameter(dbCommand, "@Format", DbType.String, format); db.AddInParameter(dbCommand, "@EmployeeId", DbType.String, employeeId); db.AddInParameter(dbCommand, "@RoleName", DbType.String, roleName); db.AddInParameter(dbCommand, "@Location", DbType.String, location); db.AddInParameter(dbCommand, "@AccountId", DbType.Int32, accountId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { ReportDetail reportDetail = new ReportDetail(); reportDetail.Location = dataReader["Location"].ToString(); reportDetail.Region = dataReader["Region"].ToString(); reportDetail.Store = dataReader["Store"].ToString(); reportDetail.Format = dataReader["Format"].ToString(); reportDetail.CallCycle = dataReader["CallCycle"].ToString(); reportDetail.Day1 = Convert.ToInt32(dataReader["Day1"]); reportDetail.Day2 = Convert.ToInt32(dataReader["Day2"]); reportDetail.Day3 = Convert.ToInt32(dataReader["Day3"]); reportDetail.Day4 = Convert.ToInt32(dataReader["Day4"]); reportDetail.Day5 = Convert.ToInt32(dataReader["Day5"]); reportDetail.Day6 = Convert.ToInt32(dataReader["Day6"]); reportDetail.Day7 = Convert.ToInt32(dataReader["Day7"]); //reportDetail.Week1 = Convert.ToInt32(dataReader["Week1"]); //reportDetail.Week2 = Convert.ToInt32(dataReader["Week2"]); //reportDetail.Week3 = Convert.ToInt32(dataReader["Week3"]); //reportDetail.Week4 = Convert.ToInt32(dataReader["Week4"]); reportDetail.WeekDescription = dataReader["WeekDescription"].ToString(); reportDetail.Employee = dataReader["Employee"].ToString(); reportDetail.RoleName = dataReader["RoleName"].ToString(); list.Add(reportDetail); } } return(list); }
public static List <ReportDetail> GetReportDetailExportByFilter(string store, string region, string format, string employee) { List <ReportDetail> list = new List <ReportDetail>(); Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep"); string sqlCommand = "GetReportDetailExportByFilter"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@Store", DbType.String, store); db.AddInParameter(dbCommand, "@Region", DbType.String, region); db.AddInParameter(dbCommand, "@Format", DbType.String, format); db.AddInParameter(dbCommand, "@Employee", DbType.String, employee); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { ReportDetail reportDetail = new ReportDetail(); reportDetail.Location = dataReader["Location"].ToString(); reportDetail.Region = dataReader["Region"].ToString(); reportDetail.Store = dataReader["Store"].ToString(); reportDetail.Format = dataReader["Format"].ToString(); reportDetail.CallCycle = dataReader["CallCycle"].ToString(); reportDetail.Day1String = dataReader["Day1"].ToString(); reportDetail.Day2String = dataReader["Day2"].ToString(); reportDetail.Day3String = dataReader["Day3"].ToString(); reportDetail.Day4String = dataReader["Day4"].ToString(); reportDetail.Day5String = dataReader["Day5"].ToString(); reportDetail.Day6String = dataReader["Day6"].ToString(); reportDetail.Day7String = dataReader["Day7"].ToString(); reportDetail.Week1String = dataReader["Week1"].ToString(); reportDetail.Week2String = dataReader["Week2"].ToString(); reportDetail.Week3String = dataReader["Week3"].ToString(); reportDetail.Week4String = dataReader["Week4"].ToString(); reportDetail.Employee = dataReader["Employee"].ToString(); list.Add(reportDetail); } } return(list); }
public static List <ReportDetail> GetReportStoreListByAccountId(int accountId) { List <ReportDetail> list = new List <ReportDetail>(); Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep"); string sqlCommand = "GetReportStoreListByAccountId"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@AccountId", DbType.Int32, accountId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { ReportDetail reportDetail = new ReportDetail(); reportDetail.StoreId = Convert.ToInt32(dataReader["StoreId"]); reportDetail.Store = dataReader["Description"].ToString(); list.Add(reportDetail); } } return(list); }