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