public static AssetMaster RegisterAssetMaster(AssetMaster assetMaster)
{
try
{
using Repository <AssetMaster> repo = new Repository <AssetMaster>();
var record = ((from asiacc in repo.AssetMaster select asiacc.Code).ToList()).ConvertAll <Int64>(Int64.Parse).OrderByDescending(x => x).FirstOrDefault();
if (record != 0)
{
// noSeries.Code = (int.Parse(lstrcd.Code) + 1).ToString();
assetMaster.Code = (record + 1).ToString();
}
else
{
assetMaster.Code = "1";
}
assetMaster.Active = "Y";
repo.AssetMaster.Add(assetMaster);
if (repo.SaveChanges() > 0)
{
return(assetMaster);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
public IActionResult UpdateAssetMaster([FromBody] AssetMaster assetMaster)
{
if (assetMaster == null)
{
return(BadRequest($"{nameof(assetMaster)} cannot be null"));
}
try
{
var result = AssetHelper.UpdateAssetMaster(assetMaster);
APIResponse apiResponse;
if (result != null)
{
apiResponse = new APIResponse()
{
status = APIStatus.PASS.ToString(), response = result
};
}
else
{
apiResponse = new APIResponse()
{
status = APIStatus.FAIL.ToString(), response = "Updation Failed."
};
}
return(Ok(apiResponse));
}
catch (Exception ex)
{
return(Ok(new APIResponse()
{
status = APIStatus.FAIL.ToString(), response = ex.Message
}));
}
}
public IHttpActionResult PostAssetMaster(AssetMaster assetMaster)
{
db.AssetMasters.Add(assetMaster);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = assetMaster.am_id }, assetMaster));
}
public IHttpActionResult PutAssetMaster(int id, AssetMaster assetMaster)
{
if (id != assetMaster.am_id)
{
return(BadRequest());
}
db.Entry(assetMaster).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!AssetMasterExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult GetAssetMaster(int id)
{
AssetMaster assetMaster = db.AssetMasters.Find(id);
if (assetMaster == null)
{
return(NotFound());
}
return(Ok(assetMaster));
}
public IHttpActionResult DeleteAssetMaster(int id)
{
AssetMaster assetMaster = db.AssetMasters.Find(id);
if (assetMaster == null)
{
return(NotFound());
}
db.AssetMasters.Remove(assetMaster);
db.SaveChanges();
return(Ok(assetMaster));
}
public IHttpActionResult PostAssetMaster(AssetMaster assetMaster)
{
for (int i = 0; i < count; i++)
{
int min = 1000;
int max = 9999;
Random rdm = new Random();
int id = rdm.Next(min, max);
assetMaster.am_snumber = id.ToString();
db.AssetMasters.Add(assetMaster);
db.SaveChanges();
}
return(CreatedAtRoute("DefaultApi", new { id = assetMaster.am_id }, assetMaster));
}
//public async Task<IActionResult> CreateAsset([Bind("Id,FG_Code,AssetCategory,AssetType,ControllerType," +
// "Controllers,Trays,TraySize,Handed,Format,Power,Elements,kWh_Rating_Element,LightType,Lights,kWh_Rating_Light,Fans," +
// "kWh_Rating_Fan,kWh_Rating_Damper,kWh_Rating_WaterSolenoid")] AssetMaster assetMaster)
public async Task <IActionResult> CreateAsset([Bind("Id,FG_Code,AssetCategory,AssetType,ControllerType," +
"Controllers,Trays,TraySize,Handed,Format,Power,Elements,kWh_Rating_Element,LightType,Lights,kWh_Rating_Light,Fans," +
"kWh_Rating_Fan,kWh_Rating_Damper,kWh_Rating_WaterSolenoid,CreatedBy,modifiedby")] AssetMaster assetMaster)
{
if (ModelState.IsValid)
{
var user = _userManager.GetUserId(User);
// var userName = _context.Users.Where(x => x.Id == user).Select(x => x.FirstName + " " + x.LastName).FirstOrDefault();
var userName = _context.Users.Where(x => x.Id == user).Select(x => x.Id).FirstOrDefault();
assetMaster.CreatedBy = userName;
_context.Add(assetMaster);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(AssetsList)));
}
return(View(assetMaster));
}
public static AssetMaster UpdateAssetMaster(AssetMaster assetMaster)
{
try
{
using Repository <AssetMaster> repo = new Repository <AssetMaster>();
repo.AssetMaster.Update(assetMaster);
if (repo.SaveChanges() > 0)
{
return(assetMaster);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
public IActionResult RegisterAssetMaster([FromBody] AssetMaster assetMaster)
{
try
{
APIResponse apiResponse = null;
if (AssetHelper.GetList(assetMaster.AssetNo) != null)
{
return(Ok(new APIResponse()
{
status = APIStatus.FAIL.ToString(), response = $"AssetNo ={assetMaster.AssetNo} Aready Exists."
}));
}
var result = AssetHelper.RegisterAssetMaster(assetMaster);
if (result != null)
{
apiResponse = new APIResponse()
{
status = APIStatus.PASS.ToString(), response = result
};
}
else
{
apiResponse = new APIResponse()
{
status = APIStatus.FAIL.ToString(), response = "Registration Failed."
};
}
return(Ok(apiResponse));
}
catch (Exception ex)
{
return(Ok(new APIResponse()
{
status = APIStatus.FAIL.ToString(), response = ex.Message
}));
}
}
public Message Assign(AssetMaster objUI)
{
Message msg = null;
try
{
AssetMaster objDb = GetById(objUI.ID.ToString());
if (objDb != null)
{
Assign(objUI, objDb, ref msg);
}
else
{
msg = new Message(MessageConstants.E0040, MessageType.Error, "Asset '" + objUI.ID + "'");
}
}
catch (Exception)
{
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
//[ValidateAntiForgeryToken]
public async Task <IActionResult> EditAsset(int id, [Bind("Id,FG_Code,AssetCategory,AssetType,ControllerType,Controllers,Trays,TraySize,Handed,Format,Power,Elements,kWh_Rating_Element,LightType,Lights,kWh_Rating_Light,Fans," +
"kWh_Rating_Fan,kWh_Rating_Damper,kWh_Rating_WaterSolenoid,modifiedby,CreatedBy")] AssetMaster assetMaster)
//public async Task<IActionResult> EditAsset(int id, [Bind("Id,FG_Code,AssetCategory,AssetType,ControllerType,Controllers,Trays,TraySize,Handed,Format,Power")] AssetMaster assetMaster)
{
if (id != assetMaster.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
var user = _userManager.GetUserId(User);
// var userName = _context.Users.Where(x => x.Id == user).Select(x => x.FirstName + " " + x.LastName).FirstOrDefault();
var userName = _context.Users.Where(x => x.Id == user).Select(x => x.Id).FirstOrDefault();
assetMaster.modifiedby = userName;
_context.Update(assetMaster);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AssetMasterExists(assetMaster.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(AssetsList)));
}
return(View(assetMaster));
}
private void ReAssign(AssetMaster objUI, AssetMaster objDb, ref Message msg)
{
if (IsDBChanged(objUI, objDb))
{
if (!IsDublicateAssetId(objUI))
{
objDb.AssetID = objDb.AssetID;
objDb.CategoryId = objDb.CategoryId;
objDb.StatusId = Constants.ASSIGN_ASSET_AVAILABLE_STATUS;
objDb.EmployeeId = Constants.ASSIGN_ASSET_EMPLOYEE_NULL;
objDb.Remark = objDb.Remark;
objDb.IsActive = objDb.IsActive;
objDb.UpdateDate = DateTime.Now;
objDb.UpdatedBy = objDb.UpdatedBy;
dbContext.SubmitChanges();
}
}
}
public Message Insert(AssetMaster objUI)
{
Message msg = null;
try
{
if (!IsDublicateAssetId(objUI))
{
dbContext.AssetMasters.InsertOnSubmit(objUI);
dbContext.SubmitChanges();
msg = new Message(MessageConstants.I0001, MessageType.Info, "Asset Master '" + objUI.AssetID + "'", "added");
}
else
{
msg = new Message(MessageConstants.E0020, MessageType.Error, "Name '" + objUI.AssetID + "'", "Asset Master");
}
}
catch (Exception)
{
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
private void Assign(AssetMaster objUI, AssetMaster objDb, ref Message msg)
{
if (IsDBChanged(objUI, objDb))
{
if (!IsDublicateAssetId(objUI))
{
objDb.AssetID = objDb.AssetID;
objDb.CategoryId = objDb.CategoryId;
objDb.StatusId = Constants.ASSIGN_ASSET_INUSE_STATUS;
objDb.EmployeeId = (String.IsNullOrEmpty(objUI.EmployeeId)) ? null : objUI.EmployeeId; ;
objDb.Remark = objDb.Remark;
objDb.IsActive = objDb.IsActive;
objDb.UpdateDate = DateTime.Now;
objDb.UpdatedBy = objDb.UpdatedBy;
dbContext.SubmitChanges();
}
}
}
/// <summary>
/// Add and Edit Document
/// </summary>
/// <param name="data"></param>
/// <param name="userId"></param>
/// <returns></returns>
public CommonResponseWithIds AddAndEditAsset(AssetCustom data, long userId = 0)
{
CommonResponseWithIds obj = new CommonResponseWithIds();
try
{
var res = db.AssetMaster.Where(m => m.AssetId == data.assetId).FirstOrDefault();
if (res == null)
{
try
{
AssetMaster item = new AssetMaster();
item.AssetName = data.assetName;
item.AssetDescription = data.assetDescription;
item.AssetDocumentUploadedId = data.assetDocumentUploadedId;
item.BarcodeAllocatedNumber = data.barcodeAllocatedNumber;
item.LineNumber = data.lineNumber;
item.IsActive = true;
item.IsDeleted = false;
item.CreatedBy = userId;
item.CreatedOn = DateTime.Now;
db.AssetMaster.Add(item);
db.SaveChanges();
obj.response = ResourceResponse.AddedSucessfully;
obj.isStatus = true;
obj.id = item.AssetId;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
else
{
try
{
res.AssetName = data.assetName;
res.AssetDescription = data.assetDescription;
res.AssetDocumentUploadedId = data.assetDocumentUploadedId;
res.BarcodeAllocatedNumber = data.barcodeAllocatedNumber;
res.LineNumber = data.lineNumber;
res.ModifiedBy = userId;
res.ModifiedOn = DateTime.Now;
db.SaveChanges();
obj.id = res.AssetId;
obj.response = ResourceResponse.UpdatedSucessfully;
obj.isStatus = true;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
return(obj);
}
private void Delete(AssetMaster objUI)
{
if (objUI != null)
{
// Get current group in dbContext
AssetMaster objDb = GetById(objUI.ID.ToString());
if (objDb != null)
{
// Set delete info
objDb.DeleteFlag = true;
objDb.UpdateDate = DateTime.Now;
objDb.UpdatedBy = objUI.UpdatedBy;
// Submit changes to dbContext
dbContext.SubmitChanges();
}
}
}
private bool IsDBChanged(AssetMaster objUI, AssetMaster objDb)
{
bool isChannged = true;
if (objDb.UpdateDate.ToString() == objUI.UpdateDate.ToString())
{
isChannged = false;
}
return isChannged;
}
public Task <bool> UpdateAsync(AssetMasterVM entity)
{
return(Task.Run(() =>
{
if (entity.Asset_Base64_Photo != null)
{
string base64 = entity.Asset_Base64_Photo;
entity.Asset_Base64_Photo = String.Format(base64);
base64 = base64.Remove(0, base64.IndexOf("base64,") + 7);
entity.AssetPhoto = Convert.FromBase64String(base64);
}
AssetMaster assetMaster = new AssetMaster
{
ID = entity.ID,
Code = entity.Code,
ARName = entity.ARName,
LatName = entity.LatName,
AssetGroupID = entity.AssetGroupID,
AssetAccountID = entity.AssetAccountID,
AssetBrand = entity.AssetBrand,
AssetColor = entity.AssetColor,
AssetHeight = entity.AssetHeight,
AssetLocation = entity.AssetLocation,
AssetModel = entity.AssetModel,
AssetScreenNumber = entity.AssetScreenNumber,
AssetStatusID = entity.AssetStatusID,
AssetTypeID = entity.AssetTypeID,
AssetWeight = entity.AssetWeight,
AssetWidth = entity.AssetWidth,
Barcode = entity.Barcode,
ManufactureCompanyID = entity.ManufactureCompanyID,
OriginNationID = entity.OriginNationID,
SupplierCompanyID = entity.SupplierCompanyID,
DepreciationAccountID = entity.DepreciationAccountID,
TotalDepreciationAccountID = entity.TotalDepreciationAccountID,
ExpensesAccountID = entity.ExpensesAccountID,
CapitalProfitAccountID = entity.CapitalProfitAccountID,
CapitalLossAccountID = entity.CapitalLossAccountID,
AppraisalExcessAccountID = entity.AppraisalExcessAccountID,
ApprasialDeficitAccountID = entity.ApprasialDeficitAccountID,
AssetPhoto = entity.AssetPhoto,
AddedBy = entity.AddedBy,
AddedOn = entity.AddedOn,
UpdatedBy = entity.UpdatedBy,
UpdatedOn = DateTime.Now,
Notes = entity.Notes,
DepartmentID = entity.DepartmentID,
ManufactureDate = entity.ManufactureDate,
WarrantyNumber = entity.WarrantyNumber,
WarrantyStartDate = entity.WarrantyStartDate,
WarrantyEndDate = entity.WarrantyEndDate,
ReceivingDate = entity.ReceivingDate,
ReceivingNotes = entity.ReceivingNotes,
ContractNumber = entity.ContractNumber,
ContractDate = entity.ContractDate,
PurchasingDate = entity.PurchasingDate,
CustomsStatment = entity.CustomsStatment,
CustomsStatmentDate = entity.CustomsStatmentDate,
ShippingNumber = entity.ShippingNumber,
AssetShippingMethodID = entity.AssetShippingMethodID,
ShippingDate = entity.ShippingDate,
ImportLicenseNumber = entity.ImportLicenseNumber,
ShippingDestination = entity.ShippingDestination,
ShippingArrivalDate = entity.ShippingArrivalDate,
//Active = entity.Active,
//Position = entity.Position
};
assetMasterRepo.Update(assetMaster, assetMaster.ID);
AssetDepreciationDetails assetDepreciationDetails = new AssetDepreciationDetails
{
ID = entity.Depreciation.ID,
//Active = entity.Depreciation.Active,
AddedBy = entity.Depreciation.AddedBy,
AddedOn = entity.Depreciation.AddedOn,
AssetDepreciationTypeID = entity.Depreciation.AssetDepreciationTypeID,
//Position = entity.Depreciation.Position,
AssetLifeSpan = entity.Depreciation.AssetLifeSpan,
AssetLifeSpanUnitID = entity.Depreciation.AssetLifeSpanUnitID,
AssetMasterID = assetMaster.ID,
AssetScrapValue = entity.Depreciation.AssetScrapValue,
CurrencyID = entity.Depreciation.CurrencyID,
CurrencyRate = entity.Depreciation.CurrencyRate,
CurrentAssetValue = entity.Depreciation.CurrentAssetValue,
DepreciationStartDate = entity.Depreciation.DepreciationStartDate,
DepreciationTotals = entity.Depreciation.DepreciationTotals,
ExclusionsValue = entity.Depreciation.ExclusionsValue,
ExtraValue = entity.Depreciation.ExtraValue,
InitialAssetScrapValue = entity.Depreciation.InitialAssetScrapValue,
Notes = entity.Depreciation.Notes,
NotSubjectToDepreciation = entity.Depreciation.NotSubjectToDepreciation,
NotSubjectToRevaluation = entity.Depreciation.NotSubjectToRevaluation,
UpdatedBy = entity.Depreciation.UpdatedBy,
UpdatedOn = DateTime.Now
};
AssetDepreciationDetailsRepo.Update(assetDepreciationDetails, assetDepreciationDetails.ID);
return true;
}));
}
private void Update(AssetMaster objUI, AssetMaster objDb, ref Message msg)
{
if (!IsDBChanged(objUI, objDb))
{
if (!IsDublicateAssetId(objUI))
{
objDb.AssetID = objUI.AssetID;
objDb.CategoryId = objUI.CategoryId;
objDb.StatusId = objUI.StatusId;
objDb.EmployeeId = (String.IsNullOrEmpty(objUI.EmployeeId)) ? null : objUI.EmployeeId;
objDb.Remark = objUI.Remark;
objDb.IsActive = objUI.IsActive;
objDb.UpdateDate = DateTime.Now;
objDb.UpdatedBy = objUI.UpdatedBy;
dbContext.SubmitChanges();
msg = new Message(MessageConstants.I0001, MessageType.Info, "Asset Master '" + objUI.AssetID + "'", "updated");
}
else
{
msg = new Message(MessageConstants.E0020, MessageType.Error, "'" + objUI.AssetID + "'", "Asset Property");
}
}
else
{
msg = new Message(MessageConstants.E0025, MessageType.Error, "Asset Master'" + objDb.AssetID + "'");
}
}
private bool IsDublicateAssetId(AssetMaster objUI)
{
bool isDublicateName = true;
AssetMaster dublicateName = dbContext.AssetMasters.Where(a => a.AssetID.Equals(objUI.AssetID) && a.DeleteFlag == false).FirstOrDefault<AssetMaster>();
if (dublicateName == null || dublicateName.ID == objUI.ID)
{
isDublicateName = false;
}
return isDublicateName;
}
