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