public Int32 PostTrnSoldUnitRequirementActivity(TrnSoldUnitRequirementActivity soldUnitRequirementActivity)
{
try
{
var currentUser = from d in db.MstUsers
where d.AspNetId == User.Identity.GetUserId()
select d;
if (currentUser.Any())
{
Data.TrnSoldUnitRequirementActivity newTrnSoldUnitRequirementActivity = new Data.TrnSoldUnitRequirementActivity()
{
SoldUnitRequirementId = soldUnitRequirementActivity.SoldUnitRequirementId,
ActivityDate = DateTime.Now,
Activity = soldUnitRequirementActivity.Activity,
Remarks = soldUnitRequirementActivity.Remarks,
UserId = currentUser.FirstOrDefault().Id
};
db.TrnSoldUnitRequirementActivities.InsertOnSubmit(newTrnSoldUnitRequirementActivity);
db.SubmitChanges();
return(newTrnSoldUnitRequirementActivity.Id);
}
else
{
return(0);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(0);
}
}
public HttpResponseMessage Update(TrnSoldUnitRequirementActivity soldUnitRequirementActivity)
{
try
{
var TrnSoldUnitRequirementActivityData = from d in db.TrnSoldUnitRequirementActivities
where d.Id == Convert.ToInt32(soldUnitRequirementActivity.Id)
select d;
if (TrnSoldUnitRequirementActivityData.Any())
{
var currentUser = from d in db.MstUsers
where d.AspNetId == User.Identity.GetUserId()
select d;
if (currentUser.Any())
{
var UpdateTrnSoldUnitRequirementActivityData = TrnSoldUnitRequirementActivityData.FirstOrDefault();
UpdateTrnSoldUnitRequirementActivityData.ActivityDate = DateTime.Now;
UpdateTrnSoldUnitRequirementActivityData.Activity = soldUnitRequirementActivity.Activity;
UpdateTrnSoldUnitRequirementActivityData.Remarks = soldUnitRequirementActivity.Remarks;
UpdateTrnSoldUnitRequirementActivityData.UserId = currentUser.FirstOrDefault().Id;
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
