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