public IQueryable<E_card> getE_card()
{
ecardDataContext objEcardDC = new ecardDataContext();
var allEcards = objEcardDC.E_cards.Select(x => x);
return allEcards;
}
public IQueryable<E_card> getE_cardByID(int _id)
{
ecardDataContext objEcardDC = new ecardDataContext();
var allEcards = objEcardDC.E_cards.Where(x => x.Id == _id).Select(x => x);
return allEcards;
}
public bool commitDelete(int _id)
{
ecardDataContext objEcardDC = new ecardDataContext();
using (objEcardDC)
{
var objDelEcard = objEcardDC.E_cards.Single(x => x.Id == _id);
objEcardDC.E_cards.DeleteOnSubmit(objDelEcard);
objEcardDC.SubmitChanges();
return true;
//return "Delete successful";
}
}
public bool commitUpdate(int _id, string _name, string _recipient, string _background, string _font, string _size, string _message)
{
ecardDataContext objEcardDC = new ecardDataContext();
using (objEcardDC)
{ var objUpEcard = objEcardDC.E_cards.Single(x => x.Id == _id);
objUpEcard.name = _name;
objUpEcard.recipient = _recipient;
objUpEcard.background = _background;
objUpEcard.font = _font;
objUpEcard.size = _size;
objUpEcard.message = _message;
objEcardDC.SubmitChanges();
return true;
//return "Update successful";
}
}
public bool commitInsert(string _name, string _recipient, string _background, string _font, string _size, string _message)
{
ecardDataContext objEcardDC = new ecardDataContext();
using (objEcardDC)
{
E_card objEcard = new E_card();
objEcard.name = _name;
objEcard.recipient = _recipient;
objEcard.background = _background;
objEcard.font = _font;
objEcard.size = _size;
objEcard.message = _message;
objEcardDC.E_cards.InsertOnSubmit(objEcard);
objEcardDC.SubmitChanges();
return true;
//return "Insert complete";
}
}
protected void subAddEcard(object sender, CommandEventArgs e)
{
ecardDataContext objEcardDC = new ecardDataContext();
E_card objEcard = new E_card();
objEcard.name = txtRec.Text;
objEcard.recipient = txtName.Text;
objEcard.background = ddlBg.SelectedItem.Value;
objEcard.font = ddlFont.SelectedItem.Value;
objEcard.size = ddlSize.SelectedItem.Value;
objEcard.message = txtGreeting.Text;
objEcardDC.E_cards.InsertOnSubmit(objEcard);
objEcardDC.SubmitChanges();
txtRec.Text = "";
txtName.Text = "";
ddlBg.SelectedItem.Text = "";
ddlFont.SelectedItem.Text = "";
ddlSize.SelectedItem.Text = "";
txtGreeting.Text = "";
lblTy.Text = "Thank you! The Ecard has been submitted.";
}