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