/// <summary>
/// Function to fill the Area combobox
/// </summary>
public void AreaComboFill()
{
try
{
RouteBll BllRoute = new RouteBll();
List<DataTable> listObj = new List<DataTable>();
listObj = BllRoute.AreafillInRoute();
cmbArea.DataSource = listObj[0];
cmbArea.ValueMember = "areaId";
cmbArea.DisplayMember = "areaName";
cmbArea.SelectedIndex = -1;
}
catch (Exception ex)
{
MessageBox.Show("RT1" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// creating a default route under the creating area
/// </summary>
public void RouteNACreateUnderTheArea()
{
try
{
RouteBll BllRoute = new RouteBll();
RouteInfo infoRoute = new RouteInfo();
infoRoute.RouteName = "NA";
infoRoute.AreaId = decAreaId;
infoRoute.Narration = txtNarration.Text.Trim();
infoRoute.Extra1 = string.Empty;
infoRoute.Extra2 = string.Empty;
infoRoute.ExtraDate = DateTime.Today;
BllRoute.RouteAdd(infoRoute);
}
catch (Exception ex)
{
MessageBox.Show("AR2" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Area combobox fill for Search
/// </summary>
public void AreaComboFillSearch()
{
try
{
RouteBll BllRoute = new RouteBll();
List<DataTable> listObj = new List<DataTable>();
listObj = BllRoute.AreafillInRoute();
DataRow dr = listObj[0].NewRow();
dr[1] = "All";
listObj[0].Rows.InsertAt(dr, 0);
cmbAreaSearch.DataSource = listObj[0];
cmbAreaSearch.ValueMember = "areaId";
cmbAreaSearch.DisplayMember = "areaName";
}
catch (Exception ex)
{
MessageBox.Show("RT2" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// On double clicking on the datagridview, It displays the details of the rack to edit or delete
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvRoute_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex != -1)
{
if (dgvRoute.Rows[e.RowIndex].Cells["dgvtxtRouteName"].Value.ToString() != "NA")
{
RouteBll BllRoute = new RouteBll();
RouteInfo infoRoute = new RouteInfo();
infoRoute = BllRoute.RouteView(Convert.ToDecimal(dgvRoute.CurrentRow.Cells["dgvtxtRouteId"].Value.ToString()));
decRouteId = Convert.ToDecimal(dgvRoute.CurrentRow.Cells["dgvtxtRouteId"].Value.ToString());
txtRouteName.Text = infoRoute.RouteName;
cmbArea.SelectedValue = infoRoute.AreaId.ToString();
txtNarration.Text = infoRoute.Narration;
btnSave.Text = "Update";
btnDelete.Enabled = true;
txtRouteName.Focus();
}
else
{
Messages.InformationMessage("Default Route cannot update or delete");
Clear();
}
}
}
catch (Exception ex)
{
MessageBox.Show("RT19" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to save the new route
/// </summary>
public void SaveFunction()
{
try
{
RouteBll BllRoute = new RouteBll();
RouteInfo infoRoute = new RouteInfo();
infoRoute.RouteName = txtRouteName.Text.Trim();
infoRoute.AreaId = Convert.ToDecimal(cmbArea.SelectedValue.ToString());
infoRoute.Narration = txtNarration.Text.Trim();
infoRoute.Extra1 = String.Empty;
infoRoute.Extra2 = String.Empty;
if (BllRoute.RouteCheckExistence(txtRouteName.Text.Trim(), 0, Convert.ToDecimal(cmbArea.SelectedValue.ToString())) == false)
{
decRoute = BllRoute.RouteAddParticularFields(infoRoute);
{
Messages.SavedMessage();
Clear();
GridFill();
if (frmCustomerobj != null)
{
this.Close();
}
}
}
else
{
Messages.InformationMessage(" Route name already exist");
txtRouteName.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show("RT4" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill all Routes in datagridview based on the search key
/// </summary>
public void GridFill()
{
try
{
RouteBll BllRoute = new RouteBll();
List<DataTable> listObj = new List<DataTable>();
listObj = BllRoute.RouteSearch(txtRouteNameSearch.Text.Trim(), cmbAreaSearch.Text.ToString());
dgvRoute.DataSource = listObj[0];
}
catch (Exception ex)
{
MessageBox.Show("RT3" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to edit already existing route
/// </summary>
public void EditFunction()
{
try
{
RouteBll BllRoute = new RouteBll();
RouteInfo infoRoute = new RouteInfo();
infoRoute.RouteName = txtRouteName.Text.Trim();
infoRoute.AreaId = Convert.ToDecimal(cmbArea.SelectedValue.ToString());
infoRoute.Narration = txtNarration.Text.Trim();
infoRoute.Extra1 = String.Empty;
infoRoute.Extra2 = String.Empty;
infoRoute.RouteId = decRouteId;
if (BllRoute.RouteCheckExistence(txtRouteName.Text.Trim(), decRouteId, Convert.ToDecimal(cmbArea.SelectedValue.ToString())) == false)
{
if (BllRoute.RouteEditing(infoRoute))
{
Messages.UpdatedMessage();
GridFill();
Clear();
}
else if (infoRoute.RouteId == 1)
{
Messages.InformationMessage("Cannot update");
Clear();
txtRouteName.Focus();
}
}
else
{
Messages.InformationMessage(" Route name already exist");
txtRouteName.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show("RT5" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to Delete the Route
/// </summary>
public void DeleteFunction()
{
try
{
RouteBll BllRoute = new RouteBll();
if (BllRoute.RouteDeleting(decRouteId) == -1)
{
Messages.ReferenceExistsMessage();
}
else
{
Messages.DeletedMessage();
GridFill();
Clear();
}
}
catch (Exception ex)
{
MessageBox.Show("RT7" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
///Function to fill route combobox
/// </summary>
public void RouteComboFill()
{
try
{
if (cmbArea.Items.Count > 0)
{
if (cmbArea.SelectedIndex != -1)
{
if (cmbArea.SelectedValue.ToString() != "System.Data.DataRowView" && cmbArea.Text != "System.Data.DataRowView")
{
RouteBll BllRoute = new RouteBll();
List<DataTable> listObjRoute = new List<DataTable>();
listObjRoute = BllRoute.RouteViewByArea(Convert.ToDecimal(cmbArea.SelectedValue.ToString()));
cmbRoute.DataSource = listObjRoute[0];
cmbRoute.ValueMember = "routeId";
cmbRoute.DisplayMember = "routeName";
cmbRoute.SelectedIndex = 0;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("AL12:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill Route combobox
/// </summary>
public void RouteViewForComboFill()
{
try
{
RouteBll BllRoute = new RouteBll();
List<DataTable> listObj = BllRoute.RouteViewForComboFill();
cmbRoute.DataSource = listObj[0];
cmbRoute.DisplayMember = "routeName";
cmbRoute.ValueMember = "routeId";
cmbRoute.SelectedIndex = 0;
}
catch (Exception ex)
{
MessageBox.Show("SORP7:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}