public Int32 PostMstCheckListRequirement(MstCheckListRequirement checklistRequirement) { try { Data.MstCheckListRequirement newMstCheckListRequirement = new Data.MstCheckListRequirement() { CheckListId = checklistRequirement.ChecklistId, RequirementNo = checklistRequirement.RequirementNo, Requirement = checklistRequirement.Requirement, Category = checklistRequirement.Category, Type = checklistRequirement.Type, WithAttachments = checklistRequirement.WithAttachments }; db.MstCheckListRequirements.InsertOnSubmit(newMstCheckListRequirement); db.SubmitChanges(); return(newMstCheckListRequirement.Id); } catch (Exception e) { Debug.WriteLine(e); return(0); } }
public HttpResponseMessage UpdateCheckListRequirements(MstCheckListRequirement checklistRequirement) { try { var MstCheckListRequirementsData = from d in db.MstCheckListRequirements where d.Id == Convert.ToInt32(checklistRequirement.Id) select d; if (MstCheckListRequirementsData.Any()) { var UpdateCheckListRequirementsData = MstCheckListRequirementsData.FirstOrDefault(); UpdateCheckListRequirementsData.RequirementNo = checklistRequirement.RequirementNo; UpdateCheckListRequirementsData.Requirement = checklistRequirement.Requirement; UpdateCheckListRequirementsData.Category = checklistRequirement.Category; UpdateCheckListRequirementsData.Type = checklistRequirement.Type; UpdateCheckListRequirementsData.WithAttachments = checklistRequirement.WithAttachments; db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.OK)); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }