public bool Put(NMSEntity entity)
{
ManageSQLConnection manageSQLConnection = new ManageSQLConnection();
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@ID", (entity.ID).ToString()));
sqlParameters.Add(new KeyValuePair <string, string>("@ClosedDate", entity.ClosedDate));
return(manageSQLConnection.UpdateValues("UpdateNMSData", sqlParameters));
}
public Tuple <bool, string> Post(NMSEntity nmsEntity)
{
// ManageSQLConnection sqlConnection = new ManageSQLConnection();
MySqlConnection sqlConnection = new MySqlConnection();
MySqlTransaction objTrans = null;
string connectionString = GlobalVariables.ConnectionString;
using (sqlConnection = new MySqlConnection(connectionString))
{
DataSet ds = new DataSet();
cmd = new MySqlCommand();
try
{
if (sqlConnection.State == 0)
{
sqlConnection.Open();
}
objTrans = sqlConnection.BeginTransaction();
cmd.Transaction = objTrans;
cmd.Connection = sqlConnection;
cmd.CommandText = "InsertNMSData";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@rcode", nmsEntity.RCode);
cmd.Parameters.AddWithValue("@dcode", nmsEntity.DCode);
cmd.Parameters.AddWithValue("@bug_id", nmsEntity.BugId);
cmd.Parameters.AddWithValue("@location", nmsEntity.Location);
cmd.Parameters.AddWithValue("@component_id", nmsEntity.Component);
cmd.Parameters.AddWithValue("@shop_number", nmsEntity.ShopNumber);
cmd.Parameters.AddWithValue("@sla_type", nmsEntity.SLAType);
cmd.Parameters.AddWithValue("@from_date", nmsEntity.FromDate);
cmd.Parameters.AddWithValue("@to_date", nmsEntity.ToDate);
cmd.Parameters.AddWithValue("@closed_date", nmsEntity.ClosedDate);
cmd.Parameters.AddWithValue("@reason_cd", nmsEntity.Reason);
cmd.Parameters.AddWithValue("@remarks", nmsEntity.Remarks);
cmd.ExecuteNonQuery();
objTrans.Commit();
cmd.Parameters.Clear();
cmd.Dispose();
return(new Tuple <bool, string>(true, JsonConvert.SerializeObject(ds)));
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message + " : " + ex.StackTrace);
objTrans.Rollback();
return(new Tuple <bool, string>(false, "Exception occured"));
}
finally
{
sqlConnection.Close();
cmd.Dispose();
ds.Dispose();
}
}
}
public NMSEntity CreateCustomMeshModel(GraphicsDevice graphicsDevice, VertexPositionNormalTexture[] Vertexes, int[] Indices, PrimitiveType PrimType, RasterizerStateDescription RasterizerDesc, Material Mat, Vector3 SpawnPos, Quaternion SpawnRot, bool SpawnNow = true)
{
var meshMesh = new Mesh();
var meshDraw = new MeshDraw();
var meshMod = new Model();
var meshComp = new ModelComponent();
var buffIdx = SiliconStudio.Xenko.Graphics.Buffer.Index.New(graphicsDevice, Indices);
var buffVert = SiliconStudio.Xenko.Graphics.Buffer.Vertex.New(graphicsDevice, Vertexes);
var RasterizerStateDesc = RasterizerDesc;
meshDraw.IndexBuffer = new IndexBufferBinding(buffIdx, true, Indices.Length);
meshDraw.VertexBuffers = new VertexBufferBinding[] { new VertexBufferBinding(buffVert, VertexPositionNormalTexture.Layout, Vertexes.Length) };
meshDraw.PrimitiveType = PrimType;
meshDraw.DrawCount = Indices.Length;
meshMesh.Draw = meshDraw;
meshMesh.Parameters.Set(Effect.RasterizerStateKey, RasterizerState.New(graphicsDevice, RasterizerStateDesc));
meshMesh.MaterialIndex = 0;
var mat = Mat;
Vector3 min = new Vector3(float.MaxValue), max = new Vector3(float.MinValue);
foreach (var vert in Vertexes)
{
if (vert.Position.X < min.X)
{
min.X = vert.Position.X;
}
if (vert.Position.Y < min.Y)
{
min.Y = vert.Position.Y;
}
if (vert.Position.Z < min.Z)
{
min.Z = vert.Position.Z;
}
if (vert.Position.X > max.X)
{
max.X = vert.Position.X;
}
if (vert.Position.Y > max.Y)
{
max.Y = vert.Position.Y;
}
if (vert.Position.Z > max.Z)
{
max.Z = vert.Position.Z;
}
}
meshMod.BoundingBox = new BoundingBox(min, max);
meshMod.Materials.Add(mat);
meshMod.Meshes.Add(meshMesh);
meshComp.Model = meshMod;
var outEntity = new NMSEntity();
outEntity.Transform.Position = SpawnPos;
outEntity.Transform.Rotation = SpawnRot;
outEntity.Add(meshComp);
outEntity.Group = EntityGroup.Group29;
outEntity.Transform.UpdateLocalMatrix();
meshMesh.Parameters.Set(TransformationKeys.World, outEntity.Transform.LocalMatrix);
if (SpawnNow)
{
SceneSystem.SceneInstance.Scene.Entities.Add(outEntity);
}
return(outEntity);
}
