public ActionResult UpdateLaborInfoItem(string flagval, int?ViewID, int?StageID, bool?LaborTax, decimal?Hours) { if (flagval == "2") { var stageinfo = db.GetStageMasterEditInfoByID(StageID).FirstOrDefault(); if (stageinfo != null) { var subLabors = db.GetSubLaborInfoByMasterStageID(stageinfo.StageMasterID).ToList(); var Labors = new StageModels.StageMasterEdit(); foreach (var sub in subLabors) { Labors.StageSubDetails.Add(new StageModels.StageDetails() { StageMasterID = stageinfo.StageMasterID, SubStageID = sub.SubID, SubName = sub.SubStage, CostPerHour = sub.Cost, PricePerHour = sub.Price, Percent = sub.Factor, SellPerHour = sub.Sell }); } ViewBag.Labors = Labors; return(PartialView("_ItemLaborPartial", Labors)); } } else { db.UpdateItemLabor(ViewID, StageID, DateTime.Now.Date, Hours); db.SaveChanges(); return(Json(new { status = "success", ViewID = ViewID })); } return(Json(new { status = "ERROR" })); }
public ActionResult Edit(StageModels.StageMasterEdit Model) { var errorList = new List <string>(); if (ModelState.IsValid) { var stageMaster = new CoStagesMaster() { StageMasterID = Model.StageMasterID, SiteCoID = siteusercompanyid, StageOrder = Model.Order, CostCodeID = Model.CostCodeId, StageMiscEquipAdjt = Model.MiscEquip, StageMiscPartsAdjt = Model.MiscParts }; repo.UpdateStageMaster(stageMaster); foreach (var price in Model.StageSubDetails) { // price.Percent = price.Percent / 100; var stagePricing = new CoStagesPricing() { StageMasterID = price.StageMasterID, StageSubID = price.SubStageID ?? 0, StageLaborCost = price.CostPerHour, StageLaborPrice = price.PricePerHour, StageLaborFactor = price.Percent / 100 }; repo.UpdateStagePricing(stagePricing); } return(Json(new { status = "success" })); } errorList.AddRange((from item in ModelState.Values from error in item.Errors select error.ErrorMessage).ToList() ); return(Json(new { status = "error", errors = errorList })); }
public ActionResult Edit(int id)//stage master id { var stage = db.GetStageMasterEditInfoByID(id).FirstOrDefault(); if (stage == null) { return(HttpNotFound()); } var subLabors = db.GetSubLaborInfoByMasterStageID(id).ToList(); var model = new StageModels.StageMasterEdit() { CostCodeId = stage.CostCodeID, MiscEquip = stage.MiscEqp, MiscParts = stage.MiscParts, Order = stage.Order, StageMasterID = stage.StageMasterID, StageName = stage.Stage, }; foreach (var sub in subLabors) { model.StageSubDetails.Add(new StageModels.StageDetails() { StageMasterID = id, SubStageID = sub.SubID, SubName = sub.SubStage, CostPerHour = sub.Cost, PricePerHour = sub.Price, Percent = sub.Factor, SellPerHour = sub.Sell }); } ViewBag.CostCodes = new SelectList(db.GetCoCostCodesBySiteCoID(siteusercompanyid).ToList(), nameof(GetCoCostCodesBySiteCoID_Result.CostCodeID), nameof(GetCoCostCodesBySiteCoID_Result.CostCode)); return(View(model)); }
public ActionResult Details(int?id) { var data = db.GetItemInfoByMasterItemID(id).FirstOrDefault(); if (data.Vendor != null) { ViewBag.Vendors = new SelectList(db.GetVendorsBySiteCoID(base.siteusercompanyid).ToList(), nameof(GetVendorsBySiteCoID_Result.ViewID), nameof(GetVendorsBySiteCoID_Result.Vendor), data.Vendor); } else { ViewBag.Vendors = new SelectList(db.GetVendorsBySiteCoID(base.siteusercompanyid).ToList(), nameof(GetVendorsBySiteCoID_Result.ViewID), nameof(GetVendorsBySiteCoID_Result.Vendor)); } ViewBag.SalesUom = new SelectList(db.GetSiteDataUom().ToList(), nameof(GetSiteDataUom_Result.ViewID), nameof(GetSiteDataUom_Result.Uom), data.SaleUom); ViewBag.OrderUom = new SelectList(db.GetSiteDataUom().ToList(), nameof(GetSiteDataUom_Result.ViewID), nameof(GetSiteDataUom_Result.Uom), data.OrderUom); ViewBag.CostCodes = new SelectList(db.GetCoCostCodesBySiteCoID(siteusercompanyid).ToList(), nameof(GetCoCostCodesBySiteCoID_Result.CostCodeID), nameof(GetCoCostCodesBySiteCoID_Result.CostCode)); var projectID = db.ProjectItems.Where(p => p.MasterItemID == id).Select(p => p.ProjectID).FirstOrDefault(); ViewBag.CoStages = new SelectList(db.GetMasterStagesBySiteID(siteusercompanyid).ToList(), nameof(GetMasterStagesBySiteID_Result.ViewID), nameof(GetMasterStagesBySiteID_Result.Stage)); var stage = db.GetStageMasterEditInfoByID(data.StageID).FirstOrDefault(); if (stage != null) { var subLabors = db.GetSubLaborInfoByMasterItemID(id).ToList(); var Labors = new StageModels.StageMasterEdit(); if (subLabors != null) { foreach (var sub in subLabors) { Labors.StageSubDetails.Add(new StageModels.StageDetails() { StageMasterID = stage.StageMasterID, SubStageID = sub.SubID, SubName = sub.SubStage, CostPerHour = sub.Cost, PricePerHour = sub.Price, Percent = sub.Factor, SellPerHour = sub.Sell }); } } ViewBag.Labors = Labors; } if (data == null) { return(HttpNotFound()); } else { ViewBag.AcctItemID = data.AcctItemID; } int siteCoID = base.siteusercompanyid; qbModels = new QBModels(); qbModels.SyncObjectsModel = new QBSyncdto(); qbModels.OAuthorizationModel = new QBAuthorizationdto(); qbModels.IsReadySync = false; var oAuthModel = new QBOAuthService(qbModels.OAuthorizationModel).IsTokenAvailable(this, siteusercompanyid); if (oAuthModel.IsConnected) { qbModels.IsReadySync = true; qbModels.OAuthorizationModel = oAuthModel; qbModels.IsConnected = oAuthModel.IsConnected; var syncService = new QBSyncService(oAuthModel); qbModels.SyncObjectsModel.OauthToken = oAuthModel; qbModels.SyncObjectsModel.CompanyId = oAuthModel.Realmid; Random random = new Random(); qbModels.SyncObjectsModel = Save(this, qbModels.SyncObjectsModel); SyncObjectsModelId = qbModels.SyncObjectsModel.Id; } return(View(data)); }
// GET: Common/Items/Short - this displays Items within a Project public ActionResult Short(int?id, int IsCorItem = 0) { if (IsCorItem == 1) { return(CorItemShort(id)); } var item = db.GetProjectItemInfoByItemID(id).FirstOrDefault(); if (item == null) { return(HttpNotFound()); } var projectID = db.ProjectItems.Where(p => p.ItemID == id).Select(p => p.ProjectID).FirstOrDefault(); var masterStageID = db.ProjectStages.Where(p => p.ProjectStageID == item.StageID).Select(p => p.StageMasterID).FirstOrDefault(); ViewBag.Areas = new SelectList(db.GetAreasByProjectID(projectID).ToList(), nameof(GetAreasByProjectID_Result.ViewID), nameof(GetAreasByProjectID_Result.Division), item.AreaID); ViewBag.Divisions = new SelectList(db.GetDivisionsByProjectID(projectID).ToList(), nameof(GetDivisionsByProjectID_Result.ViewID), nameof(GetDivisionsByProjectID_Result.Division), item.DivisionID); ViewBag.CoStages = new SelectList(db.GetMasterStagesBySiteID(siteusercompanyid).ToList(), nameof(GetMasterStagesBySiteID_Result.ViewID), nameof(GetMasterStagesBySiteID_Result.Stage)); ViewBag.ProjectStages = new SelectList(db.GetProjectStagesByProjectID(projectID).ToList(), nameof(GetProjectStagesByProjectID_Result.ProjectStageID), nameof(GetProjectStagesByProjectID_Result.StageName), item.StageID); ViewBag.ProjectID = repo.GetProjectIDByItemID(id ?? 0); var priceModel = new Models.ItemModels.EditShortItem.PriceModel() { ItemID = id, Qty = item.Qty, UnitCost = item.UnitCost, UnitPrice = item.UnitPrice, Extension = item.Extension, Margin = item.Margin, Markup = item.Markup, Tax = item.Tax, Taxable = item.Taxable ?? false, Total = item.Total, ExcludePOR = item.ExcludePor ?? false, WarranteePart = item.WarranteePart ?? false, OneOffItem = item.OneOffItem ?? false }; var itemDetails = new ItemModels.ItemDetails() { ViewID = item.ViewID, Label = item.Label, ProductDescription = item.ProductDescription, SalesDescription = item.SalesDescription, AreaID = item.AreaID, Area = item.Area, DivisionID = item.DivisionID, Division = item.Division, Por_ = item.Por_, CustodyID = item.CustodyID, Custody = item.Custody, Qty = item.Qty, ProjectCostCodeID = item.ProjectCostCodeID, CostCode = item.CostCode, UnitCost = item.UnitCost, UnitPrice = item.UnitPrice, Extension = item.Extension, Margin = item.Margin, Markup = item.Markup, Tax = item.Tax, TaxRate = item.TaxRate, Taxable = item.Taxable, Total = item.Total, ExcludePor = item.ExcludePor, WarranteePart = item.WarranteePart, OneOffItem = item.OneOffItem, StageID = item.StageID, Stage = item.Stage, Hours = item.Hours, ProjectTotalHours = item.ProjectTotalHours, }; ViewBag.Item = itemDetails; var model = new Models.ItemModels.EditShortItem() { Price = priceModel }; var subLabors = db.GetSubLaborInfoByProjectItemID(id, projectID, masterStageID).ToList(); var Labors = new StageModels.StageMasterEdit(); if (subLabors != null) { foreach (var sub in subLabors) { Labors.StageSubDetails.Add(new StageModels.StageDetails() { StageMasterID = (int)masterStageID, SubStageID = sub.ViewID, SubName = sub.SubName, CostPerHour = sub.LaborCost, PricePerHour = sub.LaborPrice, Percent = sub.LaborFactor, SellPerHour = sub.SellPrice }); } } ViewBag.Labors = Labors; return(View(model)); }