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