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