public int GetFieldIdForCard(CollectedCards card) { ChancelerryDBDataContext chancDB = new ChancelerryDBDataContext(); int valueToreturn = 0; Fields mainFieldInRegister = (from a in chancDB.Fields join b in chancDB.FieldsGroups on a.fk_fieldsGroup equals b.fieldsGroupID join c in chancDB.RegistersModels on b.fk_registerModel equals c.registerModelID join d in chancDB.Registers on c.registerModelID equals d.fk_registersModel where d.registerID == card.fk_register && (a.type == "autoIncrementReadonly" || a.type == "autoIncrement") select a).FirstOrDefault(); if (mainFieldInRegister != null) { CollectedFieldsValues collectedId = (from a in chancDB.CollectedFieldsValues where a.fk_field == mainFieldInRegister.fieldID && a.fk_collectedCard == card.collectedCardID select a).OrderByDescending(mc => mc.version).FirstOrDefault(); if (collectedId != null) { Int32.TryParse(collectedId.valueText, out valueToreturn); } } return(valueToreturn); }
protected void OpenByIdButton_Click(object sender, EventArgs e) { string textboxValue = OpenByIdTextBox.Text; if (textboxValue != null) { if (textboxValue.Length > 0) { int cardId = 0; Int32.TryParse(textboxValue, out cardId); if (cardId != 0) { ChancelerryDb dataContext = new ChancelerryDb(new NpgsqlConnection(WebConfigurationManager.AppSettings["ConnectionStringToPostgre"])); int regId; Int32.TryParse(Session["registerID"].ToString(), out regId); CollectedCards cardIdReal = (from a in dataContext.CollectedCards where a.FkRegister == regId && a.MaInFieldID == cardId && a.Active select a).FirstOrDefault(); if (cardIdReal != null) { Session["canEdit"] = true; Session["cardID"] = cardIdReal.CollectedCardID; Session["version"] = 200500; Response.Redirect("CardEdit.aspx"); } } } } }
public void DeleteCard(object sender, EventArgs e) { ImageButton thisButton = (ImageButton)sender; int currentCardId = Convert.ToInt32(thisButton.Attributes["_cardID"]); HttpContext.Current.Session["cardID"] = currentCardId; int regId; int.TryParse(HttpContext.Current.Session["registerID"].ToString(), out regId); ChancelerryDb dataContext = new ChancelerryDb(new NpgsqlConnection(WebConfigurationManager.AppSettings["ConnectionStringToPostgre"])); CollectedCards card = (from c in dataContext.CollectedCards where c.FkRegister == regId && c.CollectedCardID == currentCardId select c).FirstOrDefault(); if (card != null) { card.Active = false; } dataContext.SubmitChanges(); HttpContext.Current.Response.Redirect("~/kanz/RegisterView.aspx", true); }
public int addCard(int fkRegister) { ChancelerryDBDataContext chancDB = new ChancelerryDBDataContext(); CollectedCards newCard = new CollectedCards(); newCard.active = true; newCard.fk_register = fkRegister; chancDB.CollectedCards.InsertOnSubmit(newCard); chancDB.SubmitChanges(); return(newCard.collectedCardID); }
public int AddCard(int fkRegister, int mainFieldId) { CollectedCards newCard = new CollectedCards(); newCard.Active = true; newCard.FkRegister = fkRegister; newCard.MaInFieldID = mainFieldId; _chancDb.CollectedCards.InsertOnSubmit(newCard); _chancDb.SubmitChanges(); return(newCard.CollectedCardID); }
protected void PrintFinded_Click(object sender, EventArgs e) { List <int> allCards = (List <int>)Session["cardsIds"]; if (allCards == null) { return; } List <PrintManyParams> printParams = new List <PrintManyParams>(); foreach (int cardId in allCards) { CollectedCards card = main.GetCardById(cardId); printParams.Add(new PrintManyParams() { CardId = cardId, RegisterId = card.FkRegister, Version = main.GetLastVersionByCard(cardId) }); } Session["PrintManyParams"] = printParams; Response.Redirect("PrintMany.aspx"); }