private void LoadSubZone()
{
SubZoneBL objsubzone = new SubZoneBL()
{
ZoneID = Convert.ToInt32(txtZoneID.SelectedValue)
};
var dt = objsubzone.SearchByZone();
if (dt != null)
{
txtSubZone.DataSource = dt;
txtSubZone.DisplayMember = "SubRouteName";
txtSubZone.ValueMember = "SubROuteId";
}
else
{
MessageBox.Show("No Record Found");
}
}
private void LoadData()
{
SubZoneBL obJBl = new SubZoneBL();
var dt = obJBl.Select();
if (dt != null)
{
//DataGridViewImageColumn edit = new DataGridViewImageColumn();
//edit.Image = Properties.Resources.edit;
//edit.ImageLayout = DataGridViewImageCellLayout.Zoom;
//edit.HeaderText = "Edit";
//DataGridViewImageColumn delete = new DataGridViewImageColumn();
//delete.Image = Properties.Resources.delete;
//delete.ImageLayout = DataGridViewImageCellLayout.Zoom;
//delete.HeaderText = "Delete";
//edit.Width = delete.Width = 20;
//dgvSubZone.Columns.Add(edit);
//dgvSubZone.Columns.Add(delete);
dgvSubZone.DataSource = dt;
dgvSubZone.Columns["ZoneID"].Visible = false;
dgvSubZone.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (FormValidate() == true)
{
SubZoneBL objBl = new SubZoneBL()
{
ZoneID = Convert.ToInt32(txtZone.SelectedValue),
SubRouteName = txtSubZoneName.Text
};
objBl.Save();
MessageBox.Show("Record Saved Successfull");
ClearGroup();
formDisable();
btnAddnew.Enabled = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
//private void btnSearch_Click(object sender, EventArgs e)
//{
// if(!string.IsNullOrEmpty(txtSearch.Text))
// {
// SubZoneBL objBl = new SubZoneBL()
// {
// SubRouteName = txtSearch.Text
// };
// var dt = objBl.SearchByName();
// if(dt!= null)
// {
// }
// }
//}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
if (txtSearch.Text == string.Empty)
{
LoadData();
}
else
{
SubZoneBL objTest = new SubZoneBL()
{
SubRouteName = txtSearch.Text.ToLower()
};
var dt = objTest.SearchByName();
AutoCompleteStringCollection coll = new AutoCompleteStringCollection();
txtSearch.AutoCompleteMode = AutoCompleteMode.Suggest;
txtSearch.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtSearch.AutoCompleteCustomSource = coll;
if (dt.Count > 0)
{
dgvSubZone.DataSource = dt;
}
}
}
