public HttpResponseMessage SaveMstChecList(MstCheckList checklist)
{
try
{
var MstChecListData = from d in db.MstCheckLists where d.Id == Convert.ToInt32(checklist.Id) select d;
if (MstChecListData.Any())
{
if (MstChecListData.First().IsLocked == false)
{
var currentUser = from d in db.MstUsers
where d.AspNetId == User.Identity.GetUserId()
select d;
if (currentUser.Any())
{
var UpdateMstChecListData = MstChecListData.FirstOrDefault();
UpdateMstChecListData.CheckListCode = checklist.ChecklistCode;
UpdateMstChecListData.CheckList = checklist.Checklist;
UpdateMstChecListData.CheckListDate = Convert.ToDateTime(checklist.ChecklistDate);
UpdateMstChecListData.ProjectId = checklist.ProjectId;
UpdateMstChecListData.Remarks = checklist.Remarks;
UpdateMstChecListData.Status = checklist.Status;
UpdateMstChecListData.UpdatedBy = currentUser.FirstOrDefault().Id;
UpdateMstChecListData.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
public Int32 PostMstCheckList(MstCheckList checklist)
{
try
{
var currentUser = from d in db.MstUsers
where d.AspNetId == User.Identity.GetUserId()
select d;
if (currentUser.Any())
{
string checklistCode = "0001";
var checklists = from d in db.MstCheckLists.OrderByDescending(d => d.Id) select d;
if (checklists.Any())
{
Int32 nextChecklistCode = Convert.ToInt32(checklists.FirstOrDefault().CheckListCode) + 1;
checklistCode = padNumWithZero(nextChecklistCode, 4);
}
Data.MstCheckList newMstChecList = new Data.MstCheckList()
{
CheckListCode = checklistCode,
CheckList = checklist.Checklist,
CheckListDate = Convert.ToDateTime(checklist.ChecklistDate),
ProjectId = checklist.ProjectId,
Remarks = checklist.Remarks,
Status = checklist.Status,
IsLocked = checklist.IsLocked,
CreatedBy = currentUser.FirstOrDefault().Id,
CreatedDateTime = DateTime.Now,
UpdatedBy = currentUser.FirstOrDefault().Id,
UpdatedDateTime = DateTime.Now,
};
db.MstCheckLists.InsertOnSubmit(newMstChecList);
db.SubmitChanges();
return(newMstChecList.Id);
}
else
{
return(0);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(0);
}
}
