public ActionResult EditMeasurementType(UpdateMeasurementTypeViewModel model) { EtronixValidation EV = new EtronixValidation(); int alert = -1; string vMessage = null; Entities _contextEntities = new Entities(); //check if all fields are correctly filled with data - data validation if (ModelState.IsValid) { //UpdateMeasurementTypeViewModel vUpdateMeasurementTypeViewModel = new UpdateMeasurementTypeViewModel(); try { _contextEntities = new Entities(); var vUserParameter1 = new SqlParameter("@MUID", model.Id); var vUserParameter2 = new SqlParameter("@MUType", model.NewType); var vResult = _contextEntities.Database.SqlQuery <List <string> >( "UpdateMeasurementType " + "@MUID, " + "@MUType", vUserParameter1, vUserParameter2).SingleOrDefault(); alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_success; vMessage = "The Measurement Unit was updated"; EV.ValidationCode = EtronixValidationCode.ValidationDic[alert]; EV.AddToList(vMessage); model.EtronixValidation = EV; } catch (Exception exception) { //Console.WriteLine(exception.Message); alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_danger; vMessage = exception.Message + Environment.NewLine; EV.ValidationCode = EtronixValidationCode.ValidationDic[alert]; EV.AddToList(vMessage); model.EtronixValidation = EV; } } else { List <string> mE = ModelState.Values.SelectMany(x => x.Errors).Select(e => e.ErrorMessage).ToList(); alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_danger; EV.ValidationCode = EtronixValidationCode.ValidationDic[alert]; foreach (var msg in mE) { EV.AddToList(msg); } model.EtronixValidation = EV; return(View(model)); } return(View(model)); }
public ActionResult DeletePoint(int pointID) { Procedures.ResultDeletePoint modelPoint = new Procedures.ResultDeletePoint(); Entities _contextEntities = new Entities(); EtronixValidation EV = new EtronixValidation(); int alert = -1; string vMessage = null; try { //throw new Exception("Controlled Exception"); if (pointID != null) { var vPointID = new SqlParameter("@pointID", pointID); var vPointIDResult = _contextEntities.Database .SqlQuery <Procedures.ResultDeletePoint>("DeletePoint @pointID", vPointID).ToList(); //alert success alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_success; vMessage = "Point ID:" + pointID.ToString() + " was successfully deleted" + Environment.NewLine; EV.ValidationCode = EtronixValidationCode.ValidationDic[alert]; EV.AddToList(vMessage); modelPoint.EtronixValidation = EV; //when you delete a point the access information of this point must be deleted as well EV.AddToList("The access information of this point was deleted for all users"); } } catch (Exception exception) { alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_danger; vMessage = exception.Message; EV.ValidationCode = EtronixValidationCode.ValidationDic[alert]; EV.AddToList(vMessage); modelPoint.EtronixValidation = EV; } return(PartialView("_Point_DeletePoint", modelPoint)); }
public ActionResult DeleteMeasurementUnitType(string measurementUnitType) { Procedures.ResultDeleteMeasurementUnitTypes modelMeasurementUnitTypes = new Procedures.ResultDeleteMeasurementUnitTypes(); Entities _contextEntities = new Entities(); EtronixValidation EV = new EtronixValidation(); int alert = -1; string vMessage = null; try { //throw new Exception("Controlled Exception"); if (measurementUnitType != null) { var measurementUnitTypeID = new SqlParameter("@MUID", measurementUnitType); var vMUT = _contextEntities.Database .SqlQuery <Procedures.ResultDeleteMeasurementUnitTypes>("DeleteMeasurementUnitType @MUID", measurementUnitTypeID).ToList(); //alert success alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_success; vMessage = "Measurement Unit Type:" + measurementUnitType + " was successfully deleted" + Environment.NewLine; EV.ValidationCode = EtronixValidationCode.ValidationDic[alert]; EV.AddToList(vMessage); modelMeasurementUnitTypes.EtronixValidation = EV; } } catch (Exception exception) { alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_danger; vMessage = exception.Message; EV.ValidationCode = EtronixValidationCode.ValidationDic[alert]; EV.AddToList(vMessage); modelMeasurementUnitTypes.EtronixValidation = EV; } return(PartialView("_Data_DeleteMeasurementUnitType", modelMeasurementUnitTypes)); }
public ActionResult EditPoint(string pointID) { EtronixValidation EV = new EtronixValidation(); int alert = -1; string vMessage = null; List <Points> vEditedPoint = null; List <PointsMU> vCombinedLists = null; try { int vId = int.Parse(pointID); Entities db = new Entities(); vEditedPoint = db.Points.Where(m => m.Id == vId).ToList(); List <Procedures.MeasurementUnitTypes> vM = db.MeasurementUnitType.ToList(); vCombinedLists = vEditedPoint.Join(vM, a => a.MUT_id, b => b.Id, (a, b) => new PointsMU { Id = a.Id, PointName = a.PointName, TableName = a.TableName, DatabaseName = a.DatabaseName, Tag1 = a.Tag1, Tag2 = a.Tag2, Tag3 = a.Tag3, MUT_id = a.MUT_id, Type = b.Type, EtronixValidation = EV }).ToList(); int z = 0; } catch (Exception exception) { //Console.WriteLine(exception.Message); alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_danger; vMessage = exception.Message + Environment.NewLine; EV.ValidationCode = EtronixValidationCode.ValidationDic[alert]; EV.AddToList(vMessage); } PointsMU vPointsMu = vCombinedLists[0]; return(View(vPointsMu)); //return Content("rrenio"); }
public ActionResult EditMeasurementType(string MUID) { EtronixValidation EV = new EtronixValidation(); int alert = -1; string vMessage = null; Entities _contextEntities; UpdateMeasurementTypeViewModel vUpdateMeasurementTypeViewModel = new UpdateMeasurementTypeViewModel(); try { _contextEntities = new Entities(); var vParameter = new SqlParameter("@MUID", MUID); Procedures.MeasurementUnitTypes vMeasurementType = _contextEntities.Database.SqlQuery <Procedures.MeasurementUnitTypes>( "GetMeasurementType " + "@MUID ", vParameter).SingleOrDefault(); vUpdateMeasurementTypeViewModel.Id = vMeasurementType.Id.ToString(); vUpdateMeasurementTypeViewModel.Type = vMeasurementType.Type; vUpdateMeasurementTypeViewModel.NewType = ""; vUpdateMeasurementTypeViewModel.EtronixValidation = EV; } catch (Exception exception) { //Console.WriteLine(exception.Message); alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_danger; vMessage = exception.Message + Environment.NewLine; EV.ValidationCode = EtronixValidationCode.ValidationDic[alert]; EV.AddToList(vMessage); vUpdateMeasurementTypeViewModel.EtronixValidation = EV; } return(View(vUpdateMeasurementTypeViewModel)); }
public ActionResult AddType(MeasurementTypeViewModel pDataViewModel) { Entities _contextEntities; MeasurementTypeViewModel measurementTypeViewModel = new MeasurementTypeViewModel(); measurementTypeViewModel.Id = pDataViewModel.Id; measurementTypeViewModel.Type = pDataViewModel.Type; EtronixValidation EV = new EtronixValidation(); int alert = -1; string vMessage = null; if (ModelState["Type"].Errors.Count == 0) { try { //get details of the changing person _contextEntities = new Entities(); var vMeasurementType = new SqlParameter("@Type", pDataViewModel.Type); Procedures.MeasurementUnitTypes vMeasurementUnitTypes = _contextEntities.Database.SqlQuery <Procedures.MeasurementUnitTypes>( "InsertMeasurementType " + "@Type ", vMeasurementType).SingleOrDefault(); //2 commands clear the field of Unit_type measurementTypeViewModel.Type = null; ModelState.Clear(); } catch (Exception exception) { alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_danger; vMessage = exception.Message; EV.ValidationCode = EtronixValidationCode.ValidationDic[alert]; EV.AddToList(vMessage); measurementTypeViewModel.EtronixValidation = EV; goto End; } alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_success; vMessage = "The measurement type was successfully added"; EV.ValidationCode = EtronixValidationCode.ValidationDic[alert]; EV.AddToList(vMessage); measurementTypeViewModel.EtronixValidation = EV; } else { List <string> mE = ModelState.Values.SelectMany(x => x.Errors).Select(e => e.ErrorMessage).ToList(); alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_danger; EV.ValidationCode = EtronixValidationCode.ValidationDic[alert]; foreach (var msg in mE) { EV.AddToList(msg); } measurementTypeViewModel.EtronixValidation = EV; } //return RedirectToAction("Index", new RouteValueDictionary(new {Type ="haha"})); End: return(View("Index", measurementTypeViewModel)); }
//[ValidateAntiForgeryToken] public async Task <ActionResult> Register(PointViewModel model) { EtronixValidation EV = new EtronixValidation(); int alert = -1; string vMessage = null; Entities _contextEntities = new Entities(); try { if (ModelState.IsValid) { var vPointPN = new SqlParameter("@PointName", model.PointName); var vPointTN = new SqlParameter("@TableName", model.TableName); var vPointDBN = new SqlParameter("@DatabaseName", model.DataBaseName); //the optional fields if (model.Tag1 == null) { model.Tag1 = ""; } if (model.Tag2 == null) { model.Tag2 = ""; } if (model.Tag3 == null) { model.Tag3 = ""; } var vPointTag1 = new SqlParameter("@Tag1", model.Tag1); var vPointTag2 = new SqlParameter("@Tag2", model.Tag2); var vPointTag3 = new SqlParameter("@Tag3", model.Tag3); //get MUT ID by MUT Name var vPointMUT_0 = new SqlParameter("@PointMUT_Name", model.MUT); var vPointMutId_0 = _contextEntities.Database.SqlQuery <int>("GetIdMUT " + "@PointMUT_Name ", vPointMUT_0).SingleOrDefault(); // Set MUT ID var vPointMUT_1 = new SqlParameter("@MUT_Id", vPointMutId_0); var vPointExists = _contextEntities.Database.SqlQuery <String>("CheckPointIfExist " + "@PointName, @TableName, @DatabaseName, @Tag1, @Tag2, @Tag3, @MUT_id", vPointPN, vPointTN, vPointDBN, vPointTag1, vPointTag2, vPointTag3, vPointMUT_1).SingleOrDefault(); Debug.WriteLine("The points already exists:" + vPointExists); if (Boolean.Parse(vPointExists) == true) { //Generate message alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_danger; EV.ValidationCode = EtronixValidationCode.ValidationDic[alert]; vMessage = "There is already a point in the database with the following parameters:"; EV.AddToList(vMessage); //ID but I will not put it here vMessage = "Point Name:" + model.PointName + Environment.NewLine; EV.AddToList(vMessage); vMessage = "Table Name:" + model.TableName + Environment.NewLine; EV.AddToList(vMessage); vMessage = "Database Name:" + model.DataBaseName + Environment.NewLine; EV.AddToList(vMessage); vMessage = "Tag 1:" + model.Tag1 + Environment.NewLine; EV.AddToList(vMessage); vMessage = "Tag 2:" + model.Tag2 + Environment.NewLine; EV.AddToList(vMessage); vMessage = "Tag 3:" + model.Tag3 + Environment.NewLine; EV.AddToList(vMessage); vMessage = "MUT:" + model.MUT + Environment.NewLine; EV.AddToList(vMessage); //update model model.EtronixValidation = EV; goto _end; } else { //select Id of MUT measurement unit type var vPointMUT = new SqlParameter("@PointMUT_Name", model.MUT); var vPointMutId = _contextEntities.Database.SqlQuery <int>("GetIdMUT " + "@PointMUT_Name ", vPointMUT).SingleOrDefault(); Debug.WriteLine("MUT ID:" + vPointMutId); //set SQL params var vPointPN_2 = new SqlParameter("@PointName", model.PointName); var vPointTN_2 = new SqlParameter("@TableName", model.TableName); var vPointDBN_2 = new SqlParameter("@DatabaseName", model.DataBaseName); //the optional fields if (model.Tag1 == null) { model.Tag1 = ""; } if (model.Tag2 == null) { model.Tag2 = ""; } if (model.Tag3 == null) { model.Tag3 = ""; } var vPointTag1_2 = new SqlParameter("@Tag1", model.Tag1); var vPointTag2_2 = new SqlParameter("@Tag2", model.Tag2); var vPointTag3_2 = new SqlParameter("@Tag3", model.Tag3); // Set MUT ID var vPointMUT_2 = new SqlParameter("@MUT_Id", vPointMutId); //insert new point Procedures.ResultInsertPoint vPointInserted = _contextEntities.Database.SqlQuery <Procedures.ResultInsertPoint> ("InsertPoints " + "@PointName, @TableName, @DatabaseName, @Tag1, @Tag2, @Tag3, @MUT_id", vPointPN_2, vPointTN_2, vPointDBN_2, vPointTag1_2, vPointTag2_2, vPointTag3_2, vPointMUT_2).SingleOrDefault(); Debug.WriteLine("The point was inserted, ID:" + vPointInserted); //set feedback for client //Generate message alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_success; vMessage = "The point was successuly added with the following paramters:" + Environment.NewLine; EV.AddToList(vMessage); vMessage = "ID:" + vPointInserted.Id + Environment.NewLine; EV.AddToList(vMessage); vMessage = "Point Name:" + vPointInserted.PointName + Environment.NewLine; EV.AddToList(vMessage); vMessage = "Table Name:" + vPointInserted.TableName + Environment.NewLine; EV.AddToList(vMessage); vMessage = "Database Name:" + vPointInserted.DataBaseName + Environment.NewLine; EV.AddToList(vMessage); vMessage = "Tag 1:" + vPointInserted.Tag1 + Environment.NewLine; EV.AddToList(vMessage); vMessage = "Tag 2:" + vPointInserted.Tag2 + Environment.NewLine; EV.AddToList(vMessage); vMessage = "Tag 3:" + vPointInserted.Tag3 + Environment.NewLine; EV.AddToList(vMessage); vMessage = "MUT ID:" + vPointInserted.MUT_Id + Environment.NewLine; EV.AddToList(vMessage); EV.ValidationCode = EtronixValidationCode.ValidationDic[alert]; model.EtronixValidation = EV; //2020-11-16 Update all users with this point //var vPointId = new SqlParameter("@PointId", SqlDbType.Int).Value = vPointInserted.Id; var vPointId = new SqlParameter("@PointId", vPointInserted.Id); vPointId.SqlDbType = SqlDbType.Int; var vUpdatePointsAccess = _contextEntities.Database.SqlQuery <int>( "UpdatePointsAccessNewPoint @PointId ", vPointId ).ToList(); if (vUpdatePointsAccess[0] == 0) { alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_success; EV.ValidationCode = EtronixValidationCode.ValidationDic[alert]; EV.AddToList("All users were updated with this point"); model.EtronixValidation = EV; return(View(model)); } else { alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_danger; EV.ValidationCode = EtronixValidationCode.ValidationDic[alert]; EV.AddToList("The UpdatePointsAccess procedure created an error"); model.EtronixValidation = EV; return(View(model)); } } } else { alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_danger; vMessage = "Provide valid parameters"; EV.ValidationCode = EtronixValidationCode.ValidationDic[alert]; EV.AddToList(vMessage); model.EtronixValidation = EV; } } catch (Exception e) { alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_danger; EV.ValidationCode = EtronixValidationCode.ValidationDic[alert]; EV.AddToList(e.Message); model.EtronixValidation = EV; return(View(model)); } _end: return(View(model)); }
public ActionResult EditPoint(PointsMU model) { EtronixValidation EV = new EtronixValidation(); int alert = -1; string vMessage = null; Entities _contextEntities = new Entities(); try { if (ModelState.IsValid) { var vPointId = new SqlParameter("@pointID", model.Id); var vPointName = new SqlParameter("@PointName", model.PointName); var vTableName = new SqlParameter("@TableName", model.TableName); var vDatabaseName = new SqlParameter("@DatabaseName", model.DatabaseName); var vTag1 = new SqlParameter("@Tag1", model.Tag1); var vTag2 = new SqlParameter("@Tag2", model.Tag2); var vTag3 = new SqlParameter("@Tag3", model.Tag3); var vMUT_id = new SqlParameter("@MUT_id", model.MUT_id); var vPointIDResult = _contextEntities.Database.SqlQuery <Procedures.ResultUpdatePoint>( "UpdatePoint @PointId , @PointName , @TableName , @DatabaseName , @Tag1 , @Tag2 , @Tag3 , @MUT_id ", vPointId, vPointName, vTableName, vDatabaseName, vTag1, vTag2, vTag3, vMUT_id ).ToList(); alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_success; vMessage = "The details' point were updated"; EV.ValidationCode = EtronixValidationCode.ValidationDic[alert]; EV.AddToList(vMessage); model.EtronixValidation = EV; } else { List <string> mE = ModelState.Values.SelectMany(x => x.Errors).Select(e => e.ErrorMessage).ToList(); alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_danger; EV.ValidationCode = EtronixValidationCode.ValidationDic[alert]; foreach (var msg in mE) { EV.AddToList(msg); } model.EtronixValidation = EV; return(View(model)); } } catch (Exception exception) { alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_danger; vMessage = exception.Message; EV.ValidationCode = EtronixValidationCode.ValidationDic[alert]; EV.AddToList(vMessage); model.EtronixValidation = EV; } return(View(model)); }
public ActionResult UpdatePoints ( string pointName, string tableName, string databaseName, string tag1, string tag2, string tag3, int?mutID, string sortColumn, string sortOrder, int?currentpage, int?ppageSize, string userId, string pointsList) { // Root myDeserializedClass = JsonConvert.DeserializeObject<Root>(myJsonResponse); //https://json2csharp.com/json-to-csharp PointUpdateAll vAllPoints = JsonConvert.DeserializeObject <PointUpdateAll>(pointsList); EtronixValidation EV = new EtronixValidation(); int alert = -1; string vMessage = null; Entities _contextEntities = new Entities(); WebAppEtronix20180824.Models.DTO.Message vModel = new Message(); try { //Update All points for the choses user from the particular page foreach (PointUpdate element in vAllPoints.pointsList) { var vUserId = new SqlParameter("@UserId", userId); var vId = new SqlParameter("@Id", element.PtId.Substring(2)); var vAccess = new SqlParameter("@Access", element.PtValue); var vRow = _contextEntities.Database.SqlQuery <Procedures.ResultAccess>( "UpdateAccessPoint @UserId, @Id , @Access ", vUserId, vId, vAccess ).ToList(); alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_success; vMessage = "Point:" + element.PtId.Substring(2) + " set to:" + element.PtValue.ToString(); EV.ValidationCode = EtronixValidationCode.ValidationDic[alert]; EV.AddToList(vMessage); vModel.EtronixValidation = EV; } } catch (Exception exception) { alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_danger; vMessage = exception.Message; EV.ValidationCode = EtronixValidationCode.ValidationDic[alert]; EV.AddToList(vMessage); //model.EtronixValidation = EV; vModel.EtronixValidation = EV; } int?v_currentpage = currentpage; //stay on teh same page and update the points list //v_currentpage--; //Do not set a list var vPoints = PointsList_2( pointName, tableName, databaseName, tag1, tag2, tag3, mutID, sortColumn, sortOrder, v_currentpage, ppageSize, userId); //return just a confirmation //return PartialView("_Access_IndexTable_2", vPoints); //set a confirmation only return(PartialView("_Etronix_Message", vModel)); }