public StoragePerson GetSQlData(string stringConnection, int _Id) { SqlConnection conn = new SqlConnection(stringConnection); conn.Open(); Logger logger = LogManager.GetCurrentClassLogger(); logger.Info("Inside"); StoragePerson person = new StoragePerson(); string sqlGetCmd = @"select Fname,Sname,telephone,email from Person where idPerson=@_Id"; SqlCommand cmd = new SqlCommand(sqlGetCmd, conn); cmd.Parameters.AddWithValue("@_Id", _Id); SqlDataReader rdb = cmd.ExecuteReader(); rdb.Read(); //проверка на null person.IdStoragePerson = _Id; //if(rdb.IsDBNull()) person.FName = (string)GetUnoSQlValue(rdb,"Fname"); person.SName = (string)GetUnoSQlValue(rdb,"Sname"); person.Telephone = (string)GetUnoSQlValue(rdb,"telephone"); person.Email = (string)GetUnoSQlValue(rdb,"email"); if (conn != null) { conn.Close(); conn.Dispose(); } else { logger.Warn("SQlConnection not close"); } return person; }
public void SetSQlData(string stringConnection, StoragePerson person) { SqlConnection conn = new SqlConnection(stringConnection); conn.Open(); Logger logger = LogManager.GetCurrentClassLogger(); logger.Info("Inside"); string strInsert = @"insert into Person (Fname,Sname,telephone,email) values('@_Fname','@_Sname','@_telephone','@_email')"; SqlCommand cmd = new SqlCommand(strInsert, conn); cmd.Parameters.AddWithValue("@_Fname", person.FName); cmd.Parameters.AddWithValue("@_Sname", person.SName); cmd.Parameters.AddWithValue("@_telephone", person.Telephone); cmd.Parameters.AddWithValue("@_email", person.Email); cmd.ExecuteNonQuery(); if (conn != null) { conn.Close(); conn.Dispose(); } else { logger.Warn("SQlConnection not close"); } }
public void TestStoragePerson() { //Arrage IRepositoryPerson test = new RepositoryPerson(); StoragePerson ob = new StoragePerson(); //Act ob = test.GetSQlData(stringConnection, 2); //Assert Assert.AreEqual(null, ob.SName); }