public bool CreateDepartment(DepartmentViewModel obj)
{
bool result;
IDbContextTransaction transaction = _context.Database.BeginTransaction();
if (obj != null)
{
try
{
//TODO : Check if same department name is exist
Department asset = new Department();
asset.ID = obj.ID;
asset.Name = obj.Name;
asset.Description = obj.Description;
asset.IsActive = obj.IsActive;
_context.Department.Add(asset);
_context.SaveChanges();
transaction.Commit();
result = true;
}
catch (Exception ex)
{
transaction.Rollback();
result = false;
}
}
else
{
result = false;
}
return(result);
}
public bool CreateAsset(AssetViewModel obj)
{
bool result;
IDbContextTransaction transaction = _context.Database.BeginTransaction();
if (obj != null)
{
try
{
obj.No = _asset.GetLastNumberAsset();
obj.SubCategory = _generatecode.SubCategoryAsset(obj.CategoryCD);
obj.Number = _generatecode.Number(obj.No);
obj.Code = _generatecode.GenerateCode(obj.CompanyCode, obj.ApplicationCode, obj.MainCategory, obj.SubCategory, obj.Number);
Asset asset = new Asset();
asset.ID = obj.ID;
asset.Code = obj.Code;
asset.Description = obj.Description;
asset.No = obj.Number;
asset.Name = obj.Name;
asset.IsMovable = obj.IsMovable;
asset.Owner = obj.Owner;
asset.PurchaseDate = Convert.ToDateTime(obj.PurchaseDate).ToString("ddMMyyyy");
asset.PurchasePrice = obj.PurchasePrice;
asset.DepreciationDuration = obj.DepreciationDuration != null?Convert.ToDateTime(obj.DepreciationDuration).ToString("ddMMyyyy") : null;
asset.DisposedDate = obj.DisposedDate != null?Convert.ToDateTime(obj.DisposedDate).ToString("ddMMyyyy") : null;
asset.ManufactureDate = Convert.ToDateTime(obj.ManufactureDate).ToString("ddMMyyyy");
asset.CategoryCD = obj.CategoryCD;
asset.StatusCD = obj.StatusCD;
asset.CreatedDate = DateTime.Now.Date.ToString("ddMMyyyy");
asset.CreatedBy = obj.CreatedBy;
_context.Asset.Add(asset);
_context.SaveChanges();
transaction.Commit();
result = true;
}
catch (Exception ex)
{
transaction.Rollback();
result = false;
}
}
else
{
result = false;
}
return(result);
}
public ResultViewModel CreateMovementRequest(MovementRequestViewModel obj)
{
ResultViewModel result = new ResultViewModel();
IDbContextTransaction transaction = _context.Database.BeginTransaction();
if (obj != null)
{
try
{
MovementRequest movement = new MovementRequest();
movement.MovementDate = obj.MovementRequest.MovementDate.Replace("/", string.Empty);
movement.Description = obj.MovementRequest.Description;
movement.LocationID = obj.MovementRequest.LocationID;
movement.ApprovalStatus = Convert.ToInt16(obj.MovementRequest.ApprovalStatus);
movement.CreatedDate = obj.CreatedDate;//DateTime.Now;
movement.CreatedBy = obj.CreatedBy;
movement.Notes = obj.MovementRequest.Notes;
foreach (var item in obj.MovementRequestDetail)
{
MovementRequestDetail detail = new MovementRequestDetail();
detail.Description = item.Description;
detail.AssetCategoryCD = item.AssetCategoryCD;
detail.Quantity = item.Quantity;
detail.RequestedTo = item.RequestTo;
detail.CreatedDate = movement.CreatedDate;
detail.CreatedBy = movement.CreatedBy;
movement.MovementRequestDetail.Add(detail);
}
_context.MovementRequest.Add(movement);
_context.SaveChanges();
transaction.Commit();
result.status = true;
result.movementRequest = GetMovementRequestByID(movement.ID);
}
catch (Exception ex)
{
transaction.Rollback();
result.status = false;
result.movementRequest = null;
}
}
else
{
result.status = false;
result.movementRequest = null;
}
return(result);
}
public bool MoveAsset(AssetViewModel obj)
{
bool result;
IDbContextTransaction transaction = _context.Database.BeginTransaction();
if (obj != null)
{
try
{
var location = _location.GetLocationByCode(obj.location);
if (obj.listAsset != null)
{
foreach (var item in obj.listAsset)
{
AssetLocation assetlocationobj = new AssetLocation();
var date = DateTime.Now;
var asset = _asset.GetAssetInfoByCode(item);
assetlocationobj.AssetID = asset.ID;
assetlocationobj.LocationID = location.ID;
assetlocationobj.OnTransition = false;
assetlocationobj.CreatedDate = date.Date.ToString("ddMMyyyy");
assetlocationobj.CreatedBy = obj.CreatedBy;
assetlocationobj.MovementRequestDetailID = null;
_context.AssetLocation.Add(assetlocationobj);
_context.SaveChanges();
}
transaction.Commit();
result = true;
}
else
{
result = false;
}
}
catch (Exception ex)
{
transaction.Rollback();
result = false;
}
}
else
{
result = false;
}
return(result);
}
public bool CreateAsset(Asset obj)
{
bool result;
IDbContextTransaction transaction = _context.Database.BeginTransaction();
if (obj != null)
{
try
{
Asset asset = new Asset();
asset.ID = obj.ID;
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.CreatedDate = DateTime.Now.Date.ToString("ddMMyyyy");
asset.CreatedBy = obj.CreatedBy;
_context.Asset.Add(asset);
_context.SaveChanges();
transaction.Commit();
result = true;
}
catch (Exception ex)
{
transaction.Rollback();
result = false;
}
}
else
{
result = false;
}
return(result);
}
public bool CreateLocation(LocationViewModel obj)
{
bool result;
IDbContextTransaction transaction = _context.Database.BeginTransaction();
if (obj != null)
{
try
{
obj.No = _location.GetLastNumberLocation();
obj.SubCategory = _generatecode.SubCategoryLocation(obj.LocationTypeCD, obj.Floor);
obj.Number = _generatecode.Number(obj.No);
obj.Code = _generatecode.GenerateCode(obj.CompanyCode, obj.ApplicationCode, obj.MainCategory, obj.SubCategory, obj.Number);
Location location = new Location();
location.Code = obj.Code;
location.Description = obj.Description;
location.No = obj.Number;
location.Name = obj.Name;
location.Floor = obj.Floor;
location.LocationTypeCD = obj.LocationTypeCD;
location.StatusCD = obj.StatusCD;
location.CreatedBy = obj.CreatedBy;
location.CreatedDate = DateTime.Now.Date.ToString("ddMMyyyy");
_context.Location.Add(location);
_context.SaveChanges();
transaction.Commit();
result = true;
}
catch (Exception ex)
{
transaction.Rollback();
result = false;
}
}
else
{
result = false;
}
return(result);
}
public bool CreateLocation(Location obj)
{
bool result;
IDbContextTransaction transaction = _context.Database.BeginTransaction();
if (obj != null)
{
try
{
Location location = new Location();
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.CreatedBy = obj.CreatedBy;
location.CreatedDate = DateTime.Now.Date.ToString("ddMMyyyy");
_context.Location.Add(location);
_context.SaveChanges();
transaction.Commit();
result = true;
}
catch (Exception ex)
{
transaction.Rollback();
result = false;
}
}
else
{
result = false;
}
return(result);
}
public ResultViewModel OpnameAsset(AssetOpnameTransactionViewModel obj)
{
ResultViewModel result = new ResultViewModel();
List <AssetOpnameTransaction> assetopname = new List <AssetOpnameTransaction>();
IDbContextTransaction transaction = _context.Database.BeginTransaction();
if (obj != null)
{
var listAsset = _context.Asset.Where(p => p.Code.Any(o => obj.AssetOpname.Contains(p.Code))).ToList();
if (listAsset != null)
{
if (listAsset.Count() == obj.AssetOpname.Count())
{
foreach (var item in listAsset.ToList())
{
var asset = obj.AssetIDList.Where(p => p == item.ID).FirstOrDefault();
if (asset != null)
{
AssetOpnameTransaction model = new AssetOpnameTransaction();
model.AssetID = item.ID;
model.LocationID = obj.LocationID;
model.CreatedDate = obj.CreatedDate;
model.RecordDate = obj.CreatedDate.Date.ToString("ddMMyyyy");
model.CreatedBy = obj.CreatedBy;
assetopname.Add(model);
listAsset.Remove(item);
}
}
foreach (var item in assetopname)
{
_context.AssetOpnameTransaction.Add(item);
_context.SaveChanges();
}
transaction.Commit();
result.status = true;
}
}
}
return(result);
}
public ResultViewModel MoveAsset(AssetViewModel obj)
{
ResultViewModel result = new ResultViewModel();
List <AssetLocation> listassetlocation = new List <AssetLocation>();
IDbContextTransaction transaction = _context.Database.BeginTransaction();
List <string> Asset = new List <string>();
List <string> Location = new List <string>();
List <string> NotAssetLocation = new List <string>();
if (obj != null)
{
try
{
foreach (var item in obj.listAsset)
{
char[] array = item.ToCharArray();
string data = "";
int i = 0;
foreach (var item2 in array)
{
i += 1;
if (i >= 5 && i <= 8)
{
data += item2;
}
}
if (data == "0101")
{
Asset.Add(item);
data = "";
}
else if (data == "0202")
{
Location.Add(item);
data = "";
}
else
{
NotAssetLocation.Add(item);
data = "";
}
if (NotAssetLocation.Count == 0)
{
if (Location.Count > 0 && Location.Count <= 1)
{
var location = _location.GetLocationByCode(Location[0]);
if (location.ID == obj.locationID)
{
var movementrequestdetail = _context.MovementRequestDetail.Where(p => p.ID == obj.MovementRequestDetailID).FirstOrDefault();
var movementrequest = _context.MovementRequest.Where(p => p.ID == movementrequestdetail.MovementRequestID).FirstOrDefault();
int totalmoved = 0;
var checkassetlocation = _context.AssetLocation.Where(p => p.MovementRequestDetailID == obj.MovementRequestDetailID && p.DeletedDate == null && p.LocationID != null).Count();
totalmoved = (movementrequestdetail.Quantity - checkassetlocation);
if (Asset.Count() <= totalmoved)
{
var listAsset = _context.Asset.Where(p => p.Code.Any(o => obj.listAsset.Contains(p.Code))).ToList();
if (listAsset != null)
{
if (listAsset.Count() == Asset.Count())
{
foreach (var asset in listAsset.ToList())
{
if (asset.CategoryCD == movementrequestdetail.AssetCategoryCD)
{
AssetLocation assetlocationobj = new AssetLocation();
assetlocationobj.AssetID = asset.ID;
assetlocationobj.LocationID = location.ID;
assetlocationobj.OnTransition = false;
assetlocationobj.CreatedDate = obj.CreatedDate;//DateTime.Now;
assetlocationobj.CreatedBy = obj.CreatedBy;
assetlocationobj.MovementRequestDetailID = obj.MovementRequestDetailID;
listassetlocation.Add(assetlocationobj);
listAsset.Remove(asset);
}
}
if (listAsset.Count() != 0)
{
result.status = false;
result.statuscode = 6;
result.asset = listAsset;
}
else
{
foreach (var items in listassetlocation)
{
_context.AssetLocation.Add(items);
_context.SaveChanges();
}
transaction.Commit();
result.status = true;
result.statuscode = 7;
}
}
else
{
result.status = false;
result.statuscode = 3;
}
}
else
{
result.status = false;
result.statuscode = 3;
}
}
else
{
result.status = false;
result.statuscode = 3;
}
}
else
{
result.status = false;
result.statuscode = 4;
}
}
else
{
result.status = false;
result.statuscode = 8;
}
}
else
{
result.status = false;
result.statuscode = 5;
}
}
}
catch (Exception ex)
{
result.status = false;
result.statuscode = 2;
result.message = ex.Message;
}
}
else
{
result.status = false;
result.statuscode = 1;
}
return(result);
}
public ResultViewModel MoveAsset(AssetViewModel obj)
{
ResultViewModel result = new ResultViewModel();
List <AssetLocation> listassetlocation = new List <AssetLocation>();
IDbContextTransaction transaction = _context.Database.BeginTransaction();
if (obj != null)
{
try
{
var location = _location.GetLocationByCode(obj.location);
var movementrequestdetail = _context.MovementRequestDetail.Where(p => p.ID == obj.MovementRequestDetailID).FirstOrDefault();
var movementrequest = _context.MovementRequest.Where(p => p.ID == movementrequestdetail.MovementRequestID).FirstOrDefault();
int totalmoved = 0;
var checkassetlocation = _context.AssetLocation.Where(p => p.MovementRequestDetailID == obj.MovementRequestDetailID && p.DeletedDate == null && p.LocationID != null).Count();
totalmoved = (movementrequestdetail.Quantity - checkassetlocation);
if (obj.listAsset.Count() <= totalmoved)
{
if (location.ID == movementrequest.LocationID)
{
var listAsset = _context.Asset.Where(p => p.Code.Any(o => obj.listAsset.Contains(p.Code))).ToList();
if (listAsset != null)
{
if (listAsset.Count() == obj.listAsset.Count())
{
foreach (var item in listAsset.ToList())
{
if (item.CategoryCD == movementrequestdetail.AssetCategoryCD)
{
AssetLocation assetlocationobj = new AssetLocation();
assetlocationobj.AssetID = item.ID;
assetlocationobj.LocationID = location.ID;
assetlocationobj.OnTransition = false;
assetlocationobj.CreatedDate = DateTime.Now.ToString("ddMMyyyy");
assetlocationobj.CreatedBy = obj.CreatedBy;
assetlocationobj.MovementRequestDetailID = obj.MovementRequestDetailID;
listassetlocation.Add(assetlocationobj);
listAsset.Remove(item);
}
}
if (listAsset.Count() != 0)
{
result.status = false;
result.statuscode = 6;
result.asset = listAsset;
}
else
{
foreach (var item in listassetlocation)
{
_context.AssetLocation.Add(item);
_context.SaveChanges();
}
transaction.Commit();
result.status = true;
result.statuscode = 7;
}
}
else
{
result.status = false;
result.statuscode = 5;
result.asset = listAsset;
}
}
else
{
result.status = false;
result.statuscode = 5;
result.asset = listAsset;
}
}
else
{
result.status = false;
result.statuscode = 4;
}
}
else
{
result.status = false;
result.statuscode = 3;
}
}
catch (Exception ex)
{
result.status = false;
result.statuscode = 2;
result.message = ex.Message;
}
}
else
{
result.status = false;
result.statuscode = 1;
}
return(result);
}
