public List <CardsModel> GetAllCards() { List <CardsModel> ecards = new List <CardsModel>(); try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(SQL_GetAllCards, conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { CardsModel c = new CardsModel(); c.CardId = Convert.ToInt32(reader["Id"]); c.CardName = Convert.ToString(reader["name"]); c.ImageName = Convert.ToString(reader["imageName"]); c.FontColor = Convert.ToString(reader["fontColor"]); ecards.Add(c); } } } catch (SqlException ex) { throw; } return(ecards); }
public CardsModel GetATemplate(int id) { CardsModel card = new CardsModel(); try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(SQL_GetATemplate, conn); cmd.Parameters.AddWithValue("@input", id); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { CardsModel c = new CardsModel(); c.CardName = Convert.ToString(reader["name"]); c.ImageName = Convert.ToString(reader["imageName"]); c.FontColor = Convert.ToString(reader["fontColor"]); c.TemplateId = id; card = c; } } } catch (SqlException ex) { throw; } return(card); }
public ActionResult AddCard(CardsModel model) { if (ModelState.IsValid) { if (client == null) { client = new BankSystemServiceClient(); } MembershipCreateStatus createStatus = client.AddCard(User.Identity.GetUserId(), model.Nazwa, model.Nr_karta); if (createStatus == MembershipCreateStatus.Success) { return(RedirectToAction("Card", "Cards")); } else { ModelState.AddModelError("", createStatus.ToString()); } } else { ModelState.AddModelError("", "Pola nie moga byc puste"); } return(View()); }
public void Add(CardsModel model) { var sql = "INSERT INTO CARDS (Name, ManaCost, Attack, Health, Rarity, SetName) VALUES (@Name, @ManaCost, @Attack, @Health, @Rarity, @SetName)"; db.Query <CardsModel>(sql, model); }
public void Update(int id, CardsModel model) { var sql = "UPDATE CARDS SET Name = @Name, ManaCost = @ManaCost, Attack = @Attack, Health = @Health, Rarity = @Rarity, SetName = @SetName WHERE id = @id"; db.Query <CardsModel>(sql, model); }
public IHttpActionResult PostCards(string externalId, [FromBody] CardsModel model) { try { UsersDataObject userDO = dataAccess.GetUserByExternalID(externalId); if (userDO == null) { return(NotFound()); } CardDataObject c = modelFactory.Parse(model); dataAccess.InsertUserCard(c.ExternalId, c.BadgeNumber, c.IsActive, c.PIN, userDO.Id); userDO = dataAccess.GetUserByExternalID(externalId); CardDataObject cardDO = userDO.Cards.Where(x => x.ExternalId == model.ExternalId).FirstOrDefault(); if (cardDO == null) { return(NotFound()); } return(CreatedAtRoute <CardsModel>("Cards", new { externalId = externalId, cardExternalId = cardDO.ExternalId }, modelFactory.Create(externalId, cardDO))); } catch (Exception ex) { return(InternalServerError(ex)); } }
public void SaveNewCard(CardsModel c) { try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(SQL_SaveCard, conn); cmd.Parameters.AddWithValue("@template_id", c.TemplateId); cmd.Parameters.AddWithValue("@to_email", c.ToEmail); cmd.Parameters.AddWithValue("@to_name", c.ToName); cmd.Parameters.AddWithValue("@message", c.Message); cmd.Parameters.AddWithValue("@from_name", c.FromName); cmd.Parameters.AddWithValue("@from_email", c.FromEmail); cmd.ExecuteNonQuery(); return; } } catch (SqlException ex) { throw; } }
public List <CardsModel> GetAllCards(CardsModel c) { var cardslist = cardData.GetAllCards(c); List <CardsModel> listcards = new List <CardsModel>(); listcards = getAllCardsProperties(cardslist); return(listcards); }
public ActionResult ViewCard(CardsModel c) { CardsModel template = dal.GetATemplate(c.TemplateId); c.ImageName = template.ImageName; return(View("ViewCard", c)); }
public ActionResult Cards(int CardId) { var data = cardBussiness.gettechcardtype(); Session["TechCardType"] = data; CardsModel card = cardBussiness.getCardById(CardId); return(View(card)); }
public void RandomizeNextCard() { CardsModel cardsModel = GetModel <CardsModel>(); if (cardsModel.InHandCards.Count > 0) { cardsModel.RandomizeNextCard(); } }
public ActionResult ViewCards(CardsModel c) { var data1 = cardBussiness.gettechcardtype(); Session["TechCardType"] = data1; List <CardsModel> data = cardBussiness.GetAllCards(c); ViewBag.cardsDetails = data; return(View()); }
public ActionResult CreateCard(CardsModel c, int id) { c.List = ListDataMapper.GetListDataMapper().GetById(id); if (!AccountDataMapper.GetAccountDataMapper().GetById(User.Identity.Name).CanWriteBoard(c.List.Board.Id)) { return(RedirectToAction("Index", "Boards")); } CardDataMapper.GetCardDataMapper().Add(c); return(Redirect(String.Format("~/Lists/GetCards/{0}", id))); }
public int InsertOrUpdateCards(CardsModel cardmodel) { try { return(cardData.InsertOrUpdateCards(cardmodel)); } catch (Exception e) { throw e; } }
public ActionResult InsertOrUpdateCards(CardsModel product) { try { int result = cardBussiness.InsertOrUpdateCards(product); } catch (Exception e) { throw e; } return(RedirectToAction("ViewCards", "Cards")); }
public void Initialize(ModelRepository modelRepository, CardViewProcessor cardViewProcessor) { _modelRepository = modelRepository; _cardViewProcessor = cardViewProcessor; CardsModel cardsModel = GetModel <CardsModel>(); cardsModel.CardsCreated += CreateCards; cardsModel.CardRemovedFromHand += RemoveCard; cardsModel.CardDestroyed += DestroyCard; cardsModel.CardUpdated += UpdateCard; }
public CardsModel CardsToRow(IDataReader reader) { CardsModel model = new CardsModel(); model.Id = reader["Id"] != DBNull.Value ? Convert.ToInt32(reader["Id"]) : 0; model.UserId = reader["UserId"] != DBNull.Value ? reader["UserId"].ToString() : string.Empty; model.Name = reader["Name"] != DBNull.Value ? reader["Name"].ToString() : string.Empty; model.Number = reader["Number"] != DBNull.Value ? reader["Number"].ToString() : string.Empty; model.Description = reader["Description"] != DBNull.Value ? reader["Description"].ToString() : string.Empty; model.Balans = reader["Balans"] != DBNull.Value ? Convert.ToDouble(reader["Balans"]) : 0; return(model); }
public ActionResult EditCard(int id) { if (Session["CurrentCard"] != null) { CardsModel c = Session["CurrentCard"] as CardsModel; CardsModel template = dal.GetATemplate(c.TemplateId); c.ImageName = template.ImageName; return(View("CreateCard", c)); } return(RedirectToAction("Index", "Home")); }
public ActionResult Edit(CardsModel cardsModel) { var card = CardDataMapper.GetCardDataMapper().GetById(cardsModel.Id); if (!AccountDataMapper.GetAccountDataMapper().GetById(User.Identity.Name).CanWriteBoard(card.List.Board.Id)) { return(RedirectToAction("Index", "Boards")); } card.Name = cardsModel.Name; if (card.List != null) { return(RedirectToAction("GetCards", "Lists", new { id = card.List.Id })); } return(RedirectToAction("GetCard", new { card.Id })); }
public IActionResult Index(List <int> data) { Cards = CardsModel.AddCard(Cards, data); ScoreModel Results = ScoreModel.CalculateScore(Cards.Cards); if (Results.Valid) { return(View("Results", Results)); } else { return(View("Invalid", Results)); } }
public ActionResult Archive(CardsModel cardsModel) { var card = CardDataMapper.GetCardDataMapper().GetById(cardsModel.Id); if (!AccountDataMapper.GetAccountDataMapper().GetById(User.Identity.Name).CanWriteBoard(card.List.Board.Id)) { return(RedirectToAction("Index", "Boards")); } var listId = card.List.Id; int cardIdx = card.Idx; RefreshIdx(CardDataMapper.GetCardDataMapper().GetAllByList(card.List), cardIdx); card.List = null; return(RedirectToAction("GetCards", "Lists", new { id = listId })); }
public ActionResult CreateCard(CardsModel c) { if (!ModelState.IsValid) { Session["CurrentCard"] = c; CardsModel template = dal.GetATemplate(c.TemplateId); c.ImageName = template.ImageName; return(View("CreateCard", c)); } else { Session["CurrentCard"] = c; return(RedirectToAction("ViewCard", c)); } }
public void Insert(CardsModel model) { string commandText = @" Insert into dbo.Cards (UserId, Name, Number, Description, Balans) values (@UserId, @Name, @Number, @Description, @Balans) "; var parameters = new Dictionary <string, object>() { { "@UserId", model.UserId }, { "@Profit", model.Name }, { "@Amount", model.Number }, { "@Description", model.Description }, { "@CardId", model.Balans } }; DbHelper.ExecuteNonQuery(connectionString, commandText, parameters); }
public DataTable GetAllCards(CardsModel cardmodel) { try { SqlParameter[] sqlParameters = new SqlParameter[6]; sqlParameters[0] = new SqlParameter("@TechnicianCard", cardmodel.TechnicianCard); sqlParameters[1] = new SqlParameter("@CardNumber", cardmodel.CardNumber); sqlParameters[2] = new SqlParameter("@Custemer", string.IsNullOrEmpty(cardmodel.Customer) ? "" : cardmodel.Customer); sqlParameters[3] = new SqlParameter("@VIPCustomer", cardmodel.VIPCustomer); sqlParameters[4] = new SqlParameter("@IssueDate", cardmodel.IssueDate); sqlParameters[5] = new SqlParameter("@ToDate", cardmodel.ToDate); return(conn.executeSelectQuery("sp_GetAllCards", sqlParameters)); } catch (Exception e) { throw e; } }
public List <CardsModel> RelateCards(List <CardsModel> allCards, CardsModel card) { var related = new List <CardsModel>(); foreach (var cardJ in allCards) { var nameWords = cardJ.Name.Split(' '); foreach (var word in nameWords) { if (card.IdName != cardJ.IdName && card.Description != null && card.Description.ToLower().Contains(word.ToLower())) { related.Add(cardJ); break; } } } return(related); }
public ActionResult MoveCardInList(CardsModel cardsModel) { var card = CardDataMapper.GetCardDataMapper().GetById(cardsModel.Id); int oldIdx = card.Idx; int newIdx = cardsModel.Idx; IEnumerable <CardsModel> cardsEnum = CardDataMapper.GetCardDataMapper().GetAllByList(card.List); int nCards = cardsEnum.Count(); if (!AccountDataMapper.GetAccountDataMapper().GetById(User.Identity.Name).CanWriteBoard(card.List.Board.Id)) { return(RedirectToAction("Index", "Boards")); } if (nCards < newIdx) { newIdx = nCards; } if (oldIdx < newIdx) { foreach (var c in cardsEnum) { if (c.Idx > oldIdx && c.Idx <= newIdx) { --c.Idx; } } } else if (newIdx < oldIdx) { foreach (var c in cardsEnum) { if (c.Idx < oldIdx && c.Idx >= newIdx) { ++c.Idx; } } } card.Idx = newIdx; return(RedirectToAction("GetCards", "Lists", new { id = card.List.Id })); }
public ActionResult SaveCard() { CardsModel c = Session["CurrentCard"] as CardsModel; dal.SaveNewCard(c); CardsModel template = dal.GetATemplate(c.TemplateId); ImageGenerator imageGenerator = new ImageGenerator(); var templateFilepath = Server.MapPath($"~/Content/img/{template.ImageName}"); var finalFilePath = Server.MapPath($"~/Content/img/{Guid.NewGuid().ToString()}.jpg"); imageGenerator.SaveCardToDisk(templateFilepath, finalFilePath, c.Message); deliveryService.Send(c.ToEmail, finalFilePath); Session["CurrentCard"] = null; return(RedirectToAction("ThankYou")); }
public void GetNextView() { if (SelectedCard != null) { Console.WriteLine("Trying to load next detail page"); Console.WriteLine(SelectedCard.IdName); var newState = new StateModel { AlreadySeen = new List <string>(State.AlreadySeen), Card = SelectedCard, }; newState.AlreadySeen.Add(SelectedCard.IdName); var detailPage = new ClashCardsDetailViewPage() { BindingContext = new ClashCardsDetailViewModel(newState) }; SelectedCard = null; Application.Current.MainPage.Navigation.PushAsync(detailPage); } }
public int InsertOrUpdateCards(CardsModel cardmodel) { try { SqlParameter[] sqlParameters = new SqlParameter[25]; sqlParameters[0] = new SqlParameter("@CardId", cardmodel.CardId); sqlParameters[1] = new SqlParameter("@CardNumber", cardmodel.CardNumber); sqlParameters[2] = new SqlParameter("@Custemer", cardmodel.Customer); sqlParameters[3] = new SqlParameter("@FaceValue", cardmodel.FaceValue); sqlParameters[4] = new SqlParameter("@IssueDate", cardmodel.IssueDateP); sqlParameters[5] = new SqlParameter("@LastPlayTime", cardmodel.LastPlayTime); sqlParameters[6] = new SqlParameter("@LastUpdatedBy", cardmodel.LastUpdatedBy); sqlParameters[7] = new SqlParameter("@LastUpdatedTime", DateTime.Now); sqlParameters[8] = new SqlParameter("@Note", cardmodel.Note); sqlParameters[9] = new SqlParameter("@RealTicketMode", cardmodel.RealTicketMode); sqlParameters[10] = new SqlParameter("@RefundDate", cardmodel.RefundDate); sqlParameters[11] = new SqlParameter("@StartTime", cardmodel.StartTime); sqlParameters[12] = new SqlParameter("@TechGames", cardmodel.TechGames); sqlParameters[13] = new SqlParameter("@TicketAllowed", cardmodel.TicketAllowed); sqlParameters[14] = new SqlParameter("@TicketCount", cardmodel.TicketCount); sqlParameters[15] = new SqlParameter("@TimerResetCard", cardmodel.TimerResetCard); sqlParameters[16] = new SqlParameter("@VIPCustomer", cardmodel.VIPCustomer); sqlParameters[17] = new SqlParameter("@TechCardType", cardmodel.TechCardType); sqlParameters[18] = new SqlParameter("@RefundAmount", cardmodel.RefundAmount); sqlParameters[19] = new SqlParameter("@Credits", cardmodel.Credits); sqlParameters[20] = new SqlParameter("@CreditPlus", cardmodel.CreditPlus); sqlParameters[21] = new SqlParameter("@Courtesy", cardmodel.Courtesy); sqlParameters[22] = new SqlParameter("@CreditsPlayed", cardmodel.CreditsPlayed); sqlParameters[23] = new SqlParameter("@Bonus", cardmodel.Bonus); sqlParameters[24] = new SqlParameter("@ExpiryDate", cardmodel.ExpiryDate); return(conn.executeInsertQuery("sp_InsertOrUpdateCards", sqlParameters)); } catch (Exception e) { throw e; } }
public List <CardsModel> getAllCardsProperties(DataTable cardslist) { List <CardsModel> listcards = new List <CardsModel>(); foreach (DataRow dr in cardslist.Rows) { CardsModel pType = new CardsModel(); pType.CardId = dr.IsNull("CardId") ? 0 : int.Parse(dr["CardId"].ToString()); pType.CardNumber = dr.IsNull("CardNumber") ? "" : (dr["CardNumber"].ToString()); pType.Customer = dr.IsNull("Customer") ? "" : dr["Customer"].ToString(); pType.ExpiryDate = dr.IsNull("ExpiryDate") ? new DateTime() : Convert.ToDateTime(dr["ExpiryDate"].ToString()); pType.LastUpdatedBy = dr.IsNull("LastUpdatedBy") ? "" : dr["LastUpdatedBy"].ToString(); pType.LastUpdatedTime = dr.IsNull("LastUpdatedTime") ? new DateTime() : Convert.ToDateTime(dr["LastUpdatedTime"]); pType.FaceValue = dr.IsNull("FaceValue") ? 0 : float.Parse(dr["FaceValue"].ToString()); pType.IssueDateP = dr.IsNull("IssueDate") ? new DateTime() : Convert.ToDateTime(dr["IssueDate"].ToString()); pType.LastPlayTime = dr.IsNull("LastTimePlayed") ? new DateTime() : Convert.ToDateTime(dr["LastTimePlayed"].ToString()); pType.Note = dr.IsNull("Note") ? "" : dr["Note"].ToString(); pType.RefundAmount = dr.IsNull("RefundAmount") ? 0 : float.Parse(dr["RefundAmount"].ToString()); pType.RefundDate = dr.IsNull("RefundDate") ? new DateTime() : Convert.ToDateTime(dr["RefundDate"].ToString()); pType.StartTime = dr.IsNull("StartDateTtime") ? new DateTime() : Convert.ToDateTime(dr["StartDateTtime"].ToString()); pType.TechGames = dr.IsNull("TechGames") ? "" : dr["TechGames"].ToString(); pType.TimerResetCard = dr.IsNull("TimerResetCard") ? false : bool.Parse(dr["TimerResetCard"].ToString()); pType.VIPCustomer = dr.IsNull("VIPCustomer") ? false : bool.Parse(dr["VIPCustomer"].ToString()); pType.TechCardType = dr.IsNull("TechnicianCard") ? 0 : int.Parse(dr["TechnicianCard"].ToString()); pType.Credits = dr.IsNull("Credits") ? 0 : float.Parse(dr["Credits"].ToString()); pType.CreditPlus = dr.IsNull("CreditPlus") ? 0 : float.Parse(dr["CreditPlus"].ToString()); pType.CreditsPlayed = dr.IsNull("CreditsPlayed") ? 0 : float.Parse(dr["CreditsPlayed"].ToString()); pType.Courtesy = dr.IsNull("Courtesy") ? 0 : float.Parse(dr["Courtesy"].ToString()); pType.Bonus = dr.IsNull("Bonus") ? 0 : float.Parse(dr["Bonus"].ToString()); pType.RealTicketMode = dr.IsNull("RealTicketMode") ? false : bool.Parse(dr["RealTicketMode"].ToString()); pType.TicketCount = dr.IsNull("TicketCount") ? 0 : int.Parse(dr["TicketCount"].ToString()); pType.TicketAllowed = dr.IsNull("TicketAllowed") ? false : bool.Parse(dr["TicketAllowed"].ToString()); listcards.Add(pType); } return(listcards); }
public void Update(CardsModel model) { ListID = model.ListID; Text = model.Text; }
public Card(CardsModel model) { this.Update(model); CreatedDate = DateTime.Now; }
public void Update(CardsModel model) { Text = model.Text; ListId = model.ListId; }