public void SetSQlData(string stringConnection, StorageDiscriptionEvent test) { SqlConnection conn = new SqlConnection(stringConnection); conn.Open(); Logger logger = LogManager.GetCurrentClassLogger(); logger.Info("Inside"); string strInsert = @"insert into Person (Age_Limit,Location_Event,Person,Access_Level,Discription_Events,Time_Begin,Time_End) values('@_Age_Limit','@_Location_Event','@_Person','@_Access_Level','@_Discription_Events','@_Time_Begin','@_Time_End')"; SqlCommand cmd = new SqlCommand(strInsert, conn); cmd.Parameters.AddWithValue("@_Age_Limit", test.Age_Limit); cmd.Parameters.AddWithValue("@_Location_Event", test.Location_Event); cmd.Parameters.AddWithValue("@_Person", test.Person); cmd.Parameters.AddWithValue("@_Access_Level", test.Access_Level); cmd.Parameters.AddWithValue("@_Discription_Events", test.Discription_Events); cmd.Parameters.AddWithValue("@_Time_Begin", test.Time_Begin); cmd.Parameters.AddWithValue("@_Time_End", test.Time_End); cmd.ExecuteNonQuery(); if (conn != null) { conn.Close(); conn.Dispose(); } else { logger.Warn("SQlConnection not close"); } }
public StorageDiscriptionEvent GetSQlData(string stringConnection, int _Id) { SqlConnection conn = new SqlConnection(stringConnection); conn.Open(); Logger logger = LogManager.GetCurrentClassLogger(); logger.Info("Inside"); string sqlGetCmd = @"select Age_Limit,Location_Event,Person,Access_Level,Discription_Events,Time_Begin,Time_End from DiscriptionEvent where IdDiscriptionEvent = @_IdDiscriptionEvent"; StorageDiscriptionEvent discriptionEvent = new StorageDiscriptionEvent(); SqlCommand cmd = new SqlCommand(sqlGetCmd, conn); cmd.Parameters.AddWithValue("_IdDiscriptionEvent", _Id); SqlDataReader rdb = cmd.ExecuteReader(); rdb.Read(); discriptionEvent.IdDiscriptionEvent = _Id; discriptionEvent.Age_Limit = (int)GetUnoSQlValue(rdb,"Age_Limit"); discriptionEvent.Location_Event = (int)GetUnoSQlValue(rdb,"Location_Event"); discriptionEvent.Person = (int)GetUnoSQlValue(rdb,"Person"); discriptionEvent.Access_Level = (int)GetUnoSQlValue(rdb,"Access_Level"); discriptionEvent.Discription_Events = (string)GetUnoSQlValue(rdb,"Discription_Events"); discriptionEvent.Time_Begin = (DateTime)GetUnoSQlValue(rdb,"Time_Begin"); //discriptionEvent.Time_Begin = rdb.GetDateTime(rdb.GetOrdinal("Time_Begin")); discriptionEvent.Time_End = (DateTime)GetUnoSQlValue(rdb,"Time_End"); if (conn != null) { conn.Close(); conn.Dispose(); } else { logger.Warn("SQlConnection not close"); } if (rdb != null) { rdb.Close(); } return discriptionEvent; }