public static List <RepStore> GetRepresentativeStoreListAdvance(string region, string format, int accountId, string location, int employeeId, int linkType)
{
List <RepStore> list = new List <RepStore>();
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetRepresentativeStoreListAdvance";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@Region", DbType.String, region);
db.AddInParameter(dbCommand, "@Format", DbType.String, format);
db.AddInParameter(dbCommand, "@Location", DbType.String, location);
db.AddInParameter(dbCommand, "@EmployeeId", DbType.Int32, employeeId);
db.AddInParameter(dbCommand, "@AccountId", DbType.Int32, accountId);
db.AddInParameter(dbCommand, "@LinkType", DbType.Int32, linkType);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
RepStore repStore = new RepStore();
repStore.Location = dataReader["Location"].ToString();
repStore.Region = dataReader["Region"].ToString();
repStore.Store = dataReader["Store"].ToString();
repStore.Format = dataReader["Format"].ToString();
repStore.RepStoreId = Convert.ToInt32(dataReader["RepStoreId"]);
repStore.StoreId = Convert.ToInt32(dataReader["StoreId"]);
repStore.RepStoreLink = Convert.ToBoolean(dataReader["RepStoreLink"]);
list.Add(repStore);
}
}
return(list);
}
public static RepStore GetRepStoreByRepStoreId(int repStoreId)
{
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetRepresentativeStoreByRepresentativeStoreId";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@RepresentativeStoreId", DbType.Int32, repStoreId);
db.AddOutParameter(dbCommand, "@CallCycleId", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "@EmployeeId", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "@FirstName", DbType.String, 50);
db.AddOutParameter(dbCommand, "@LastName", DbType.String, 50);
db.AddOutParameter(dbCommand, "@StoreId", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "@Store", DbType.String, 100);
db.ExecuteNonQuery(dbCommand);
RepStore repStore = new RepStore();
repStore.RepStoreId = repStoreId;
repStore.CallCycleId = Convert.ToInt32(db.GetParameterValue(dbCommand, "CallCycleId"));
repStore.EmployeeId = Convert.ToInt32(db.GetParameterValue(dbCommand, "EmployeeId"));
repStore.FirstName = db.GetParameterValue(dbCommand, "FirstName").ToString();
repStore.LastName = db.GetParameterValue(dbCommand, "LastName").ToString();
repStore.StoreId = Convert.ToInt32(db.GetParameterValue(dbCommand, "StoreId"));
repStore.Store = db.GetParameterValue(dbCommand, "Store").ToString();
return(repStore);
}
public static List <RepStore> GetRepStoreListByEmployeeId(string searchValue, int employeeId, int linked, int accountId)
{
List <RepStore> list = new List <RepStore>();
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetRepresentativeStoreListByEmployeeId";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@SearchValue", DbType.String, searchValue);
db.AddInParameter(dbCommand, "@EmployeeId", DbType.Int32, employeeId);
db.AddInParameter(dbCommand, "@Linked", DbType.Int32, linked);
db.AddInParameter(dbCommand, "@AccountId", DbType.Int32, accountId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
RepStore repStore = new RepStore();
repStore.EmployeeId = employeeId;
repStore.RepStoreId = Convert.ToInt32(dataReader["RepresentativeStoreId"]);
repStore.StoreId = Convert.ToInt32(dataReader["StoreId"]);
repStore.Store = dataReader["Store"].ToString();
repStore.Region = dataReader["Region"].ToString();
repStore.Location = dataReader["Location"].ToString();
repStore.RepStoreLink = (linked == 1) ? true : false;
repStore.Format = dataReader["Format"].ToString();
//repStore.CallCycle = dataReader["CallCycle"].ToString();
//repStore.CallCycleId = Convert.ToInt32(dataReader["CallCycleId"]);
//repStore.Day1 = Convert.ToInt32(dataReader["Day1"]);
//repStore.Day2 = Convert.ToInt32(dataReader["Day2"]);
//repStore.Day3 = Convert.ToInt32(dataReader["Day3"]);
//repStore.Day4 = Convert.ToInt32(dataReader["Day4"]);
//repStore.Day5 = Convert.ToInt32(dataReader["Day5"]);
//repStore.Day6 = Convert.ToInt32(dataReader["Day6"]);
//repStore.Day7 = Convert.ToInt32(dataReader["Day7"]);
//repStore.Week1 = Convert.ToInt32(dataReader["Week1"]);
//repStore.Week2 = Convert.ToInt32(dataReader["Week2"]);
//repStore.Week3 = Convert.ToInt32(dataReader["Week3"]);
//repStore.Week4 = Convert.ToInt32(dataReader["Week4"]);
//repStore.Week5 = Convert.ToInt32(dataReader["Week5"]);
list.Add(repStore);
}
}
return(list);
}
public static List <RepStore> GetRepStoreListByStoreId(int storeId)
{
List <RepStore> list = new List <RepStore>();
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetRepresentativeStoreListByStoreId";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@StoreId", DbType.Int32, storeId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
RepStore repStore = new RepStore();
repStore.RepStoreId = Convert.ToInt32(dataReader["RepresentativeStoreId"]);
repStore.FullName = dataReader["FullName"].ToString();
list.Add(repStore);
}
}
return(list);
}
