public static void Update(PersonModel personModel) { //todo }
public static void Update(PersonModel personModel) { using (var connection = SqlHelper.GetConnection()) { var sqlCommand = new SqlCommand(); sqlCommand.Connection = connection; sqlCommand.CommandText = @"UPDATE People SET FirstName = @FirstName, LastName = @LastName,Phone = @Phone, Email = @Email,Created = @Created, Updated = @Updated WHERE ID = @ID" ; var sqlFirstNameParam = new SqlParameter { DbType = System.Data.DbType.AnsiString, Value = personModel.FirstName, ParameterName = "@FirstName" }; var sqlLastNameParam = new SqlParameter { DbType = System.Data.DbType.AnsiString, Value = personModel.LastName, ParameterName = "@LastName" }; var sqlPhoneParam = new SqlParameter { DbType = System.Data.DbType.AnsiString, Value = personModel.Phone, ParameterName = "@Phone" }; var sqlEmailParam = new SqlParameter { DbType = System.Data.DbType.AnsiString, Value = personModel.Email, ParameterName = "@Email" }; var sqlCreatedDateParam = new SqlParameter { DbType = System.Data.DbType.DateTime, Value = personModel.Created, ParameterName = "@Created" }; var sqlUpdatedDateParam = new SqlParameter { DbType = System.Data.DbType.DateTime, Value = DateTime.Now, ParameterName = "@Updated" }; var sqlIDParam = new SqlParameter { DbType = System.Data.DbType.Int32, Value = personModel.ID, ParameterName = "@ID" }; sqlCommand.Parameters.Add(sqlFirstNameParam); sqlCommand.Parameters.Add(sqlLastNameParam); sqlCommand.Parameters.Add(sqlPhoneParam); sqlCommand.Parameters.Add(sqlEmailParam); sqlCommand.Parameters.Add(sqlCreatedDateParam); sqlCommand.Parameters.Add(sqlUpdatedDateParam); sqlCommand.Parameters.Add(sqlIDParam); sqlCommand.ExecuteScalar(); } return; }
public static int Update(PersonModel personModel) { using (var connection = SqlHelper.GetConnection()) { var sqlCommand = new SqlCommand(); sqlCommand.Connection = connection; sqlCommand.CommandText = @"Update People set FirstName = @FirstName, LastName = @LastName, Phone = @Phone, Email = @Email, Updated = @Updated WHERE ID = @id;" ; var sqlIDParam = new SqlParameter { DbType = System.Data.DbType.Int32, Value = personModel.ID, ParameterName = "@id" }; var sqlFirstNameParam = new SqlParameter { DbType = System.Data.DbType.AnsiString, Value = personModel.FirstName, ParameterName = "@FirstName" }; var sqlLastNameParam = new SqlParameter { DbType = System.Data.DbType.AnsiString, Value = personModel.LastName, ParameterName = "@LastName" }; var sqlPhoneParam = new SqlParameter { DbType = System.Data.DbType.AnsiString, Value = personModel.Phone, ParameterName = "@Phone" }; var sqlEmailParam = new SqlParameter { DbType = System.Data.DbType.AnsiString, Value = personModel.Email, ParameterName = "@Email" }; var sqlUpdatedDateParam = new SqlParameter { DbType = System.Data.DbType.DateTime, Value = DateTime.Now, ParameterName = "@Updated" }; sqlCommand.Parameters.Add(sqlIDParam); sqlCommand.Parameters.Add(sqlFirstNameParam); sqlCommand.Parameters.Add(sqlLastNameParam); sqlCommand.Parameters.Add(sqlPhoneParam); sqlCommand.Parameters.Add(sqlEmailParam); sqlCommand.Parameters.Add(sqlUpdatedDateParam); int id = (int)sqlCommand.ExecuteNonQuery(); return(id); } }
public static void Add(PersonModel personModel) { using (var connection = SqlHelper.GetConnection()) { var sqlCommand = new SqlCommand(); sqlCommand.Connection = connection; if (personModel.Email != null) { sqlCommand.CommandText = @"Insert INTO People (FirstName, LastName, Phone, Email, Created, Updated) VALUES (@FirstName, @LastName, @Phone, @Email, @Created, @Updated);" ; var sqlEmailParam = new SqlParameter { DbType = System.Data.DbType.AnsiString, Value = personModel.Email, ParameterName = "@Email" }; sqlCommand.Parameters.Add(sqlEmailParam); } sqlCommand.CommandText = @"Insert INTO People (FirstName, LastName, Phone, Created, Updated) VALUES (@FirstName, @LastName, @Phone,@Created, @Updated);" ; var sqlFirstNameParam = new SqlParameter { DbType = System.Data.DbType.AnsiString, Value = personModel.FirstName, ParameterName = "@FirstName" }; var sqlLastNameParam = new SqlParameter { DbType = System.Data.DbType.AnsiString, Value = personModel.LastName, ParameterName = "@LastName" }; var sqlPhoneParam = new SqlParameter { DbType = System.Data.DbType.AnsiString, Value = personModel.Phone, ParameterName = "@Phone" }; var sqlCreatedDateParam = new SqlParameter { DbType = System.Data.DbType.DateTime, Value = personModel.Created, ParameterName = "@Created" }; var sqlUpdatedDateParam = new SqlParameter { DbType = System.Data.DbType.DateTime, Value = personModel.Updated, ParameterName = "@Updated" }; sqlCommand.Parameters.Add(sqlFirstNameParam); sqlCommand.Parameters.Add(sqlLastNameParam); sqlCommand.Parameters.Add(sqlPhoneParam); sqlCommand.Parameters.Add(sqlCreatedDateParam); sqlCommand.Parameters.Add(sqlUpdatedDateParam); sqlCommand.ExecuteNonQuery(); } }