/// <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)); }