public bool Delete(CustomerClass c) { bool isSuccess = false; SqlConnection c1 = new SqlConnection(mylali2); try { string s1 = "DELETE FROM Customers WHERE CustomerID=@CustomerID"; SqlCommand c2 = new SqlCommand(s1, c1); c2.Parameters.AddWithValue("@CustomerID", c.CustomerID); c1.Open(); int rows = c2.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception) { c1.Close(); } return(isSuccess); }
public bool Insert(CustomerClass c) { bool isSuccess = false; SqlConnection c1 = new SqlConnection(mylali2); try { string s = "INSERT INTO Customers(CustomerName, CustomerAddress, PhoneNumber) VALUES (@CustomerName, @CustomerAddress, @PhoneNumber)"; SqlCommand c2 = new SqlCommand(s, c1); c2.Parameters.AddWithValue("@CustomerName", c.CustomerName); c2.Parameters.AddWithValue("@CustomerAddress", c.CustomerAddress); c2.Parameters.AddWithValue("@PhoneNumber", c.PhoneNumber); c1.Open(); int rows = c2.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception) { } finally { c1.Close(); } return(isSuccess); }
public bool Update(CustomerClass c) { bool isSuccess = false; SqlConnection c1 = new SqlConnection(mylali2); try { string s = "UPDATE Customers SET CustomerName=@CustomerName, CustomerAddress=@CustomerAddress, PhoneNumber=@PhoneNumber WHERE CustomerID=@CustomerID"; SqlCommand c2 = new SqlCommand(s, c1); c2.Parameters.AddWithValue("@CustomerName", c.CustomerName); c2.Parameters.AddWithValue("@CustomerAddress", c.CustomerAddress); c2.Parameters.AddWithValue("@PhoneNumber", c.PhoneNumber); c2.Parameters.AddWithValue("@CustomerID", c.CustomerID); c1.Open(); int rows = c2.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception) { c1.Close(); } return(isSuccess); }