//THIS IS AN INSERT
public bool commitInsert(Guid _cardId, string _sName, string _sEmail, string _pName, string _pRoomNum, string _to, string _from, string _message)
{
GiftShopCardDataContext objCard = new GiftShopCardDataContext();
//to ensure all data will be disposed when finished
try
{
//create an instance of the table
brdhc_GiftShopSendCard objNewCard = new brdhc_GiftShopSendCard();
//set the table columns being passed from giftShopSendACard.aspx page
objNewCard.CardID = _cardId;
objNewCard.senderName = _sName;
objNewCard.senderEmail = _sEmail;
objNewCard.patientName = _pName;
objNewCard.patientRoom = _pRoomNum;
objNewCard.To = _to;
objNewCard.From = _from;
objNewCard.Message = _message;
//insert command
objCard.brdhc_GiftShopSendCards.InsertOnSubmit(objNewCard);
//commit insert against db
objCard.SubmitChanges();
return true;
}
catch (Exception e)
{
clsCommon.saveError(e);
return false;
}
}
public IQueryable<brdhc_GiftShopSendCard> getCardById(Guid _CardID)
{
GiftShopCardDataContext objCard = new GiftShopCardDataContext();
var allCard = objCard.brdhc_GiftShopSendCards.Where(x => x.CardID == _CardID).Select(x => x);
//x into x, select all columns from the table
//x.Id to access a specific column in the table
return allCard;
}
public IQueryable<brdhc_GiftShopSendCard> getCards()
{
//creating an instance of our LINQ object
GiftShopCardDataContext objCard = new GiftShopCardDataContext();
//creating an anonymous variable with its value being the instance of teh LINQ object
var allCards = objCard.brdhc_GiftShopSendCards.Select(x => x);
//var allQues = from x in objProd.products select x;
return allCards;
}
//THIS IS A DELETE
public bool commitDelete(Guid _CardID)
{
GiftShopCardDataContext objCardDel = new GiftShopCardDataContext();
using (objCardDel)
{
var objDelCan = objCardDel.brdhc_GiftShopSendCards.Single(x => x.CardID == _CardID);
objCardDel.brdhc_GiftShopSendCards.DeleteOnSubmit(objDelCan); //if you want to delete all best to drop the table
objCardDel.SubmitChanges();
return true;
}
}
