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