public HttpResponseMessage AddUnit(Entities.MstUnit objUnit)
{
try
{
var currentUser = from d in db.MstUsers
where d.UserId == User.Identity.GetUserId()
select d;
if (currentUser.Any())
{
var currentUserId = currentUser.FirstOrDefault().Id;
var userForms = from d in db.MstUserForms
where d.UserId == currentUserId &&
d.SysForm.FormName.Equals("SystemTables")
select d;
if (userForms.Any())
{
if (userForms.FirstOrDefault().CanAdd)
{
Data.MstUnit newUnit = new Data.MstUnit
{
Unit = objUnit.Unit,
IsLocked = true,
CreatedById = currentUserId,
CreatedDateTime = DateTime.Now,
UpdatedById = currentUserId,
UpdatedDateTime = DateTime.Now
};
db.MstUnits.InsertOnSubmit(newUnit);
db.SubmitChanges();
String newObject = at.GetObjectString(newUnit);
at.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, "NA", newObject);
return(Request.CreateResponse(HttpStatusCode.OK, newUnit.Id));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add unit."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this system table page."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Theres no current user logged in."));
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server."));
}
}
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 int Post(Models.MstUnit unit)
{
try
{
Data.MstUnit newUnit = new Data.MstUnit();
newUnit.Unit = unit.Unit;
db.MstUnits.InsertOnSubmit(newUnit);
db.SubmitChanges();
return newUnit.Id;
}
catch
{
return 0;
}
}
public Int32 postUnit()
{
try
{
Data.MstUnit newUnit = new Data.MstUnit();
newUnit.Unit = "n/a";
db.MstUnits.InsertOnSubmit(newUnit);
db.SubmitChanges();
return(newUnit.Id);
}
catch (Exception e)
{
return(0);
}
}
public Int32 insertUnit(Models.MstUnit unit)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
Data.MstUnit newUnit = new Data.MstUnit();
newUnit.Unit = unit.Unit;
newUnit.IsLocked = unit.IsLocked;
newUnit.CreatedById = userId;
newUnit.CreatedDateTime = DateTime.Now;
newUnit.UpdatedById = userId;
newUnit.UpdatedDateTime = DateTime.Now;
db.MstUnits.InsertOnSubmit(newUnit);
db.SubmitChanges();
return(newUnit.Id);
}
catch
{
return(0);
}
}
public Int32 insertUnit(Models.MstUnit unit)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
Data.MstUnit newUnit = new Data.MstUnit();
newUnit.Unit = unit.Unit;
newUnit.IsLocked = unit.IsLocked;
newUnit.CreatedById = userId;
newUnit.CreatedDateTime = DateTime.Now;
newUnit.UpdatedById = userId;
newUnit.UpdatedDateTime = DateTime.Now;
db.MstUnits.InsertOnSubmit(newUnit);
db.SubmitChanges();
return newUnit.Id;
}
catch
{
return 0;
}
}
