public HttpResponseMessage SaveUnit(MstUnit unit)
{
try
{
var MstUnitData = from d in db.MstUnits where d.Id == Convert.ToInt32(unit.Id) select d;
if (MstUnitData.Any())
{
if (MstUnitData.First().IsLocked == false)
{
var currentUser = from d in db.MstUsers
where d.AspNetId == User.Identity.GetUserId()
select d;
if (currentUser.Any())
{
var UpdateMstUnitData = MstUnitData.FirstOrDefault();
UpdateMstUnitData.UnitCode = unit.UnitCode;
UpdateMstUnitData.Block = unit.Block;
UpdateMstUnitData.Lot = unit.Lot;
UpdateMstUnitData.ProjectId = unit.ProjectId;
UpdateMstUnitData.HouseModelId = unit.HouseModelId;
UpdateMstUnitData.TLA = unit.TLA;
UpdateMstUnitData.TFA = unit.TFA;
UpdateMstUnitData.Price = unit.Price;
UpdateMstUnitData.MiscellaneousFeeRate = unit.MiscellaneousFeeRate;
UpdateMstUnitData.MiscellaneousFeeAmount = unit.MiscellaneousFeeAmount;
UpdateMstUnitData.VATRate = unit.VATRate;
UpdateMstUnitData.VATAmount = unit.VATAmount;
UpdateMstUnitData.TSP = unit.TSP;
UpdateMstUnitData.Status = unit.Status;
UpdateMstUnitData.UpdatedBy = currentUser.FirstOrDefault().Id;
UpdateMstUnitData.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 PostMstUnit(MstUnit unit)
{
try
{
var currentUser = from d in db.MstUsers
where d.AspNetId == User.Identity.GetUserId()
select d;
if (currentUser.Any())
{
var defaultHouseModel = from d in db.MstHouseModels where d.ProjectId == unit.ProjectId select d;
if (defaultHouseModel.Any())
{
Data.MstUnit newMstUnit = new Data.MstUnit()
{
UnitCode = unit.UnitCode,
Block = unit.Block,
Lot = unit.Lot,
ProjectId = unit.ProjectId,
HouseModelId = defaultHouseModel.FirstOrDefault().Id,
TLA = unit.TLA,
TFA = unit.TFA,
Price = unit.Price,
MiscellaneousFeeRate = unit.MiscellaneousFeeRate,
MiscellaneousFeeAmount = unit.MiscellaneousFeeAmount,
VATRate = unit.VATRate,
VATAmount = unit.VATAmount,
TSP = unit.TSP,
Status = unit.Status,
IsLocked = unit.IsLocked,
CreatedBy = currentUser.FirstOrDefault().Id,
CreatedDateTime = DateTime.Now,
UpdatedBy = currentUser.FirstOrDefault().Id,
UpdatedDateTime = DateTime.Now
};
db.MstUnits.InsertOnSubmit(newMstUnit);
db.SubmitChanges();
return(newMstUnit.Id);
}
else
{
return(0);
}
}
else
{
return(0);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(0);
}
}
public async Task <bool> AddAsync(MstUnit entity)
{
using (EkalContext dbContext = new EkalContext())
{
try
{
await dbContext.MstUnit.AddAsync(entity);
dbContext.SaveChanges();
return(true);
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
}
}
public HttpResponseMessage UnLock(MstUnit unit)
{
try
{
var MstUnitData = from d in db.MstUnits where d.Id == Convert.ToInt32(unit.Id) select d;
if (MstUnitData.Any())
{
var currentUser = from d in db.MstUsers
where d.AspNetId == User.Identity.GetUserId()
select d;
if (currentUser.Any())
{
var UnLockMstUnitData = MstUnitData.FirstOrDefault();
UnLockMstUnitData.IsLocked = false;
UnLockMstUnitData.UpdatedBy = currentUser.FirstOrDefault().Id;
UnLockMstUnitData.UpdatedDateTime = DateTime.Now;
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));
}
}
