public void Delete(int id) { //mycontext.Trainings.Remove(dbemp); TMSEntityLayer.EF.Training dbemp = GetByID(id); dbemp.Status = 2; mycontext.SaveChanges(); }
public TMSEntityLayer.EF.Training GetByID(int id) { TMSEntityLayer.EF.Training result = (mycontext.Trainings .Include("Domain") .Where((train) => train.TrainingID == id && train.Status == 1) .OrderBy((train) => train.Title) .Select((train) => train)).SingleOrDefault(); return(result); }
public void Update(TMSEntityLayer.EF.Training tr) { TMSEntityLayer.EF.Training dbemp = new Training(); dbemp = GetByID(tr.TrainingID); dbemp.Title = tr.Title; dbemp.DomainID = tr.DomainID; dbemp.StartDate = tr.StartDate; dbemp.EndDate = tr.EndDate; dbemp.Credits = tr.Credits; int ret = mycontext.SaveChanges(); }
protected void Page_Load(object sender, EventArgs e) { string tid1 = Request.QueryString["tid"]; tid = Convert.ToByte(tid1); mtr = new TMSBL.EF.EFManageTraining(); TMSEntityLayer.EF.Training tr = mtr.GetByID(tid); if (!Page.IsPostBack) { txtName.Text = tr.Title; txtSD.Text = tr.StartDate.ToShortDateString(); txtED.Text = tr.EndDate.ToShortDateString(); txtCredits.Text = tr.Credits.ToString(); ddlDomain.DataSource = mtr.GetDomains(); ddlDomain.DataTextField = "Name"; ddlDomain.DataValueField = "DomainID"; ddlDomain.DataBind(); ddlDomain.SelectedIndex = ddlDomain.Items.IndexOf(ddlDomain.Items.FindByValue(tr.DomainID.ToString())); ddlDomain.Items.Insert(0, new ListItem("--Select--", "0")); } }
public void Add(TMSEntityLayer.EF.Training tr) { //TMSEntityLayer.EF.Training newtr = tr; mycontext.Trainings.Add(tr); mycontext.SaveChanges(); }