public clsProductInfo CreateData(clsProductInfo data)
{
data.Name = txtProductName.Text.ToString().Trim();
data.TypeId = Convert.ToInt32(cmbProductTypeID.Text.ToString().Trim());
data.UnitId = Convert.ToInt32(cmbUnitID.Text.ToString().Trim());
data.Price = Convert.ToDouble(txtPrice.Text.ToString().Trim());
data.companyName = txtCompanyName.Text.ToString().Trim();
return(data);
}
private void btnSave_Click(object sender, EventArgs e)
{
String strQuery = "";
clsProductInfo data = new clsProductInfo();
data = CreateData(data);
strQuery = "Insert into tbl_ProductInFo(Name,TypeId,UnitId,Price,CompanyName) values('" + data.Name + "','" + data.TypeId + "','" + data.UnitId + "','" + data.Price + "','" + data.CompanyName + "')";
SqlHelper.ExecuteNonQuery(clsUtil.ConnectionString, CommandType.Text, strQuery);
MessageBox.Show("Save Data Sucessfully .");
ClearAllData();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
String strQuery = "";
clsProductInfo data1 = new clsProductInfo();
data1 = UpdateData(data1);
strQuery = " UPDATE [tbl_ProductInFo] " +
"SET [Name] ='" + data1.Name + "'" +
",[TypeId]=' " + data1.TypeId + "' " +
",[UnitId]= '" + data1.UnitId + "' " +
",[CompanyName]= '" + data1.CompanyName + "' " +
",[Price]= '" + data1.Price + "' " +
"WHERE [ProductId]=" + data1.ProductId + " ";
SqlHelper.ExecuteReader(clsUtil.ConnectionString, CommandType.Text, strQuery);
MessageBox.Show("Update Data Sucessfully .");
ClearAllData();
}
