//this is for updating
private void btnEdit_Click(object sender, EventArgs e)
{
try
{
if (dgvState.RowCount != 0)
{
StateDialog dlgState = new StateDialog();
dlgState.CountryName = (dgvState.SelectedRows[0].Cells[2].Value).ToString();
dlgState.stateName = (dgvState.SelectedRows[0].Cells[3].Value).ToString();
dlgState.IsActive = (bool)(dgvState.SelectedRows[0].Cells[4].Value);
int stateId = (int)(dgvState.SelectedRows[0].Cells[0].Value);
StateBO objStateBO = new StateBO();
StateData objStateData = new StateData();
if (dlgState.ShowDialog() == DialogResult.OK)
{
objStateData.StateId = stateId;
objStateData.FKCountryId = dlgState.countryId;
objStateData.StateName = dlgState.stateName;
objStateData.IsActive = dlgState.IsActive;
objStateBO.UpdateInState(objStateData);
}
}
}
catch
{
MessageBox.Show("error at edit form");
}
dgvState.DataSource = StateBO.GetStates();
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (dgvState.RowCount != 0)
{
int stateId = (int)(dgvState.SelectedRows[0].Cells[0].Value);
StateDialog dlgState = new StateDialog();
StateBO objStateBO = new StateBO();
//update the records
State objState = objStateBO.GetState(stateId);
dlgState.CountryId = objState.CountryId;
dlgState.StateName = objState.StateName;
dlgState.IsActive = objState.IsActive;
if (dlgState.ShowDialog() == DialogResult.OK)
{
try
{
if (!(objState.StateName == dlgState.StateName))
{
objStateBo.IsStateExist(dlgState.CountryName, dlgState.StateName);
}
objStateBO.UpdateState(objState.StateId, objState.CountryId, dlgState.StateName, dlgState.IsActive);
}
catch (Exception EX)
{
MessageBox.Show(EX.Message);
}
BindGridView();
}
}
}
//filling the combe box in the form
public void FillInCombo()
{
cmbStateName.DisplayMember = "StateName";
cmbUserName.DisplayMember = "UserName";
cmbStateName.ValueMember = "PKStateId";
cmbUserName.ValueMember = "PKUserId";
cmbUserName.DataSource = UserBO.GetUser();
cmbStateName.DataSource = StateBO.GetStates();
}
internal static StateBO Map(State Row)
{
StateBO StateBO = new StateBO();
StateBO.StateCode = Row.StateCode;
StateBO.StateName = Row.StateName;
StateBO.StateId = Row.StateProvinceId;
return(StateBO);
}
private void StateForm_Load(object sender, EventArgs e)
{
dgvState.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dgvState.AutoGenerateColumns = false;
dgvState.ReadOnly = true;
dgvState.AllowUserToAddRows = false;
dgvState.AllowUserToDeleteRows = false;
dgvState.AllowUserToOrderColumns = false;
dgvState.MultiSelect = false;
dgvState.DataSource = StateBO.GetStates();
}
private void btnFilter_Click(object sender, EventArgs e)
{
int id = (int)cmbCountryId.SelectedValue;
if (cmbIsActive.SelectedIndex == 0)
{
dgvState.DataSource = StateBO.FilteredResultState(id, true);
}
if (cmbIsActive.SelectedIndex == 1)
{
dgvState.DataSource = StateBO.FilteredResultState(id, false);
}
}
private void cmbCountry_SelectedIndexChanged(object sender, EventArgs e)
{
cmbState.DisplayMember = "StateName";
cmbState.ValueMember = "PKStateId";
DataSet ds = new StateBO().GetActiveStates(Convert.ToInt32(cmbCountry.SelectedValue));
int rowCount = ds.Tables[0].Rows.Count;
if (rowCount != 0)
{
cmbState.DataSource = ds.Tables[0];
}
else
{
cmbState.DataSource = null;
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (dgvState.RowCount != 0)
{
DialogResult dr;
dr = MessageBox.Show("Are you sure?If you delete state corresponding addresses will get deleted", "Delete", MessageBoxButtons.YesNo);
if (dr == System.Windows.Forms.DialogResult.No)
{
return;
}
int StateId = (int)dgvState.SelectedRows[0].Cells[0].Value;
StateBO objStateBO = new StateBO();
objStateBO.DeleteState(StateId);
BindGridView();
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
StateDialog dlgState = new StateDialog();
if (dlgState.ShowDialog() == DialogResult.OK)
{
StateBO objstateBO = new StateBO();
objstateBO.InsertInState(dlgState.countryId, dlgState.stateName, dlgState.IsActive);
dgvState.DataSource = StateBO.GetStates();
}
}
catch
{
MessageBox.Show("Error in state form");
}
}
public void BindGridView()
{
try
{
DataSet ds;
StateBO objStateBO = new StateBO();
ds = objStateBO.GetStates(-1);
dgvState.DataSource = ds.Tables[0];
}
catch (System.Data.SqlClient.SqlException)
{
MessageBox.Show("1.Check the Connection Connection string ", "Unable to connect database ");
}
catch (Exception)
{
MessageBox.Show("connection string is invalid");
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (dgvState.RowCount != 0)
{
DialogResult dr;
dr = MessageBox.Show("Are you sure?", "Delete", MessageBoxButtons.YesNo);
if (dr == DialogResult.No)
{
return;
}
else
{
int stateId = (int)(dgvState.SelectedRows[0].Cells[0].Value);
StateBO objStateBO = new StateBO();
objStateBO.DeleteInState(stateId);
}
}
dgvState.DataSource = StateBO.GetStates();
}
private void btnAdd_Click(object sender, EventArgs e)
{
StateDialog dlgState = new StateDialog();
if (dlgState.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
try
{
StateBO objStateBO = new StateBO();
State objState = new State();
objStateBo.IsStateExist(dlgState.CountryName, dlgState.StateName);
objStateBO.InsertState(Convert.ToInt32(dlgState.CountryId), dlgState.StateName, dlgState.IsActive);
BindGridView();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void btnReset_Click(object sender, EventArgs e)
{
dgvState.DataSource = StateBO.GetStates();
}
