//public void UpdateStatusApprove(int id) //{ // coreInfo coreinfo = dbcontext.coreInfos.Where(x => x.ID == id).FirstOrDefault(); // if (coreinfo != null) // { // coreinfo.status = "Approve"; // } // dbcontext.SubmitChanges(); //} /// <summary> /// This method will update the status of an intervention by specifying the core info /// ID and the status of that intervention. /// </summary> /// <param name="id">Core Info ID</param> /// <param name="setStatus">Status value</param> public void UpdatesStaus(int id, string setStatus) { coreInfo coreInfo = dbcontext.coreInfos.Where(x => x.ID == id).FirstOrDefault(); if (coreInfo != null) { coreInfo.status = setStatus; } dbcontext.SubmitChanges(); }
/// <summary> /// This method will create the core information record based on the specified data /// </summary> /// <param name="iType_id">Intervention Type ID</param> /// <param name="client_id">Client ID</param> /// <param name="labour">Labor Hours</param> /// <param name="cost">Cost of Intervention</param> /// <param name="user_id">User ID</param> /// <param name="iDate">Date</param> /// <param name="status">Status</param> /// <param name="comments">Comments</param> /// <param name="reamaining">Remaining Life</param> /// <param name="date_recent_visit">Date of Recent Visit</param> public void CreateCoreInfo(int iType_id, int client_id, int labour, int cost, int user_id, DateTime iDate, string status, string comments, int reamaining, DateTime date_recent_visit) { coreInfo coreInfo = new coreInfo(); coreInfo.iType_id = iType_id; coreInfo.client_id = client_id; coreInfo.labour = labour; coreInfo.cost = cost; coreInfo.user_id = user_id; coreInfo.iDate = iDate; coreInfo.status = status; coreInfo.comments = comments; coreInfo.reamaining = reamaining; coreInfo.date_recent_visit = date_recent_visit; dbcontext.coreInfos.InsertOnSubmit(coreInfo); dbcontext.SubmitChanges(); }
partial void DeletecoreInfo(coreInfo instance);
partial void UpdatecoreInfo(coreInfo instance);
partial void InsertcoreInfo(coreInfo instance);