/// <summary>
/// Deletes Working Accessories
/// </summary>
/// <param name="wavm">WorkingAccessoriesViewModel object</param>
/// <param name="UserId">User ID</param>
/// <param name="Username">Username</param>
/// <param name="CreatedDate">Created Date</param>
/// <returns>Rollback Flag 1 or 0</returns>
public int DeleteWorkingAccessories(WorkingAccessoriesViewModel wavm, long UserId, string Username, DateTime CreatedDate)
{
var rollbackFlag = 0;
using (SqlConnection con = new SqlConnection(TableConstant.CONNECTION_STRING))
{
using (SqlCommand cmd = new SqlCommand("dbo.usp_DeleteWorkingAccessories"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.AddWithValue("@WorkingAccessoriesId", wavm.Id);
cmd.Parameters.AddWithValue("@AssetName", wavm.AssetName);
cmd.Parameters.AddWithValue("@PurchaseNo", wavm.PurchaseNo);
cmd.Parameters.AddWithValue("@Username", Username);
cmd.Parameters.AddWithValue("@UserId", UserId);
cmd.Parameters.AddWithValue("@CreatedDate", CreatedDate);
var returnParameter = cmd.Parameters.Add("@RollBackFlag", SqlDbType.Int);
returnParameter.Direction = ParameterDirection.ReturnValue;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
rollbackFlag = (int)returnParameter.Value;
}
}
return(rollbackFlag);
}
/// <summary>
/// Updates Working Accessories info (Description only)
/// </summary>
/// <param name="wavm">Working Accessories ViewModel</param>
public void UpdateWorkingAccessories(WorkingAccessoriesViewModel wavm)
{
//Update Working Accessories
string UpdateQuery = String.Format(
@" UPDATE {0} SET Description = '{1}'
WHERE Id = {2}",
TableConstant.TBL_ACTIVE_ITEM,
wavm.Description,
wavm.Id
);
ado.ExecNonQuery(UpdateQuery);
}
public ActionResult ActiveAssetCost()
{
ViewBag.Title = Constant.ACTIVE_ASSET_COST;
var aacVm = new ActiveAssetCostViewModel();
var workingAccessories = _repActiveAsset.GetWorkingAccessories();
decimal totalActiveAssetCurrentValue = 0;
var activeAssetPurchaseCostList = new List <decimal>();
var totalActiveAssetCurrentValueList = new List <decimal>();
var AssetNameList = new List <string>();
foreach (var item in workingAccessories)
{
var scrapItem = _repAsset.GetScrap().Where(x => x.PurchaseNo == item.PurchaseNo).SingleOrDefault();
if (scrapItem == null)
{
var wavm = new WorkingAccessoriesViewModel()
{
Id = item.Id,
AssetPurchaseId = item.AssetPurchaseId,
PurchaseNo = item.PurchaseNo,
AssetName = item.AssetName,
AssetCategory = item.AssetCategory,
Description = item.Description
};
AssetNameList.Add(String.Concat(item.AssetName, " (", item.PurchaseNo, ")"));
totalActiveAssetCurrentValueList.Add(Decimal.Parse(CurrentItemValue.GetCurrentValue(item.AssetPurchaseId).ToString("#.##")));
var purchaseCost = _repPurchaseAsset.GetAssetPurchaseDetails()
.Where(x => x.Id == item.AssetPurchaseId)
.SingleOrDefault().PricePerUnit;
activeAssetPurchaseCostList.Add(purchaseCost);
totalActiveAssetCurrentValue += Decimal.Parse(CurrentItemValue.GetCurrentValue(item.AssetPurchaseId).ToString("#.##"));
}
}
aacVm.AssetNameList = AssetNameList.ToArray();
aacVm.AssetCostList = activeAssetPurchaseCostList.ToArray();
aacVm.TotalAssetCurrentValue = totalActiveAssetCurrentValueList.ToArray();
return(View(aacVm));
}
