/// <summary>
 /// Function to fill ModelNo combobox
 /// </summary>
 public void ModelNoComboFill()
 {
     try
     {
         List<DataTable> listObj = new List<DataTable>();
         ModelNoBll BllModelNo = new ModelNoBll();
         listObj = BllModelNo.ModelNoViewAll();
         DataRow dr = listObj[0].NewRow();
         dr["modelno"] = "All";
         dr["modelNoId"] = 0;
         listObj[0].Rows.InsertAt(dr, 0);
         cmbModelNo.DataSource = listObj[0];
         cmbModelNo.DisplayMember = "modelNo";
         cmbModelNo.ValueMember = "modelNoId";
     }
     catch (Exception ex)
     {
         MessageBox.Show("ST:3" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
 }
 /// <summary>
 /// Function to fill datagridview
 /// </summary>
 public void Gridfill()
 {
     try
     {
         List<DataTable> listModelNo = new List<DataTable>();
         ModelNoBll BllModelNo = new ModelNoBll();
         listModelNo = BllModelNo.ModelNoOnlyViewAll();
         dgvModalNo.DataSource = listModelNo[0];
     }
     catch (Exception ex)
     {
         MessageBox.Show("MN2" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
 }
 /// <summary>
 /// Function to save
 /// </summary>
 public void SaveFunction()
 {
     try
     {
         ModelNoBll BllModelNo = new ModelNoBll();
         ModelNoInfo infoModelNo = new ModelNoInfo();
         infoModelNo.ModelNo = txtModalNo.Text.Trim();
         infoModelNo.Narration = txtNarration.Text.Trim();
         infoModelNo.Extra1 = string.Empty;
         infoModelNo.Extra2 = string.Empty;
         if (BllModelNo.ModelCheckIfExist(txtModalNo.Text.Trim().ToString(), 0) == false)
         {
             decIdForOtherForms = BllModelNo.ModelNoAddWithDifferentModelNo(infoModelNo);
             if (decIdForOtherForms > 0)
             {
                 Messages.SavedMessage();
                 Clear();
             }
         }
         else
         {
             Messages.InformationMessage("Model number already exist");
             txtModalNo.Focus();
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show("MN3" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
 }
 /// <summary>
 /// Function to fill controls for update
 /// </summary>
 public void FillControls()
 {
     try
     {
         ModelNoInfo infoModelNo = new ModelNoInfo();
         ModelNoBll BllModelNo = new ModelNoBll();
         infoModelNo = BllModelNo.ModelNoWithNarrationView(Convert.ToDecimal(dgvModalNo.CurrentRow.Cells[1].Value.ToString()));
         txtModalNo.Text = infoModelNo.ModelNo;
         txtNarration.Text = infoModelNo.Narration;
         btnSave.Text = "Update";
         btnDelete.Enabled = true;
         decModelNo = infoModelNo.ModelNoId;
         strModelNo = infoModelNo.ModelNo;
     }
     catch (Exception ex)
     {
         MessageBox.Show("MN8" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
 }
 /// <summary>
 /// Function to edit
 /// </summary>
 public void EditFunction()
 {
     try
     {
         ModelNoBll BllModelNo = new ModelNoBll();
         ModelNoInfo infoModelNo = new ModelNoInfo();
         infoModelNo.ModelNo = txtModalNo.Text.Trim();
         infoModelNo.Narration = txtNarration.Text.Trim();
         infoModelNo.Extra1 = string.Empty;
         infoModelNo.Extra2 = string.Empty;
         infoModelNo.ModelNoId = Convert.ToDecimal(dgvModalNo.CurrentRow.Cells[1].Value.ToString());
         if (txtModalNo.Text != strModelNo)
         {
             if (BllModelNo.ModelCheckIfExist(txtModalNo.Text.Trim(), decModelNo) == false)
             {
                 if (BllModelNo.ModelNoEditParticularFeilds(infoModelNo))
                 {
                     Messages.UpdatedMessage();
                     Clear();
                 }
                 else if (infoModelNo.ModelNoId == 1)
                 {
                     Messages.InformationMessage("Cannot update");
                     Clear();
                     txtModalNo.Focus();
                 }
             }
             else
             {
                 Messages.InformationMessage("Model number already exist");
                 txtModalNo.Focus();
             }
         }
         else
         {
             BllModelNo.ModelNoEditParticularFeilds(infoModelNo);
             Messages.UpdatedMessage();
             Clear();
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show("MN4" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
 }
 /// <summary>
 /// Function to delete
 /// </summary>
 public void DeleteFunction()
 {
     try
     {
         ModelNoBll BllModelNo = new ModelNoBll();
         if (BllModelNo.ModelNoCheckReferenceAndDelete(decModelNo) <= 0)
         {
             Messages.ReferenceExistsMessage();
         }
         else
         {
             BllModelNo.ModelNoDelete(Convert.ToDecimal(dgvModalNo.CurrentRow.Cells[1].Value.ToString()));
             Clear();
             Messages.DeletedMessage();
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show("MN6" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
 }
 //-------------------------------------------------------------ModelNoComboFill---------------------------
 public void ModelNoComboFill()
 {
     try
     {
         List<DataTable> listObj = new List<DataTable>();
         ModelNoBll BllModelNo = new ModelNoBll();
         listObj = BllModelNo.ModelNoViewAll();
         cmbModalNo.DataSource = listObj[0];
         cmbModalNo.DisplayMember = "modelNo";
         cmbModalNo.ValueMember = "modelNoId";
         cmbModalNo.SelectedValue = 1;
     }
     catch (Exception ex)
     {
         MessageBox.Show("PC:44" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
 }
 /// <summary>
 /// Function to fill ModelNo combobox
 /// </summary>
 public void ModelComboFill()
 {
     try
     {
         ModelNoBll BllModelNo = new ModelNoBll();
         dtblModelNo = BllModelNo.ModelNoViewAll();
         dgvcmbModel.DataSource = dtblModelNo[0];
         dgvcmbModel.ValueMember = "modelNoId";
         dgvcmbModel.DisplayMember = "modelNo";
         SettingsBll BllSettings = new SettingsBll();
         if (BllSettings.SettingsStatusCheck("ShowModelNo") == "Yes")
         {
             dgvcmbModel.ReadOnly = false;
         }
         else
         {
             dgvcmbModel.ReadOnly = true;
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show("MPC7:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
 }