private void btnDelete_Click(object sender, EventArgs e)
{
clsSqlServer obj = new clsSqlServer();
obj.DeleteCustomer(txtCustomerName.Text);
LoadCustomers();
}
private void loadCustomers()
{
clsSqlServer custObj = new clsSqlServer();
GridCustomers.DataSource = custObj.getCustomers(); // DATA SOURCE set
GridCustomers.DataBind(); // bind data to grid
}
private void btnSearch_Click(object sender, EventArgs e)
{
clsSqlServer objSql = new clsSqlServer();
DataSet objDataset = objSql.getCustomers();
datagridSearch.DataSource = objDataset.Tables[0];
}
private void LoadCustomers()
{
clsSqlServer obj = new clsSqlServer();
DataSet objDataset = obj.getCustomers();
//bind the data to the UI
dtgCustomers.DataSource = objDataset.Tables[0];
}
// Then create public set and get properties
public void save()
{
// we will make a call to Data Access Layer to Insert
//these value to SQL Server
clsSqlServer obj = new clsSqlServer();
obj.InsertCustomer(_CustomerName, _CountryName, _Gender, _Hobbies, _Email, _IsMarried);
}
protected void btnDelete_Click(object sender, EventArgs e)
{
// Here the delete logic will go
clsSqlServer obj = new clsSqlServer();
obj.DeleteCustomer(txtCustomerName.Text);
ClearData(); // Clear the selected customer data
loadCustomers(); // Loading the grid again
}
private void DisplayCustomer(string CustomerCode)
{
clsSqlServer obj = new clsSqlServer();
DataSet objDataset = obj.getCustomers(CustomerCode);
//Select the records and display it on the screen
string strCustomerName = objDataset.Tables[0].Rows[0][0].ToString();
string strCountryName = objDataset.Tables[0].Rows[0][1].ToString();
string strgender = objDataset.Tables[0].Rows[0][2].ToString();
string strhobbies = objDataset.Tables[0].Rows[0][3].ToString();
bool Married = false;
if (objDataset.Tables[0].Rows[0][4] != DBNull.Value)
{
Married = Convert.ToBoolean(objDataset.Tables[0].Rows[0][4]);
}
txtCustomerName.Text = strCustomerName;
cboCountry.Text = strCountryName;
if ((strgender.Length == 0) || (strgender == "Male"))
{
rdoMale.Checked = true;
}
else
{
rdoFemale.Checked = true;
}
//hoobies boolean
if ((strhobbies.Length == 0) || (strgender == "Sports"))
{
chkReading.Checked = true;
}
else
{
chkSports.Checked = true;
}
//status boolean
if (Married)
{
rdoMarried.Checked = true;
}
else
{
rdoUnmarried.Checked = true;
}
}
public void save()
{
clsSqlServer objSave = new clsSqlServer();
objSave.InsertCustomer(_CustomerName,
_CountryName,
_Gender,
_Hobbies,
_IsMarried,
_Email);
}
public void update()
{
clsSqlServer objUpdate = new clsSqlServer();
objUpdate.UpdateCustomer(_CustomerName,
_CountryName,
_Gender,
_Hobbies,
_IsMarried,
_Email);
}
private void displayCustomer(string custname)
{
clsSqlServer custObj = new clsSqlServer();
DataSet objDataset = custObj.getCustomers(custname);
// Select the records and display it on the screen
string strCustomerName = objDataset.Tables[0].Rows[0][0].ToString();
string strCountryName = objDataset.Tables[0].Rows[0][1].ToString();
string strGenderName = objDataset.Tables[0].Rows[0][2].ToString();
string strHobbiesName = objDataset.Tables[0].Rows[0][3].ToString();
string strEmail = objDataset.Tables[0].Rows[0][4].ToString();
bool StatusName = false;
if (objDataset.Tables[0].Rows[0][5] != DBNull.Value) // use bdnull instead of null when we use ado.net, dataset
{
StatusName = Convert.ToBoolean(objDataset.Tables[0].Rows[0][5].ToString());
}
txtCustomerName.Text = strCustomerName;
ddlCountries.Text = strCountryName;
txtEmail.Text = strEmail;
// Gender
//string strGenderName = objDataset.Tables[0].Rows[0][2].ToString();
if (strGenderName == "Male")
{
male.Checked = true;
}
else
{
Female.Checked = true;
}
// Hobbies
if (strHobbiesName == "Reading")
{
Reading.Checked = true;
}
else
{
Painting.Checked = true;
}
// Married
if (StatusName)
{
Married.Checked = true;
}
else
{
Unmarried.Checked = true;
}
// Close the connection
//objConnection.Close();
}
public bool isValid()
{
clsSqlServer obj = new clsSqlServer();
if (obj.getUser(userName, password).Tables[0].Rows.Count == 0)
{
return(false);
}
else
{
return(true);
}
}
public bool isValid()
{
clsSqlServer obj = new clsSqlServer();
// if we have not found username, and password
// if this dataset return by the getUser function is not having any rows
if (obj.getUser(userName, passWord).Tables[0].Rows.Count == 0)
{
return(false);
}
else
{
return(true);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
//UPDATING edited records.
//COMMAND INSERT FIRE
string gender = "";
string hobbies = "";
string status = "";
if (rdoMale.Checked)
{
gender = "Male";
}
else
{
gender = "Female";
}
if (chkReading.Checked)
{
hobbies = "Reading";
}
else
{
hobbies = "Sports";
}
if (rdoMarried.Checked)
{
status = "1";
}
else
{
status = "0";
}
clsSqlServer objUpdate = new clsSqlServer();
objUpdate.UpdateCustomer(txtCustomerName.Text,
cboCountry.Text,
gender,
hobbies,
status);
ClearData();
LoadCustomers();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
// Create a preview Form Object
string sex = "";
string hobbies = "";
string email = "";
bool status = false;
//Gender selection grab value
if (male.Checked)
{
sex = "Male";
}
else
{
sex = "Female";
}
// Hobbies selection grab value
if (Painting.Checked)
{
hobbies = "Painting";
}
else
{
hobbies = "Reading";
}
//Status selection grab value
if (Married.Checked)
{
status = true;
}
else
{
status = false;
}
// ADO.net code which will insert data to sql server
email = txtEmail.Text;
clsSqlServer insertObj = new clsSqlServer();
insertObj.InsertCustomer(txtCustomerName.Text, ddlCountries.Text, sex, hobbies, txtEmail.Text, status);
loadCustomers();
ClearData();
}
protected void btnEdit_Click(object sender, EventArgs e)
{
// Here the update logic will go
// Lets do some code for update operation
string email = "";
string sex = "";
string hobbies = "";
bool status = false;
//Gender selection grab value
if (male.Checked)
{
sex = "Male";
}
else
{
sex = "Female";
}
// Hobbies selection grab value
if (Painting.Checked)
{
hobbies = "Painting";
}
else
{
hobbies = "Reading";
}
//Status selection grab value
if (Married.Checked)
{
status = true;
}
else
{
status = false;
}
// ADO.net code which will insert to sql server
clsSqlServer obj = new clsSqlServer();
//obj.UpdateCustomer(txtCustomerName.Text, ddlcoun.Text, sex, hobbies, status);
email = txtEmail.Text;
obj.UpdateCustomer(txtCustomerName.Text, ddlCountries.Text, sex, hobbies, email, status);
loadCustomers();
}
private void btnAdd_Click(object sender, EventArgs e)
{
string gender = "";
string hobbies = "";
string status = "";
if (rdoMale.Checked)
{
gender = "Male";
}
else
{
gender = "Female";
}
if (chkReading.Checked)
{
hobbies = "Reading";
}
else
{
hobbies = "Sports";
}
if (rdoMarried.Checked)
{
status = "1";
}
else
{
status = "0";
}
clsSqlServer objInsert = new clsSqlServer();
objInsert.InsertCustomer(txtCustomerName.Text,
cboCountry.Text,
gender,
hobbies,
status);
ClearData();
LoadCustomers();
}
public DataSet LoadCustomer(string CustomerName)
{
clsSqlServer obj = new clsSqlServer();
return(obj.getCustomers(CustomerName));
}
public DataSet loadCustomer(string strCustomerName)
{
clsSqlServer objSql = new clsSqlServer();
return(objSql.getCustomer(strCustomerName));
}
public DataSet getCountries()
{
clsSqlServer obj = new clsSqlServer();
return(obj.getCountries());
}
public DataSet loadCustomer()
{
clsSqlServer objSql = new clsSqlServer();
return(objSql.getCustomer());
}
public void DeleteCustomer(string CustomerName)
{
clsSqlServer obj = new clsSqlServer();
obj.DeleteCustomer(CustomerName);
}
public void delete(string strCustomerName)
{
clsSqlServer objDelete = new clsSqlServer();
objDelete.DeleteCustomer(strCustomerName);
}
public void UpdateCustomer(string CustomerName, string CountryName, string Gender, string Hobbies, string Email, bool IsMarried)
{
clsSqlServer obj = new clsSqlServer();
obj.UpdateCustomer(CustomerName, CountryName, Gender, Hobbies, Email, IsMarried);
}
public DataSet getCustomers()
{
clsSqlServer obj = new clsSqlServer();
return(obj.getCustomers());
}
