//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;
}
}
partial void Updatebrdhc_GiftShopSendCard(brdhc_GiftShopSendCard instance);
partial void Deletebrdhc_GiftShopSendCard(brdhc_GiftShopSendCard instance);
partial void Insertbrdhc_GiftShopSendCard(brdhc_GiftShopSendCard instance);