public clsSupplierInfo CreateData(clsSupplierInfo data)
{
data.SupplierName = txtSupplierName.Text.ToString().Trim();
data.Phone = Convert.ToInt32(txtPhone.Text.ToString().Trim());
data.Address = txtAddress.Text.ToString().Trim();
data.ContactPerson = txtContactPerson.Text.ToString().Trim();
data.ContactNumber = Convert.ToInt32(txtContactNo.Text.ToString().Trim());
return(data);
}
public void btnSave_Click(object sender, EventArgs e)
{
String strqu = "";
clsSupplierInfo data = new clsSupplierInfo();
data = CreateData(data);
strqu = "Insert into tbl_SupplierInfo(SupplierName,Phone,Address,ContactPerson,ContactNumber) values('" + data.SupplierName + "','" + data.Phone + "','" + data.Address + "','" + data.ContactPerson + "','" + data.ContactNumber + "')";
SqlHelper.ExecuteNonQuery(clsUtil.ConnectionString, CommandType.Text, strqu);
MessageBox.Show("Save Data Sucessfully .");
GetAllSupplierInfo();
ClearAllData();
}
private void btnupdate_Click(object sender, EventArgs e)
{
String strQuery = "";
clsSupplierInfo data1 = new clsSupplierInfo();
data1 = UpdateData(data1);
strQuery = " UPDATE [tbl_SupplierInfo] " +
"SET [SupplierName] ='" + data1.SupplierName + "'" +
",[Phone]=' " + data1.Phone + "' " +
",[Address]= '" + data1.Address + "' " +
",[ContactPerson]= '" + data1.ContactPerson + "' " +
",[ContactNumber]= '" + data1.ContactNumber + "' " +
"WHERE [SupplierId]=" + data1.SupplierId + " ";
SqlHelper.ExecuteReader(clsUtil.ConnectionString, CommandType.Text, strQuery);
MessageBox.Show("Update Data Sucessfully .");
ClearAllData();
}
