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