private void btnUpdate_Click(object sender, EventArgs e)
{
if (txtSearch.Text == string.Empty)
{
MessageBox.Show("Please Select A Zone ID ");
return;
}
else if (MessageBox.Show("Are You Sure To Update Zone?", "UpdateAlert", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
ZoneBL objCate = new ZoneBL()
{
ZoneId = Convert.ToInt32(txtZoneID.Text),
ZoneName = txtZoneName.Text
};
objCate.Update();
MessageBox.Show("Zone Update Successfull");
ClearGroup();
loadData();
}
else
{
MessageBox.Show("Zone Not Update");
}
}
private void LoadZone()
{
ZoneBL objBl = new ZoneBL();
var dt = objBl.Select();
txtZone.DataSource = dt;
txtZone.DisplayMember = "ZoneName";
txtZone.ValueMember = "ZoneID";
}
private void LoadZoneID()
{
ZoneBL objZone = new ZoneBL();
var dt = objZone.Select();
txtZoneID.DataSource = dt;
txtZoneID.AutoCompleteMode = AutoCompleteMode.Suggest;
txtZoneID.AutoCompleteSource = AutoCompleteSource.ListItems;
txtZoneID.DisplayMember = "ZoneName";
txtZoneID.ValueMember = "ZoneID";
}
private void LoadRoute()
{
ZoneBL obj = new ZoneBL();
var dt = obj.Select();
txtRoute.DataSource = dt;
txtRoute.AutoCompleteMode = AutoCompleteMode.Suggest;
txtRoute.AutoCompleteSource = AutoCompleteSource.ListItems;
txtRoute.DisplayMember = "ZoneName";
txtRoute.ValueMember = "ZoneId";
txtRoute.Text = "---Select---";
}
private void btnAddnew_Click(object sender, EventArgs e)
{
ZoneBL objZone = new ZoneBL();
DataTable dt = objZone.Addnew();
if (dt.Rows.Count > 0)
{
txtZoneID.Text = Convert.ToString(dt.Rows[0]["ZoneID"]);
btnSave.Enabled = true;
txtZoneName.Enabled = true;
txtZoneName.Focus();
btnAddnew.Enabled = false;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (FormValidate() == true)
{
ZoneBL objZone = new ZoneBL()
{
ZoneName = txtZoneName.Text
};
objZone.Save();
MessageBox.Show("Record Save Successfull");
loadData();
btnAddnew.Enabled = true;
ClearGroup();
}
else
{
MessageBox.Show("Some Error Occur No Record Save");
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
string message = "Are You Sure To Delete Zone " + txtZoneName.Text + "?";
if (MessageBox.Show(message, "Delete Alert", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
ZoneBL objCate = new ZoneBL()
{
ZoneId = Convert.ToInt32(txtSearch.Text)
};
objCate.Delete();
MessageBox.Show("Record Delete Successfull");
loadData();
ClearGroup();
}
else
{
MessageBox.Show("No Record Deleted");
}
}
private void loadData()
{
ZoneBL objzone = new ZoneBL();
List <tbl_Zone> dt = objzone.Select();
dgvZone.Columns.Clear();
if (dt != null && dt.Count > 0)
{
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;
dgvZone.Columns.Add(edit);
dgvZone.Columns.Add(delete);
dgvZone.DataSource = dt;
dgvZone.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
if (txtSearch.Text == string.Empty)
{
loadData();
}
else
{
ZoneBL objTest = new ZoneBL()
{
ZoneName = 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)
{
dgvZone.DataSource = dt;
}
}
}
private void dgvZone_CellContentClick_1(object sender, DataGridViewCellEventArgs e)
{
int rowindex = e.RowIndex;
int Columnindex = e.ColumnIndex;
if (Columnindex == 0)
{
txtZoneID.Text = dgvZone.Rows[rowindex].Cells[2].Value.ToString();
txtZoneName.Text = dgvZone.Rows[rowindex].Cells[3].Value.ToString();
txtZoneName.Enabled = true;
}
else if (Columnindex == 1)
{
ZoneBL objcate = new ZoneBL()
{
ZoneId = Convert.ToInt32(dgvZone.Rows[rowindex].Cells[2].Value)
};
objcate.Delete();
MessageBox.Show("Deleted Successfully");
loadData();
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
if (txtSearch.Text == string.Empty)
{
MessageBox.Show("Please Enter An ID");
}
else if (!string.IsNullOrEmpty(txtSearch.Text))
{
ZoneBL objZone = new ZoneBL()
{
ZoneId = Convert.ToInt32(txtSearch.Text)
};
var dt = objZone.Search();
if (dt != null)
{
dgvZone.DataSource = dt;
txtZoneName.Enabled = true;
}
}
else
{
MessageBox.Show("No Record Found OR Empty");
}
}
