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