public JsonResult saveMaterialSize(CMaterialSize model) { string message = ""; string ErrMessage = ""; int ErrCode = 0; int materialSizeId = 0; if (Session["ident"] == null) { message = "identError"; } if (message == "") { string ident = Session["ident"].ToString(); SmManager.gMaterialSizeCL materialSize = new SmManager.gMaterialSizeCL(); CMaterialSize ms = new CMaterialSize(); Decimal materialLength = 0; Decimal materialWidth = 0; if (!ms.fromStrToDec(model.materialLength, ref materialLength)) { message = "Materiallängd felaktigt angiven"; } if (message == "") { if (!ms.fromStrToDec(model.materialWidth, ref materialWidth)) { message = "Materialbredd felaktigt angiven"; } } if (message == "") { materialSize.materialSizeId = model.materialSizeId; materialSize.materialId = model.materialId; materialSize.description = model.description; materialSize.sizeShort = model.sizeShort; materialSize.materialLength = materialLength; materialSize.materialWidth = materialWidth; materialSize.defaultVal = model.defaultVal; SmManager.SmManagerClient cl = new SmManager.SmManagerClient(); materialSize = cl.saveMaterialSize(ident, materialSize); ErrMessage = materialSize.ErrMessage; ErrCode = materialSize.ErrCode; materialSizeId = materialSize.materialSizeId; } } return(Json(new { message = message, errMessage = ErrMessage, errCode = ErrCode.ToString(), materialSizeId = materialSizeId }, JsonRequestBehavior.AllowGet)); }
public JsonResult saveReuseMat(CReuseMat model) { string message = ""; string ErrMessage = ""; int ErrCode = 0; int reuseMatId = 0; if (Session["ident"] == null) { message = "identError"; } if (message == "") { string ident = Session["ident"].ToString(); SmManager.gReuseMatCL reuseMat = new SmManager.gReuseMatCL(); CMaterialSize ms = new CMaterialSize(); Decimal minDiam = 0; Decimal reusePercentage = 0; if (!ms.fromStrToDec(model.minDiam, ref minDiam, 0.01M, 15000)) { message = "Min diameter felaktigt angiven"; } if (message == "") { if (!ms.fromStrToDec(model.reusePercentage, ref reusePercentage, 0, 99)) { message = "Återanvändbar procent felaktigt angiven"; } } if (message == "") { reuseMat.reuseMatId = model.reuseMatId; reuseMat.minDiam = minDiam; reuseMat.reusePercentage = reusePercentage; SmManager.SmManagerClient cl = new SmManager.SmManagerClient(); reuseMat = cl.saveReuseMaterial(ident, reuseMat); ErrMessage = reuseMat.ErrMessage; ErrCode = reuseMat.ErrCode; reuseMatId = reuseMat.reuseMatId; } } return(Json(new { message, errMessage = ErrMessage, errCode = ErrCode.ToString(), reuseMatId }, JsonRequestBehavior.AllowGet)); }
public ActionResult selectMaterialSize(int materialSizeId) { string errorTxt = ""; if (Session["ident"] == null) { RedirectToAction("Login", "Home"); } string ident = Session["ident"].ToString(); CMaterialSize model = new CMaterialSize(); SmManager.SmManagerClient cl = new SmManager.SmManagerClient(); if (materialSizeId > 0) { SmManager.gMaterialSizeCL[] materialSize = cl.getMaterialSize(ident, materialSizeId); if (materialSize.Length == 1) { if (materialSize[0].ErrCode != 0) { errorTxt = materialSize[0].ErrMessage; } else { model.materialSizeId = materialSize[0].materialSizeId; model.materialId = materialSize[0].materialId; model.description = materialSize[0].description; model.sizeShort = materialSize[0].sizeShort; model.materialLength = materialSize[0].materialLength.ToString(); model.materialWidth = materialSize[0].materialWidth.ToString(); model.defaultVal = materialSize[0].defaultVal; } } else { errorTxt = "Kan ej hitta vald materialstorlek"; } } // Get all material from db SmManager.gMaterialCL[] material = cl.getAllMaterial(ident); // Convert to a list List <SmManager.gMaterialCL> materialList = material.Cast <SmManager.gMaterialCL>().ToList(); // Sort that list by material materialList = materialList.OrderBy(x => x.material).ToList(); ViewBag.materialList = new SelectList(materialList, "materialId", "material"); ViewBag.errorTxt = errorTxt; return(View(model)); }
public JsonResult saveMaterialThickn(CMaterialThickn model) { string message = ""; string ErrMessage = ""; int ErrCode = 0; int materialThicknId = 0; if (Session["ident"] == null) { message = "identError"; } if (message == "") { string ident = Session["ident"].ToString(); SmManager.gMaterialThicknCL materialThickn = new SmManager.gMaterialThicknCL(); CMaterialSize ms = new CMaterialSize(); Decimal thickness = 0; Decimal buyPrice = 0; Decimal sellPrice = 0; Decimal cuttingTime = 0; if (!ms.fromStrToDec(model.thickness, ref thickness, 0.01M, 100)) { message = "Materialtjocklek felaktigt angiven"; } if (message == "") { if (!ms.fromStrToDec(model.buyPrice, ref buyPrice, 0.01M, 100000)) { message = "Inköpspris felaktigt angivet"; } } if (message == "") { if (!ms.fromStrToDec(model.sellPrice, ref sellPrice, 0.01M, 100000)) { message = "Försäljningspris felaktigt angivet"; } } if (message == "") { if (!ms.fromStrToDec(model.cuttingTime, ref cuttingTime, 0.01M, 100)) { message = "Skärtid felaktigt angiven"; } } if (message == "") { materialThickn.materialThicknId = model.materialThicknId; materialThickn.materialSizeId = model.materialSizeId; materialThickn.description = model.description; materialThickn.thicknShort = model.thicknShort; materialThickn.thickness = thickness; materialThickn.buyPrice = buyPrice; materialThickn.sellPrice = sellPrice; materialThickn.cuttingTime = cuttingTime; SmManager.SmManagerClient cl = new SmManager.SmManagerClient(); materialThickn = cl.saveMaterialThickness(ident, materialThickn); ErrMessage = materialThickn.ErrMessage; ErrCode = materialThickn.ErrCode; materialThicknId = materialThickn.materialThicknId; } } return(Json(new { message = message, errMessage = ErrMessage, errCode = ErrCode.ToString(), materialThicknId = materialThicknId }, JsonRequestBehavior.AllowGet)); }
public JsonResult saveGasket(CGasket model) { string message = ""; string ErrMessage = ""; int ErrCode = 0; int gasketId = 0; int gasketTypeId = 0; if (Session["ident"] == null) { message = "identError"; } if (message == "") { string ident = Session["ident"].ToString(); SmManager.gGasketCL gasket = new SmManager.gGasketCL(); CMaterialSize ms = new CMaterialSize(); Decimal outerDiam = 0; Decimal innerDiam = 0; Decimal reusableMaterial = 0; Decimal cuttingMargin = 0; Decimal handlingTime = 0; Decimal price = 0; Decimal Type2SecHoleDiam = 0; // 2019-09-05 Decimal Type3GasketLength = 0; Decimal Type3GasketWidth = 0; if (model.price == "") { model.price = "0"; } if (model.gasketTypeId == 1 || model.gasketTypeId == 2) { if (!ms.fromStrToDec(model.outerDiam, ref outerDiam, 0.01M, 100000)) { message = "Ytterdiameter måste vara större än 0 (och mindre än 100000)"; } } if (message == "") { if (!ms.fromStrToDec(model.innerDiam, ref innerDiam, 0.01M, 100000)) { message = "Innerdiameter måste vara större än 0 (och mindre än 100000)"; } } if (message == "" && (model.gasketTypeId == 1 || model.gasketTypeId == 2)) { if (innerDiam >= outerDiam) { message = "Innerdiameter måste vara mindre än ytterdiameter"; } } if (message == "") { if (!ms.fromStrToDec(model.reusableMaterial, ref reusableMaterial, 0, 95)) { message = "Återanvändbart material bör vara mellan 0 och 95%"; } } if (message == "") { if (!ms.fromStrToDec(model.cuttingMargin, ref cuttingMargin, 0, 100)) { message = "Felaktig skärmarginal"; } } if (message == "") { if (!ms.fromStrToDec(model.handlingTime, ref handlingTime, 0, 100000)) { message = "Felaktig hanteringstid"; } } if (message == "") { if (!ms.fromStrToDec(model.price, ref price, 0, 1000000)) { message = "Felaktigt pris"; } } if (message == "") { if (model.gasketTypeId == 2 && model.Type2SecHoleCount == 0) { message = "Antal yttre hål måste vara större än 0"; } } if (message == "") { if (model.gasketTypeId == 2 || (model.gasketTypeId == 3 && model.Type2SecHoleCount > 0)) { if (!ms.fromStrToDec(model.Type2SecHoleDiam, ref Type2SecHoleDiam, 0.01M, 100000)) { message = "Felaktigt angiven diameter på yttre hål"; } } } if (message == "") { if (model.gasketTypeId == 3) { if (!ms.fromStrToDec(model.Type3GasketLength, ref Type3GasketLength, 0.01M, 100000)) { message = "Packningens längd måste vara större än 0 (och mindre än 100000)"; } if (!ms.fromStrToDec(model.Type3GasketWidth, ref Type3GasketWidth, 0.01M, 100000)) { message = "Packningens bredd måste vara större än 0 (och mindre än 100000)"; } } } if (message == "" && model.gasketTypeId == 3) { if (Type3GasketLength <= innerDiam) { message = "Packningens längd måste vara större än innerdiametern"; } } if (message == "" && model.gasketTypeId == 3) { if (Type3GasketWidth <= innerDiam) { message = "Packningens bredd måste vara större än innerdiametern"; } } if (message == "") { gasket.gasketId = model.gasketId; gasket.gasketTypeId = model.gasketTypeId; gasket.materialThicknId = model.materialThicknId; gasket.outerDiam = outerDiam; gasket.innerDiam = innerDiam; gasket.reusableMaterial = reusableMaterial; gasket.cuttingMargin = cuttingMargin; gasket.standardPriceProduct = model.standardPriceProduct; gasket.handlingTime = handlingTime; gasket.Type2SecHoleCount = model.Type2SecHoleCount; gasket.Type2SecHoleDiam = Type2SecHoleDiam; // 2019-09-05 KJBO if (model.gasketTypeId == 3) { gasket.Type3GasketLength = Type3GasketLength; gasket.Type3GasketWidth = Type3GasketWidth; } gasket.price = price; gasket.note = model.note; gasket.description = model.description; SmManager.SmManagerClient cl = new SmManager.SmManagerClient(); gasket = cl.saveGasket(ident, gasket); ErrMessage = gasket.ErrMessage; ErrCode = gasket.ErrCode; gasketId = gasket.gasketId; gasketTypeId = gasket.gasketTypeId; } } return(Json(new { message = message, errMessage = ErrMessage, errCode = ErrCode.ToString(), gasketId = gasketId, gasketTypeId = gasketTypeId }, JsonRequestBehavior.AllowGet)); }
public JsonResult saveCost(CCost model) { string message = ""; string ErrMessage = ""; int ErrCode = 0; int workingCostId = 0; if (Session["ident"] == null) { message = "identErr"; } if (message == "") { string ident = Session["ident"].ToString(); SmManager.gWorkingCostCL workingCost = new SmManager.gWorkingCostCL(); CMaterialSize ms = new CMaterialSize(); Decimal cuttingHourNet = 0; Decimal cuttingHourSales = 0; Decimal handlingHourNet = 0; Decimal handlingHourSales = 0; Decimal cuttingMargin = 0; if (!ms.fromStrToDec(model.cuttingHourNet, ref cuttingHourNet, 0.01M, 100000)) { message = "Timdebitering skärtid netto utanför intervall"; } if (message == "") { if (!ms.fromStrToDec(model.cuttingHourSales, ref cuttingHourSales, 0.01M, 100000)) { message = "Timdebitering skärtid brutto utanför intervall"; } } if (message == "") { if (!ms.fromStrToDec(model.handlingHourNet, ref handlingHourNet, 0, 100000)) { message = "Timdebitering hantering netto utanför intervall"; } } if (message == "") { if (!ms.fromStrToDec(model.handlingHourSales, ref handlingHourSales, 0, 100000)) { message = "Timdebitering hantering brutto utanför intervall"; } } if (message == "") { if (!ms.fromStrToDec(model.cuttingMargin, ref cuttingMargin, 0, 1000)) { message = "Skärmarginal utanför intervall"; } } if (message == "") { workingCost.workingCostId = model.workingCostId; workingCost.cuttingHourNet = cuttingHourNet; workingCost.cuttingHourSales = cuttingHourSales; workingCost.handlingHourNet = handlingHourNet; workingCost.handlingHourSales = handlingHourSales; workingCost.cuttingMargin = cuttingMargin; SmManager.SmManagerClient cl = new SmManager.SmManagerClient(); workingCost = cl.saveWorkingCost(ident, workingCost); ErrMessage = workingCost.ErrMessage; ErrCode = workingCost.ErrCode; workingCostId = workingCost.workingCostId; } } return(Json(new { message = message, errMessage = ErrMessage, errCode = ErrCode.ToString(), workingCostId = workingCostId }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// Validates and saves material size to the database /// </summary> /// <param name="ident"></param> /// <param name="matSize"></param> /// <returns></returns> /// 2018-08-16 KJBO public gMaterialSizeCL saveMaterialSize(string ident, gMaterialSizeCL matSize) { CMaterialSize cm = new CMaterialSize(); return(cm.saveMaterialSize(ident, matSize)); }
/// <summary> /// Returns registered material sizes /// if materialSizeId is 0 then all registered material sizes will be returned /// else the material size that matches the materiallSizeId will be returned /// </summary> /// <param name="ident"></param> /// <param name="materialSizeId"></param> /// <returns></returns> /// 2018-08-16 KJBO public List <gMaterialSizeCL> getMaterialSize(string ident, int materialSizeId) { CMaterialSize cm = new CMaterialSize(); return(cm.getMaterialSize(ident, materialSizeId)); }