public HttpResponseMessage updateStockCount(String id, Models.TrnStockCount stockCount)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
var stockCounts = from d in db.TrnStockCounts where d.Id == Convert.ToInt32(id) select d;
if (stockCounts.Any())
{
var updateStockCount = stockCounts.FirstOrDefault();
updateStockCount.BranchId = stockCount.BranchId;
updateStockCount.SCNumber = stockCount.SCNumber;
updateStockCount.SCDate = Convert.ToDateTime(stockCount.SCDate);
updateStockCount.Particulars = stockCount.Particulars;
updateStockCount.PreparedById = stockCount.PreparedById;
updateStockCount.CheckedById = stockCount.CheckedById;
updateStockCount.ApprovedById = stockCount.ApprovedById;
updateStockCount.IsLocked = true;
updateStockCount.UpdatedById = userId;
updateStockCount.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
catch
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
public Int32 insertStockCount(Models.TrnStockCount stockCount)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
var lastSCNumber = from d in db.TrnStockCounts.OrderByDescending(d => d.Id) where d.BranchId == currentBranchId() select d;
var SCNumberResult = "0000000001";
if (lastSCNumber.Any())
{
var SCNumber = Convert.ToInt32(lastSCNumber.FirstOrDefault().SCNumber) + 0000000001;
SCNumberResult = zeroFill(SCNumber, 10);
}
Data.TrnStockCount newStockCount = new Data.TrnStockCount();
newStockCount.BranchId = currentBranchId();
newStockCount.SCNumber = SCNumberResult;
newStockCount.SCDate = DateTime.Today;
newStockCount.Particulars = "NA";
newStockCount.PreparedById = userId;
newStockCount.CheckedById = userId;
newStockCount.ApprovedById = userId;
newStockCount.IsLocked = false;
newStockCount.CreatedById = userId;
newStockCount.CreatedDateTime = DateTime.Now;
newStockCount.UpdatedById = userId;
newStockCount.UpdatedDateTime = DateTime.Now;
db.TrnStockCounts.InsertOnSubmit(newStockCount);
db.SubmitChanges();
return(newStockCount.Id);
}
catch
{
return(0);
}
}
