public bool UpdateAssetLocation(AssetLocation obj)
{
bool result;
IDbContextTransaction transaction = _context.Database.BeginTransaction();
var assetlocation = _assetlocation.GetAssetLocationByID(obj.ID);
if (assetlocation != null)
{
try
{
assetlocation.AssetID = obj.AssetID;
assetlocation.LocationID = obj.LocationID;
assetlocation.OnTransition = obj.OnTransition;
assetlocation.MovementRequestDetailID = obj.MovementRequestDetailID;
assetlocation.UpdatedBy = obj.UpdatedBy;
assetlocation.UpdatedDate = DateTime.Now.Date.ToString("ddMMyyyy");
_context.Entry(assetlocation).State = EntityState.Modified;
_context.SaveChanges();
transaction.Commit();
result = true;
}
catch (Exception ex)
{
transaction.Rollback();
result = false;
}
}
else
{
result = false;
}
return(result);
}
public bool ApproveMovementRequest(MovementRequest obj)
{
bool result;
IDbContextTransaction transaction = _context.Database.BeginTransaction();
var request = _movementrequest.GetMovementRequestByID(obj.ID);
if (request != null)
{
try
{
request.ApprovedBy = obj.UpdatedBy;
request.ApprovedDate = obj.ApprovedDate;//DateTime.Now.ToString("ddMMyyyy");
request.ApprovalStatus = obj.ApprovalStatus;
request.UpdatedBy = obj.UpdatedBy;
request.UpdatedDate = obj.UpdatedDate;//DateTime.Now;
request.Notes = obj.Notes;
_context.Entry(request).State = EntityState.Modified;
_context.SaveChanges();
transaction.Commit();
result = true;
}
catch (Exception ex)
{
transaction.Rollback();
result = false;
}
}
else
{
result = false;
}
return(result);
}
public bool UpdateDepartment(DepartmentViewModel obj)
{
bool result;
IDbContextTransaction transaction = _context.Database.BeginTransaction();
var prevObj = _extension.GetDepartmentByID(obj.ID);
if (prevObj != null)
{
try
{
prevObj.Name = obj.Name;
prevObj.Description = obj.Description;
prevObj.IsActive = obj.IsActive;
_context.Entry(prevObj).State = EntityState.Modified;
_context.SaveChanges();
transaction.Commit();
result = true;
}
catch (Exception ex)
{
transaction.Rollback();
result = false;
}
}
else
{
result = false;
}
return(result);
}
public bool UpdateAsset(AssetViewModel obj)
{
bool result;
IDbContextTransaction transaction = _context.Database.BeginTransaction();
var asset = _asset.GetAssetInfoByID(obj.Asset.ID);
if (asset != null)
{
try
{
obj.SubCategory = _generatecode.SubCategoryAsset(Convert.ToInt16(obj.Asset.CategoryCD));
obj.Asset.Code = _generatecode.GenerateCode(obj.CompanyCode, obj.ApplicationCode, obj.MainCategory, obj.SubCategory, asset.No);
if (asset.Code != obj.Asset.Code)
{
asset.Code = obj.Asset.Code;
}
asset.Description = obj.Asset.Description;
asset.Name = obj.Asset.Name;
asset.IsMovable = obj.Asset.IsMovable;
asset.Owner = obj.Asset.Owner;
asset.PurchaseDate = obj.Asset.PurchaseDate.Replace("/", string.Empty);
asset.PurchasePrice = obj.Asset.PurchasePrice;
asset.DepreciationDuration = obj.Asset.DepreciationDuration;
asset.ManufactureDate = obj.Asset.ManufactureDate.Replace("/", string.Empty);
asset.CategoryCD = Convert.ToInt16(obj.Asset.CategoryCD);
asset.StatusCD = obj.Asset.StatusCD;
asset.UpdatedBy = obj.UpdatedBy;
asset.UpdatedDate = obj.UpdatedDate;//DateTime.Now;
_context.Entry(asset).State = EntityState.Modified;
_context.SaveChanges();
transaction.Commit();
result = true;
}
catch (Exception ex)
{
transaction.Rollback();
result = false;
}
}
else
{
result = false;
}
return(result);
}
public bool UpdateAsset(Asset obj)
{
bool result;
IDbContextTransaction transaction = _context.Database.BeginTransaction();
var asset = _asset.GetAssetInfoByID(obj.ID);
if (asset != null)
{
try
{
asset.Code = obj.Code;
asset.Description = obj.Description;
asset.No = obj.No;
asset.Name = obj.Name;
asset.IsMovable = obj.IsMovable;
asset.Owner = obj.Owner;
asset.PurchaseDate = obj.PurchaseDate;
asset.PurchasePrice = obj.PurchasePrice;
asset.DepreciationDuration = obj.DepreciationDuration;
asset.DisposedDate = obj.DisposedDate;
asset.ManufactureDate = obj.ManufactureDate;
asset.CategoryCD = obj.CategoryCD;
asset.StatusCD = obj.StatusCD;
asset.UpdatedBy = obj.UpdatedBy;
asset.UpdatedDate = DateTime.Now.Date.ToString("ddMMyyyy");
_context.Entry(asset).State = EntityState.Modified;
_context.SaveChanges();
transaction.Commit();
result = true;
}
catch (Exception ex)
{
transaction.Rollback();
result = false;
}
}
else
{
result = false;
}
return(result);
}
public bool UpdateLocation(LocationViewModel obj)
{
bool result;
IDbContextTransaction transaction = _context.Database.BeginTransaction();
var location = _location.GetLocationByID(obj.ID);
if (location != null)
{
try
{
obj.SubCategory = _generatecode.SubCategoryLocation(obj.LocationTypeCD, obj.Floor);
obj.Code = _generatecode.GenerateCode(obj.CompanyCode, obj.ApplicationCode, obj.MainCategory, obj.SubCategory, location.No);
if (location.Code != obj.Code)
{
location.Code = obj.Code;
}
location.Description = obj.Description;
location.Name = obj.Name;
location.Floor = obj.Floor;
location.LocationTypeCD = obj.LocationTypeCD;
location.StatusCD = obj.StatusCD;
location.UpdatedBy = obj.UpdatedBy;
location.UpdatedDate = DateTime.Now.Date.ToString("ddMMyyyy");
_context.Entry(location).State = EntityState.Modified;
_context.SaveChanges();
transaction.Commit();
result = true;
}
catch (Exception ex)
{
transaction.Rollback();
result = false;
}
}
else
{
result = false;
}
return(result);
}
public bool UpdateLocation(Location obj)
{
bool result;
IDbContextTransaction transaction = _context.Database.BeginTransaction();
var location = _location.GetLocationByID(obj.ID);
if (location != null)
{
try
{
location.Code = obj.Code;
location.Description = obj.Description;
location.No = obj.No;
location.Name = obj.Name;
location.Floor = obj.Floor;
location.LocationTypeCD = obj.LocationTypeCD;
location.StatusCD = obj.StatusCD;
location.UpdatedBy = obj.UpdatedBy;
location.UpdatedDate = DateTime.Now.Date.ToString("ddMMyyyy");
_context.Entry(location).State = EntityState.Modified;
_context.SaveChanges();
transaction.Commit();
result = true;
}
catch (Exception ex)
{
transaction.Rollback();
result = false;
}
}
else
{
result = false;
}
return(result);
}
