void Handle(Input.Trend action) { Franchises.Clear(); var franchises = Db.SQL <Franchise>("SELECT f FROM SafaArooj.Franchise f WHERE f.Coorporation = ? ORDER BY f.Trend", Data); Franchises.Data = franchises; }
public async Task <IActionResult> Edit(string id, [Bind("FranchiseNo,FranchiseName,FranchiseAddress,FranchisePostcode,FranchiseTel,FranchiseFax,FranchiseStartdate,FranchisorNo")] Franchises franchises) { if (id != franchises.FranchiseNo) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(franchises); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!FranchisesExists(franchises.FranchiseNo)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["FranchisorNo"] = new SelectList(_context.Franchisors, "FranchisorNo", "FranchisorNo", franchises.FranchisorNo); return(View(franchises)); }
public void PullFranchisesTest() { Franchises test = new Franchises(); test = dao.PullSpecificFranchise(101); Assert.AreEqual(101, test.Franchise_Id); Assert.AreEqual("Coder Legacy", test.Franchise_Name); }
public void FullFranchiseTest() { dao.PushFranchise(420, "CyberRocker"); Franchises test = new Franchises(); test = dao.PullSpecificFranchise(420); Assert.AreEqual(true, dao.CheckFranchiseID(420)); Assert.AreEqual(420, test.Franchise_Id); Assert.AreEqual("CyberRocker", test.Franchise_Name); }
public async Task <IActionResult> Create([Bind("FranchiseNo,FranchiseName,FranchiseAddress,FranchisePostcode,FranchiseTel,FranchiseFax,FranchiseStartdate,FranchisorNo")] Franchises franchises) { if (ModelState.IsValid) { _context.Add(franchises); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["FranchisorNo"] = new SelectList(_context.Franchisors, "FranchisorNo", "FranchisorNo", franchises.FranchisorNo); return(View(franchises)); }
public void FranchiseAddToSQLTest() { IList <GameInfo> testList = new List <GameInfo>(); testList = mediator.GetGames("Halo", false); mediator.PushFranchiseIntoSQL(testList); Franchises test = new Franchises(); test = daoFranchises.PullSpecificFranchise(137); Assert.AreEqual(137, test.Franchise_Id); Assert.AreEqual("Halo", test.Franchise_Name); }
public void PushFranchiseIntoSQL(IList <GameInfo> games) { //Takes the results from IGDB query and inserts any missing franchises into SQL DB foreach (GameInfo x in games) { if (!franchiseSQLDAO.CheckFranchiseID(x.franchiseID)) { Franchises newFranchise = new Franchises(); newFranchise = franchisesIGDBDAO.PullSpecificFranchise(x.franchiseID); franchiseSQLDAO.PushFranchise(newFranchise.Franchise_Id, newFranchise.Franchise_Name); } } }
public Franchises PullSpecificFranchise(int franchiseID) { //Creates IGDB client using our apiKey var igdb = IGDB.Client.Create(Environment.GetEnvironmentVariable(apiKey)); igdb.ApiKey = apiKey; //Queries IGDB and pulls url based on franchise ID that we pull from our game search method var franchiseInfo = Task.Run(() => igdb.QueryAsync <Franchise>(IGDB.Client.Endpoints.Franchies, query: $"fields *;where id = {franchiseID};")).Result; Franchises newFranchise = new Franchises { Franchise_Id = franchiseID, Franchise_Name = franchiseInfo[0].Name }; return(newFranchise); }
public async Task <Tuple <bool, string, MultipleSecreateKeys> > GetUsernameWalletMasterCharges(string DcIDorName) { Tuple <bool, string, MultipleSecreateKeys> result = null; Franchises franchisesDetails = new Franchises(); Wallet walletDetails = new Wallet(); MasterCharges masterChargesDetails = new MasterCharges(); MultipleSecreateKeys lstMultipleSecreateKeys = new MultipleSecreateKeys(); try { using (SqlConnection con = new SqlConnection(_dcDb)) { var parameters = new DynamicParameters(); parameters.Add("@DcIDorName", DcIDorName); con.Open(); using (var multi = await con.QueryMultipleAsync("dbo.Select_FranchiseIDandName_RegKey", parameters, commandType: CommandType.StoredProcedure)) { franchisesDetails = multi.Read <Franchises>().Single(); walletDetails = multi.Read <Wallet>().Single(); masterChargesDetails = multi.Read <MasterCharges>().Single(); lstMultipleSecreateKeys.Franchise = franchisesDetails; lstMultipleSecreateKeys.Wallet = walletDetails; lstMultipleSecreateKeys.MasterCharges = masterChargesDetails; } con.Close(); } if (lstMultipleSecreateKeys != null) { result = Tuple.Create(true, "", lstMultipleSecreateKeys); } else { result = Tuple.Create(false, AppConstants.NO_RECORDS_FOUND, lstMultipleSecreateKeys); } } catch (Exception ex) { ErrorLog.Write(ex); result = Tuple.Create(false, ex.Message, lstMultipleSecreateKeys); } return(result); }
public void PushFranchisesTest() { Franchises test = new Franchises(); dao.PushFranchise(340, "A series of unfortunate calls"); using (SqlConnection connection = new SqlConnection(ConnectionString)) { connection.Open(); SqlCommand cmd = connection.CreateCommand(); cmd.CommandText = @"select * from Franchises where franchise_Id = 340"; cmd.ExecuteNonQuery(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { test.Franchise_Id = (int)reader["franchise_id"]; test.Franchise_Name = (string)reader["franchise_name"]; } } Assert.AreEqual(340, test.Franchise_Id); Assert.AreEqual("A series of unfortunate calls", test.Franchise_Name); }
public Franchises PullSpecificFranchise(int franchiseID) { //Pulls specific Franchise based on the id from the DB Franchises pulledFranchise = new Franchises(); using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand cmd = connection.CreateCommand(); cmd.CommandText = @"select franchise_id,franchise_name from Franchises where franchise_id = @franchiseId"; cmd.Parameters.AddWithValue("@franchiseId", franchiseID); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { pulledFranchise.Franchise_Id = (int)reader["franchise_id"]; pulledFranchise.Franchise_Name = (string)reader["franchise_name"]; } } return(pulledFranchise); }
public async Task <Tuple <bool, string, Franchises, Wallet> > GetFranchiseUsernameWalletByIDorName(string DcIDorName) { Tuple <bool, string, Franchises, Wallet> result = null; Franchises franchisesDetails = new Franchises(); Wallet walletDetails = new Wallet(); try { using (SqlConnection con = new SqlConnection(_dcDb)) { var parameters = new DynamicParameters(); parameters.Add("@DcIDorName", DcIDorName); con.Open(); using (var multi = await con.QueryMultipleAsync("dbo.Select_FranchiseIDandName_Wallet", parameters, commandType: CommandType.StoredProcedure)) { franchisesDetails = multi.Read <Franchises>().Single(); walletDetails = multi.Read <Wallet>().Single(); } con.Close(); } if (franchisesDetails != null) { result = Tuple.Create(true, "", franchisesDetails, walletDetails); } else { result = Tuple.Create(false, AppConstants.NO_RECORDS_FOUND, franchisesDetails, walletDetails); } } catch (Exception ex) { ErrorLog.Write(ex); result = Tuple.Create(false, ex.Message, franchisesDetails, walletDetails); } return(result); }
public static void Reset() { Types.Clear(); Franchises.Clear(); Wallpapers.Clear(); }