public ActionResult Apply(int?id)
{
application app = new application();
if (id != null)
{
cards card = _entities.cards.Find(id);;
List <COUNT> counttList = _entities.COUNT.Where(c => c.ITEM_TYPE_ID == card.ITEM_TYPE_ID).ToList();
Dictionary <int, String> countDic = new Dictionary <int, string>();
foreach (var i in counttList)
{
string param = i.COUNT_VALUE + " " + i.PRICE + "руб/шт";
countDic.Add(i.Id, param);
}
ViewBag.count_id = new SelectList(_entities.COUNT, "Id", "COUNT_VALUE");
//ViewBag.material_id = new SelectList(_entities.materials, "Id", "description");
ViewBag.towns = new SelectList(_entities.Towns, "Id", "Name");
app.vc_id = card.Id;
app.cards = card;
return(View(app));
}
else
{
return(View("error Apply get"));
}
}
// PUT: api/Payment/5
public void Put(int id, [FromBody] cards value)
{
cards cart = new cards();
crypting c = new crypting();
cart.updatePayment(ref mensaje_error, ref numero_error, value.Num_Tarjeta, c.encrypt(value.Mes_Exp), c.encrypt(value.Ano_Exp), c.encrypt(value.CVV), value.Monto, c.encrypt(value.Tipo), c.encrypt(value.Card_Type));
}
public ActionResult SaveTo(cards model)
{
if (ModelState.IsValid)
{
cards card = new cards();
card.IMAGES.Image = model.IMAGES.Image;
card.IMAGES.Image_2 = model.IMAGES.Image_2;
card.ITEM_TYPE_ID = model.ITEM_TYPE_ID;
card.layout_id = model.layout_id;
card.published = false;
card.text = model.text;
card.preview = model.preview;
card.preview_2 = model.preview_2;
string userName = User.Identity.Name;
var store = new UserStore <ApplicationUser>(new ApplicationDbContext());
var userManager = new UserManager <ApplicationUser>(store);
ApplicationUser user = userManager.FindByNameAsync(userName).Result;
string userId = user.Id;
//model.layout = _entities.layout.Find(model.layout_id);
card.USER_ID = userId;
//card.published = false;
//applicationDAO.AddNewCard(card);
db.cards.Add(card);
db.SaveChanges();
}
return(RedirectToAction("UserCardsList"));
}
// POST: api/Payment
public void Post([FromBody] cards value)
{
cards cart = new cards();
crypting c = new crypting();
cart.add_card(ref mensaje_error, ref numero_error, value.Num_Tarjeta, c.encrypt(value.Mes_Exp), c.encrypt(value.Ano_Exp), c.encrypt(value.CVV), value.Monto, c.encrypt(value.Tipo), c.encrypt(value.Card_Type));
}
/// <summary>
/// 获取一张未领取的新手卡
/// </summary>
/// <param name="CardId">卡Id</param>
/// <returns>返回新手卡</returns>
public cards GetCards(int CardId)
{
cards c = new cards();
try
{
string sql = "select top 1 * from cards where state =0 and cardnameid=@CardId";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@CardId", CardId)
};
using (SqlDataReader reder = db.GetReader(sql, sp))
{
while (reder.Read())
{
c.id = (int)reder["id"];
c.cardnum = reder["cardnum"].ToString();
c.cardnameid = (int)reder["cardnameid"];
c.state = (int)reder["state"];
c.addtime = (DateTime)reder["addtime"];
}
}
}
catch (SqlException ex)
{
throw new Exception("数据库异常！原因：" + ex.Message);
}
catch (Exception ex)
{
throw new Exception("未知异常！原因：" + ex.Message);
}
return(c);
}
// GET: cards/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
cards cards = await db.cards.FindAsync(id);
if (cards == null)
{
return(HttpNotFound());
}
ViewBag.COLOR_CLAIM = new SelectList(applicationDAO.getColorClaims(), "Id", "ClaimValue");
ViewBag.STYLE_CLAIM = new SelectList(applicationDAO.getStyleClaims(), "Id", "ClaimValue");
ViewBag.GROUP_CLAIM = new SelectList(applicationDAO.getGroupClaims(), "Id", "ClaimValue");
Dictionary <int, string> layoutO = new Dictionary <int, string>();
var layouts = applicationDAO.getAllLayout();
foreach (var item in layouts)
{
string param = item.height + " " + item.width;
layoutO.Add(item.Id, param);
}
ViewBag.layout_id = new SelectList(layoutO, "Key", "Value");
ViewBag.USER_ID = new SelectList(db.AspNetUsers, "Id", "UserName", cards.USER_ID);
ViewBag.ITEM_TYPE_ID = new SelectList(db.ITEM_TYPE, "Id", "NAME", cards.ITEM_TYPE_ID);
return(View(cards));
}
public void TestNumberComputerCard()
{
// Arrange.
const int numbersCard = 17;
cards card = new cards();
// Test.
bool valueIncorrect = false;
int computerCard = card.getCard();
int totalComputerScoreCard = card.totalComputerScoreSave(computerCard);
int totalListComputerCard = card.totalListComputerCard();
if (totalListComputerCard <= numbersCard)
{
valueIncorrect = false;
}
else
{
valueIncorrect = true;
}
// Assert or Affirmation.
Assert.IsFalse(valueIncorrect);
}
public bool AddNewCard(cards cards)
{
try
{
_entities.cards.Add(cards);
_entities.SaveChanges();
return(true);
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
public ActionResult SetCanvas(cards model)
{
if (ModelState.IsValid)
{
cards cd = new cards();
cd.IMAGES = new IMAGES();
cd.IMAGES.Image = writeFile(model.IMAGES.Image);
cd.IMAGES.Image_2 = writeFile(model.IMAGES.Image_2);
cd.ITEM_TYPE_ID = model.ITEM_TYPE_ID;
cd.layout_id = model.layout_id;
cd.preview_2 = model.preview_2;
cd.preview = model.preview;
cd.text = model.text;
cd.published = false;
string userName = User.Identity.Name;
var store = new UserStore <ApplicationUser>(new ApplicationDbContext());
var userManager = new UserManager <ApplicationUser>(store);
ApplicationUser user = userManager.FindByNameAsync(userName).Result;
string userId = user.Id;
//model.layout = _entities.layout.Find(model.layout_id);
cd.USER_ID = userId;
_entities.cards.Add(cd);
_entities.SaveChanges();
return(RedirectToAction("Apply", new { id = cd.Id }));
}
return(View("error"));
}
void Start()
{
scriptref = this.gameObject.GetComponent <BulletShooting>();
scriptref2 = this.gameObject.GetComponent <bullettypes>();
scriptref2.enabled = false;
cardSref = FindObjectOfType <cards>();
cardrep1 = FindObjectOfType <cards1>();
cardrep2 = FindObjectOfType <cards2>();
}
public ActionResult SetCanvas(int?id)
{
try {
if (id != null)
{
cards card = _entities.cards.Find(id);
string itemType = card.ITEM_TYPE.NAME;
if (card != null)
{
card.IMAGES.Image = readFile(card.IMAGES.Image);
card.IMAGES.Image_2 = readFile(card.IMAGES.Image_2);
Dictionary <int, string> layoutO = new Dictionary <int, string>();
var layouts = _entities.layout.Where(c => c.ITEM_TYPE.NAME == itemType);
foreach (var item in layouts)
{
string param = item.width + " " + item.height;
layoutO.Add(item.Id, param);
}
ViewBag.layout_id = new SelectList(layoutO, "Key", "Value");
ViewBag.backgrounds = new List <elements>(_entities.elements.Where(c => c.type_name_id == 1).ToList());
ViewBag.info = new List <elements>(_entities.elements.Where(c => c.type_name_id == 2).ToList());
return(View(card));
}
else
{
throw new NullReferenceException("cards is null");
}
}
else
{
return(RedirectToAction("ItemTypes"));
}
}
catch (NullReferenceException e)
{
Console.WriteLine(e.Message.ToString());
Console.WriteLine(e.TargetSite.ToString());
Console.WriteLine(e.StackTrace);
return(View("Error"));
}
catch (ArgumentException e)
{
Console.WriteLine(e.Message.ToString());
Console.WriteLine(e.TargetSite.ToString());
Console.WriteLine(e.StackTrace);
return(RedirectToAction("ItemTypes"));
}
catch (Exception e)
{
Console.WriteLine(e.Message.ToString());
Console.WriteLine(e.TargetSite.ToString());
Console.WriteLine(e.StackTrace);
return(View("Error"));
}
}
public ActionResult EditLayout(int id)
{
cards card = new cards();
IEnumerable <cards> cardQuery = applicationDAO.getCardById(id);
foreach (var i in cardQuery)
{
card.IMAGES.Image = i.IMAGES.Image;
}
ViewBag.EditLayoutId = id;
ViewBag.EditLayout = card.IMAGES.Image;
return(View("EditLayout"));
}
// GET: cards/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
cards cards = await db.cards.FindAsync(id);
if (cards == null)
{
return(HttpNotFound());
}
return(View(cards));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,layout_id,text,image,USER_ID,published,ITEM_TYPE_ID")] cards cards)
{
if (ModelState.IsValid)
{
db.Entry(cards).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.USER_ID = new SelectList(db.AspNetUsers, "Id", "UserName", cards.USER_ID);
ViewBag.layout_id = new SelectList(db.layout, "Id", "width", cards.layout_id);
ViewBag.ITEM_TYPE_ID = new SelectList(db.ITEM_TYPE, "Id", "NAME", cards.ITEM_TYPE_ID);
return(View(cards));
}
// GET: api/Payment/5
public cards Get(int id)
{
List <cards> item_carlist = new cards().cargar_tarjeta(ref mensaje_error, ref numero_error);
crypting c = new crypting();
cards x = item_carlist.ElementAt(id);
cards spes = new cards();
spes.Num_Tarjeta = x.Num_Tarjeta;
spes.Mes_Exp = c.decrypt(x.Mes_Exp);
spes.Ano_Exp = c.decrypt(x.Ano_Exp);
spes.CVV = c.decrypt(x.CVV);
spes.Monto = x.Monto;
spes.Tipo = c.decrypt(x.Tipo);
spes.Card_Type = c.decrypt(x.Card_Type);
return(spes);
}
public void TestThrowException_NumberComputerCard()
{
cards card = new cards();
try
{
int totalComputerScoreCard = card.totalComputerScoreSave(0);
int totalListComputerCard = card.totalListComputerCard();
Assert.Fail("no exception thrown");
}
catch (Exception ex)
{
Assert.IsTrue(true, ex.Message);
}
}
public string UpdateImage(string token)
{
token = TokenManager.readToken(HttpContext.Current.Request);
string message = "";
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
string cardObject = "";
cards cardObj = null;
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "itemObject")
{
cardObject = c.Value.Replace("\\", string.Empty);
cardObject = cardObject.Trim('"');
cardObj = JsonConvert.DeserializeObject <cards>(cardObject, new IsoDateTimeConverter {
DateTimeFormat = "dd/MM/yyyy"
});
break;
}
}
try
{
cards card;
using (incposdbEntities entity = new incposdbEntities())
{
var userEntity = entity.Set <cards>();
card = entity.cards.Where(p => p.cardId == cardObj.cardId).First();
card.image = cardObj.image;
entity.SaveChanges();
}
message = card.cardId.ToString();
return(TokenManager.GenerateToken(message));
}
catch
{
message = "0";
return(TokenManager.GenerateToken(message));
}
}
}
// GET: cards/Create
public ActionResult Create(String type_id)
{
var types = db.ITEM_TYPE.Where(c => c.NAME == type_id).ToList();
ITEM_TYPE item_type = new ITEM_TYPE();
foreach (var i in types)
{
item_type = i;
}
var addCards = new addCardModel();
var exSearch = new Models.addCards.ExtandedSearchModel();
var availItems = new List <checkBoxListModel>();
var selectedItems = new List <checkBoxListModel>();
cards card = new cards();
card.ITEM_TYPE_ID = item_type.Id;
addCards.cards = card;
addCards.ITEM_TYPE_ID = item_type.Id;
var claims = applicationDAO.getAllCardClaims();
int count = 0;
foreach (var item in claims)
{
if (item.ClaimType != "TYPE")
{
availItems.Add(new checkBoxListModel(item.ClaimValue, item.ClaimValue));
}
count++;
}
addCards.availItems = availItems;
//ViewBag.COLOR_CLAIM = new SelectList(applicationDAO.getColorClaims(), "Id", "ClaimValue");
//ViewBag.STYLE_CLAIM = new SelectList(applicationDAO.getStyleClaims(), "Id", "ClaimValue");
//ViewBag.GROUP_CLAIM = new SelectList(applicationDAO.getGroupClaims(), "Id", "ClaimValue");
Dictionary <int, string> layoutO = new Dictionary <int, string>();
var layouts = db.layout.Where(c => c.ITEM_TYPE_ID == item_type.Id);
foreach (var item in layouts)
{
string param = item.width + " " + item.height;
layoutO.Add(item.Id, param);
}
ViewBag.layout_id = new SelectList(layoutO, "Key", "Value");
//ViewBag.layout_id = new SelectList(db.layout.Where(c => c.ITEM_TYPE_ID == item_type.Id).ToList(), "Id", "name");
return(View(addCards));
}
public void TestTotalNumberComputerCard()
{
// Arrange
int totalScoreResul = 16;
cards card = new cards();
// Test
List <int> computerCardList = new List <int>();
computerCardList.Add(1);
computerCardList.Add(2);
computerCardList.Add(3);
computerCardList.Add(4);
computerCardList.Add(5);
computerCardList.Add(6);
computerCardList.Add(7);
computerCardList.Add(8);
computerCardList.Add(9);
computerCardList.Add(1);
computerCardList.Add(2);
computerCardList.Add(3);
computerCardList.Add(4);
computerCardList.Add(5);
computerCardList.Add(6);
computerCardList.Add(7);
//computerCardList.Add(7); //--> Error
int totalComputerScoreCard = 0;
foreach (int element in computerCardList)
{
totalComputerScoreCard = card.totalComputerScoreSave(element);
}
int totalNumberComputerCard = card.totalListComputerCard();
if (totalNumberComputerCard <= totalScoreResul)
{
totalScoreResul = totalNumberComputerCard;
}
// Assert or Affirmation.
Assert.AreEqual(totalScoreResul, totalNumberComputerCard, "Card numbers less than 17.");
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
cards cards = await db.cards.FindAsync(id);
List <CARD_CLAIMS> claimsList = new List <CARD_CLAIMS>();
var claims = db.CARD_CLAIMS.Where(c => c.Card_id == cards.Id);
claimsList = claims.ToList();
foreach (var i in claimsList)
{
db.CARD_CLAIMS.Remove(i);
await db.SaveChangesAsync();
}
db.cards.Remove(cards);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public BaseTran <cards> GetDeviceList()
{
BaseTran <cards> send = new BaseTran <cards>();
List <cards> lst = new List <cards>();
foreach (var item in dict)
{
cards data = new cards();
data = item.Value.Clone();
lst.Add(data);
}
send.total = lst.Count;
send.msg = "ok";
send.data = lst;
return(send);
}
public ActionResult SaveTo(cards model)
{
if (ModelState.IsValid)
{
cards card = model;
string userName = User.Identity.Name;
var store = new UserStore <ApplicationUser>(new ApplicationDbContext());
var userManager = new UserManager <ApplicationUser>(store);
ApplicationUser user = userManager.FindByNameAsync(userName).Result;
string userId = user.Id;
//model.layout = _entities.layout.Find(model.layout_id);
card.USER_ID = userId;
//card.published = false;
//applicationDAO.AddNewCard(card);
_entities.cards.Add(card);
_entities.SaveChanges();
}
return(RedirectToAction("UserCards"));
}
public Boolean DoImportCard()
{
if (Session[Keys.SESSION_ADMIN_INFO] == null)
{
return(false);
}
else
{
Master master = Session[Keys.SESSION_ADMIN_INFO] as Master;
if (rcm.GetRoleCompetence(master.RoleId, 11254))
{
try
{
cards c = new cards();
int CardId = int.Parse(Request["CardId"]);
string CardTextContent = Request["CardTextContent"].Replace("\n", "|");
string[] CardContent = CardTextContent.Split('|');
foreach (string Card in CardContent)
{
if (!string.IsNullOrEmpty(Card) && !cm.ExitCard(CardId, Card))
{
c.cardnum = Card;
c.cardnameid = CardId;
c.addtime = DateTime.Now;
c.state = 0;
cm.AddCard(c);
}
}
return(true);
}
catch (Exception)
{
return(false);
}
}
else
{
return(false);
}
}
}
/// <summary>
/// 添加新手卡号
/// </summary>
/// <param name="c">卡号</param>
/// <returns>返回是否添加成功</returns>
public Boolean AddCard(cards c)
{
try
{
string sql = "insert into cards(cardnum,cardnameid)values (@cardnum,@cardnameid)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@cardnum", c.cardnum),
new SqlParameter("@cardnameid", c.cardnameid)
};
return(db.ExecuteNonQuery(sql, sp));
}
catch (SqlException ex)
{
throw new Exception("数据库异常！原因：" + ex.Message);
}
catch (Exception ex)
{
throw new Exception("未知异常！原因：" + ex.Message);
}
}
public async Task <ActionResult> Create([Bind(Include = "Id,layout_id,text,image,USER_ID,published,ITEM_TYPE_ID, CARD_CLAIMS, preview, preview_2")] cards cards)
{
if (ModelState.IsValid)
{
string userName = User.Identity.Name;
var store = new UserStore <ApplicationUser>(new ApplicationDbContext());
var userManager = new UserManager <ApplicationUser>(store);
ApplicationUser user = userManager.FindByNameAsync(userName).Result;
cards.USER_ID = user.Id;
db.cards.Add(cards);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.USER_ID = new SelectList(db.AspNetUsers, "Id", "UserName", cards.USER_ID);
ViewBag.layout_id = new SelectList(db.layout, "Id", "width", cards.layout_id);
ViewBag.ITEM_TYPE_ID = new SelectList(db.ITEM_TYPE, "Id", "NAME", cards.ITEM_TYPE_ID);
return(View(cards));
}
public ActionResult EditLayoutNew(String imageData)
{
application application = new application();
cards card = new cards();
if (ModelState.IsValid)
{
string userName = User.Identity.Name;
var store = new UserStore <ApplicationUser>(new ApplicationDbContext());
var userManager = new UserManager <ApplicationUser>(store);
ApplicationUser user = userManager.FindByNameAsync(userName).Result;
string userId = user.Id;
card.USER_ID = userId;
card.layout_id = 1;
card.IMAGES.Image = imageData;
applicationDAO.AddNewCard(card);
return(RedirectToAction("UserApplication"));
}
else
{
return(View("EditLayout"));
}
}
public ActionResult getItemTypeCards(int?id)
{
if (id != null)
{
cards card = _entities.cards.Find(id);
List <cards> cardsQuery = _entities.cards.Where(c => c.layout.name == card.layout.name && c.ITEM_TYPE.NAME == card.ITEM_TYPE.NAME && c.published == true).ToList();
var Search = new Search();
String itemTypeId = card.ITEM_TYPE.NAME;
Search.typeId = itemTypeId;
var exSearch = new ExtandedSearchModel();
var availItems = new List <checkBoxListModel>();
var selectedItems = new List <checkBoxListModel>();
var claims = applicationDAO.getAllCardClaims().Where(c => c.published == true);
int count = 0;
foreach (var item in claims)
{
if (item.ClaimType != "TYPE")
{
availItems.Add(new checkBoxListModel(count, item.ClaimValue, item.ClaimType));
}
count++;
}
Search.availItems = availItems;
Session["itemTypeSession"] = itemTypeId;
//var cards = applicationDAO.getItemLayouts(itemTypeId).Where(c => c.published == true);
//foreach (var i in cards)
//{
// Search.Cards.Add(i);
//}
Search.Cards.AddRange(cardsQuery);
return(View("exSearch", Search));
}
else
{
return(RedirectToAction("ItemTypes"));
}
}
public void SaveGuardCardToCard()
{
Bll bll = new Bll();
Log.Info(LogTags.BaseData, "获取门禁信息...");
List <EntranceGuardCard> elst = bll.EntranceGuardCards.ToList();
List <Personnel> plst = bll.Personnels.ToList();
List <EntranceGuardCardToPersonnel> eglst = bll.EntranceGuardCardToPersonnels.ToList();
List <cards> cardsList = new List <cards>();
for (int i = 0; i < elst.Count; i++)
{
var item = elst[i];
cards card = new cards();
card.cardId = item.Abutment_Id ?? 0;
card.cardCode = item.Code;
card.state = item.State;
var r = eglst.Find(j => j.EntranceGuardCardId == item.Id);
if (r != null)
{
card.emp_id = r.Personnel.Abutment_Id ?? r.PersonnelId;
}
cardsList.Add(card);
//if (i % 20 == 0)
{
Log.Info(LogTags.BaseData, string.Format("device:{0}({1}/{2})", card.cardCode, i, elst.Count));
}
}
Log.Info(LogTags.BaseData, "保存门禁信息...");
BaseDataDb db = new BaseDataDb();
var r2 = db.SetTable(db.cards, cardsList);
}
public void TestScoreUserCard()
{
// Arrange
const int totalScoreResul = 21;
cards card = new cards();
// Test
List <int> userCardList = new List <int>();
userCardList.Add(7);
userCardList.Add(9);
userCardList.Add(5);
int totalUserScoreCard = 0;
foreach (int element in userCardList)
{
totalUserScoreCard = card.totalUserScoreSave(element);
}
// Assert or Affirmation.
Assert.AreEqual(totalScoreResul, totalUserScoreCard);
}
public void TestGetCard()
{
// Arrange.
const int cardMax = 10;
cards card = new cards();
// Test.
bool valueIncorrect = false;
var result = card.getCard();
if (result <= cardMax)
{
valueIncorrect = false;
}
else
{
valueIncorrect = true;
}
// Assert or Affirmation.
Assert.IsFalse(valueIncorrect);
}
