protected void UpdateCompanyBtn_Click(object sender, EventArgs e)
{
Company company = new Company();
company.CompanyName = addCompanyTextBox.Text;
company.CompanyId = Convert.ToInt32(CompanyIdHiddenField.Value);
if (string.IsNullOrEmpty(addCompanyTextBox.Text))
{
Response.Write("<script>alert('Input Field is empty');</script>");
}
else
{
if (companySetupBll.Update(company) > 0)
{
Response.Write("<script>alert('updated');</script>");
}
}
List <Company> companies = companySetupBll.GetCompanies();
CompanyGridView.DataSource = companies;
CompanyGridView.DataBind();
UpdateCompanyBtn.Enabled = false;
saveCompanyBtn.Enabled = true;
}
protected void Page_Load(object sender, EventArgs e)
{
List <Company> companies = companySetupBll.GetCompanies();
CompanyGridView.DataSource = companies;
CompanyGridView.DataBind();
if (!this.IsPostBack)
{
UpdateCompanyBtn.Enabled = false;
saveCompanyBtn.Enabled = true;
}
}
void BindData(string key)
{
string sql = "";
try
{
sql = "SELECT * FROM tbl_company WHERE company_status <> 1 AND company_name Like '%" + key + "%' ORDER BY company_name ASC";
MySqlDataAdapter da = function.MySqlSelectDataSet(sql);
System.Data.DataSet ds = new System.Data.DataSet();
da.Fill(ds);
CompanyGridView.DataSource = ds.Tables[0];
CompanyGridView.DataBind();
lbDeviceNull.Text = "พบข้อมูลจำนวน " + ds.Tables[0].Rows.Count + " แถว";
}
catch { }
}
protected void saveCompanyBtn_Click(object sender, EventArgs e)
{
Company company = new Company();
company.CompanyName = addCompanyTextBox.Text;
if (string.IsNullOrEmpty(addCompanyTextBox.Text))
{
Response.Write("<script>alert('Input Field is empty');</script>");
}
else
{
Response.Write("<script>alert('" + companySetupBll.Save(company) + "');</script>");
}
List <Company> companies = companySetupBll.GetCompanies();
CompanyGridView.DataSource = companies;
CompanyGridView.DataBind();
}
