public DataTable Search(Customer.AllInfo allInfo)
{
queryString = @"SELECT * FROM Customer WHERE Customer Name = '" + allInfo.customerName + "';";
ConnectAndMakeSql(queryString);
ExecuteQuery();
return(dataTable);
}
public string AddToRepository(Customer.AllInfo allInfo)
{
queryString = @"INSERT INTO Customer ( CustomerName, ContactNo, Address ) VALUES ( '" + allInfo.customerName + "', " + allInfo.contactNo + ", '" + allInfo.customerAddress + "' );";
ConnectAndMakeSql(queryString);
return("OK");
}
public string Delete(Customer.AllInfo allInfo)
{
queryString = @"SELECT * FROM Customer WHERE CustomerName = '" + allInfo.customerName + "';";
ConnectAndMakeSql(queryString);
ExecuteQuery();
if (NoOfEntries() == 0)
{
return("NOT OK");
}
else
{
queryString = @"DELETE FROM Customer WHERE CustomerName = '" + allInfo.customerName + "';";
return("Data Deleted");
}
}
public string CanBeAdded(Customer.AllInfo allInfo)
{
queryString = "SELECT COUNT(CustomerID) FROM Customer WHERE CustomerName = '" + allInfo.customerName + "';";
ConnectAndMakeSql(queryString);
ExecuteQuery();
if (NoOfEntries() == 0)
{
return("OK");
}
else
{
return("NOT OK");
}
}
public string Update(Customer.AllInfo allInfo)
{
throw new NotImplementedException();
}
public DataTable Search(Customer.AllInfo allInfo)
{
return(_customerRepository.Search(allInfo));
}
public string Delete(Customer.AllInfo allInfo)
{
return(_customerRepository.Delete(allInfo));
}
public string Update(Customer.AllInfo allInfo)
{
return(_customerRepository.Update(allInfo));
}
public string AddToRepository(Customer.AllInfo allInfo)
{
return(_customerRepository.AddToRepository(allInfo));
}
public string CanBeAdded(Customer.AllInfo allInfo)
{
return(_customerRepository.CanBeAdded(allInfo));
}
