public cardModel ReadCardData(int id)
{
cardModel card = new cardModel();
DataTable dtblCard = new DataTable();
using (SqlConnection sqlConn = new SqlConnection(Sql.ConnectionString))
{
SqlCommand cmd = new SqlCommand("spCard", sqlConn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StatementType", "select");
cmd.Parameters.AddWithValue("@prodID", id);
sqlConn.Open();
SqlDataReader sqlread = cmd.ExecuteReader();
dtblCard.Load(sqlread);
sqlConn.Close();
}
if (dtblCard.Rows.Count == 1)
{
card.CardId = Convert.ToInt32(dtblCard.Rows[0][0].ToString());
card.CardImage = dtblCard.Rows[0][1].ToString();
card.ShortDescription = dtblCard.Rows[0][2].ToString();
card.ShortText = dtblCard.Rows[0][3].ToString();
card.ProductID = Convert.ToInt32(dtblCard.Rows[0][4].ToString());
}
return(card);
}
public CardController(ICardServices servicesCard, ICreateCard createCard, IReadCard cardRead, IEditCard editCard, IDeleteCard deleteCard, cardModel cardModel)
{
this.CardService = servicesCard;
this.CardCreate = createCard;
this.readCard = cardRead;
this.cardEdit = editCard;
this.cardDelete = deleteCard;
this.ModelCardc = cardModel;
}
public ActionResult Edit(cardModel card)
{
if (ModelState.IsValid)
{
SqlDataReader sqlread = cardEdit.EditCardData(card);
return(RedirectToAction("Index", "Home"));
}
else
{
return(View(card));
}
}
// GET: Card/Edit/5
public ActionResult Edit(int id)
{
if (ModelState.IsValid)
{
ModelCardc = readCard.ReadCardData(id);
return(View(ModelCardc));
}
else
{
return(View(ModelCardc));
}
}
public ActionResult Create(cardModel card)
{
if (ModelState.IsValid)
{
SqlDataReader sqlread = CardCreate.GenerateCard(card);
return(RedirectToAction("Index", "Home"));
}
else
{
return(View(card));
}
}
public SqlDataReader DeleteCardData(cardModel card, int id)
{
DataTable dtblcard = new DataTable();
using (SqlConnection sqlConn = new SqlConnection(Sql.ConnectionString))
{
SqlCommand cmd = new SqlCommand("spCard", sqlConn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StatementType", "Delete");
cmd.Parameters.AddWithValue("@prodID", id);
sqlConn.Open();
SqlDataReader sqlread = cmd.ExecuteReader();
sqlConn.Close();
return(sqlread);
}
}
public SqlDataReader GenerateCard(cardModel card)
{
using (SqlConnection sqlCon = new SqlConnection(Sql.ConnectionString))
{
SqlCommand sqlCmd = new SqlCommand("spCard", sqlCon);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@cardImg", card.CardImage);
sqlCmd.Parameters.AddWithValue("@cardTitle", card.ShortDescription);
sqlCmd.Parameters.AddWithValue("@cardText", card.ShortText);
sqlCmd.Parameters.AddWithValue("@prodID", card.ProductID);
sqlCmd.Parameters.AddWithValue("@StatementType", "Insert");
sqlCon.Open();
SqlDataReader sqlread = sqlCmd.ExecuteReader();
sqlCon.Close();
return(sqlread);
}
}
// GET: Card/Delete/5
public ActionResult Delete(int id)
{
ModelCardc = readCard.ReadCardData(id);
return(View(ModelCardc));
}
public ActionResult Delete(int id, cardModel card)
{
SqlDataReader sqlRead = cardDelete.DeleteCardData(card, id);
return(RedirectToAction("Index", "Home"));
}
// Use this for initialization
void Awake () {
cardModel = card.GetComponent<cardModel>();
flipper = card.GetComponent<cardFlipper> ();
}
public float duration = 0.5f; // flip duration
void Awake() {
spriteRenderer = GetComponent<SpriteRenderer> ();
cModel = GetComponent<cardModel> ();
//chModel = GetComponent<charModel> ();
}
