//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);
