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); }
public void CreateFieldValue(int fkCard, int fkField, string value, int instance) { CollectedFieldsValues newValue = new CollectedFieldsValues(); newValue.Active = true; newValue.FkCollectedCard = fkCard; newValue.FkField = fkField; newValue.FkUser = 1; newValue.ValueText = value; newValue.CreateDateTime = DateTime.Now; newValue.IsDeleted = false; newValue.Version = 1; newValue.Instance = instance; _chancDb.CollectedFieldsValues.InsertOnSubmit(newValue); _chancDb.SubmitChanges(); }
public void createFieldValue(int fkCard, int fkField, string value, int instance) { ChancelerryDBDataContext chancDB = new ChancelerryDBDataContext(); CollectedFieldsValues newValue = new CollectedFieldsValues(); newValue.active = true; newValue.fk_collectedCard = fkCard; newValue.fk_field = fkField; newValue.fk_user = 1; newValue.valueText = value; newValue.createDateTime = DateTime.Now; newValue.isDeleted = false; newValue.version = 1; newValue.instance = instance; chancDB.CollectedFieldsValues.InsertOnSubmit(newValue); chancDB.SubmitChanges(); }
protected void Button3_Click(object sender, EventArgs e) { List <CollectedCards> allCardsInRegister = (from a in _chancDb.CollectedCards where a.FkRegister == 3 select a).ToList(); int cnt = 0; List <CollectedFieldsValues> fieldAllValues = (from a in _chancDb.CollectedFieldsValues where a.FkField == 101 join b in _chancDb.CollectedCards on a.FkCollectedCard equals b.CollectedCardID where b.FkRegister == 3 select a).ToList(); foreach (CollectedCards currentCard in allCardsInRegister) { if (!(from a in fieldAllValues where a.FkCollectedCard == currentCard.CollectedCardID select a).Any()) { CollectedFieldsValues addinfoFieldValue = new CollectedFieldsValues(); addinfoFieldValue.FkCollectedCard = currentCard.CollectedCardID; addinfoFieldValue.FkField = 101; addinfoFieldValue.FkUser = 1; addinfoFieldValue.Active = true; addinfoFieldValue.CreateDateTime = DateTime.Now; addinfoFieldValue.Instance = 0; addinfoFieldValue.Version = 0; addinfoFieldValue.IsDeleted = false; addinfoFieldValue.ValueText = ""; _chancDb.CollectedFieldsValues.InsertOnSubmit(addinfoFieldValue); cnt++; } } //_chancDb.SubmitChanges(); }