//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; } }