public ActionResult EditVehicleSensor(VehicleSensorEditModel model)
{
return(Json(VehicleSensorBLL.EditVehicleSensors(model), JsonRequestBehavior.AllowGet));
}
public static OperationResult EditVehicleSensors(VehicleSensorEditModel model)
{
string sqlSel = "SELECT COUNT(0) FROM dbo.VehicleSensor WHERE VehicleID=@vehicleID AND SensorType=@sensorType";
List <SqlParameter> parasSel = new List <SqlParameter>()
{
new SqlParameter("@vehicleID", SqlDbType.BigInt),
new SqlParameter("@sensorType", SqlDbType.Int),
};
parasSel[0].Value = model.VehicleID;
parasSel[1].Value = model.TypeID;
var resultSel = MSSQLHelper.ExecuteScalar(CommandType.Text, sqlSel, parasSel.ToArray());
int count = int.Parse(resultSel.ToString());
if (count > 0)
{
string sqlEdit = @"UPDATE dbo.VehicleSensor
SET Value1 = @value1 ,
Value2 = @value2 ,
WarrantyDate = @warrantyDate
WHERE VehicleID=@vehicleID AND SensorType=@sensorType";
List <SqlParameter> parasEdit = new List <SqlParameter>()
{
new SqlParameter("@value1", SqlDbType.Float),
new SqlParameter("@value2", SqlDbType.Float),
new SqlParameter("@warrantyDate", SqlDbType.DateTime),
new SqlParameter("@vehicleID", SqlDbType.BigInt),
new SqlParameter("@sensorType", SqlDbType.Int),
};
if (model.Value1 == null)
{
parasEdit[0].Value = DBNull.Value;
}
else
{
parasEdit[0].Value = double.Parse(model.Value1.ToString());
}
if (model.Value2 == null)
{
parasEdit[1].Value = DBNull.Value;
}
else
{
parasEdit[1].Value = double.Parse(model.Value2.ToString());
}
//parasEdit[0].Value = double.Parse(model.Value1.ToString());
//parasEdit[1].Value = double.Parse(model.Value2.ToString());
parasEdit[2].Value = model.WarrantyDate;
parasEdit[3].Value = model.VehicleID;
parasEdit[4].Value = model.TypeID;
int result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sqlEdit, parasEdit.ToArray());
string msg = string.Empty;
switch (result)
{
case 1:
msg = PromptInformation.OperationSuccess;
break;
case 0:
msg = PromptInformation.NotExists;
break;
case -1:
msg = PromptInformation.DBError;
break;
}
return(new OperationResult()
{
Success = result > 0,
Message = msg
});
}
else
{
string sqlAdd = @"INSERT INTO dbo.VehicleSensor
( VehicleID , SensorType , Value1 , Value2 , WarrantyDate )
VALUES ( @vehicleID , @sensorType, @value1, @value2, @warrantyDate )";
List <SqlParameter> parasAdd = new List <SqlParameter>()
{
new SqlParameter("@vehicleID", SqlDbType.BigInt),
new SqlParameter("@sensorType", SqlDbType.Int),
new SqlParameter("@value1", SqlDbType.Float),
new SqlParameter("@value2", SqlDbType.Float),
new SqlParameter("@warrantyDate", SqlDbType.DateTime),
};
parasAdd[0].Value = model.VehicleID;
parasAdd[1].Value = model.TypeID;
if (model.Value1 == null)
{
parasAdd[2].Value = DBNull.Value;
}
else
{
parasAdd[2].Value = double.Parse(model.Value1.ToString());
}
if (model.Value2 == null)
{
parasAdd[3].Value = DBNull.Value;
}
else
{
parasAdd[3].Value = double.Parse(model.Value2.ToString());
}
parasAdd[4].Value = model.WarrantyDate;
bool result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sqlAdd, parasAdd.ToArray()) > 0;
return(new OperationResult()
{
Success = result,
Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError
});
}
}
