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();
}
