public void InsertUpdateJobMaterial(DataTable dtJobMaterial, JobMaterialField jmf) { foreach (DataRow dr in dtJobMaterial.Rows) { jmdc.INSUPDJobMaterial(int.Parse(dr["JobId"].ToString()), int.Parse(dr["MaterialId"].ToString()), int.Parse(dr["AttributeId"].ToString()), int.Parse(dr["ValueId"].ToString()), dr["Value"].ToString()); } jmdc.JobMaterialFields.InsertOnSubmit(jmf); jmdc.SubmitChanges(); }
private void btnSave_Click(object sender, RoutedEventArgs e) { try { foreach (DataRow dr in dtMaterialAttributes.Rows) { if (Convert.ToInt32(dr["TypeId"]) == 2) { IEnumerator <ComboBox> controls = this.dynamicsCanvas.Children.OfType <ComboBox>().GetEnumerator(); controls.MoveNext(); while (controls.Current != null) { if (controls.Current.Name == dr["ControlName"].ToString()) { ComboBox comboChild = (ComboBox)controls.Current; dr["ValueId"] = Convert.ToInt32(comboChild.SelectedValue); dr["value"] = string.Empty; break; } controls.MoveNext(); } } else { IEnumerator <TextBox> controls = this.dynamicsCanvas.Children.OfType <TextBox>().GetEnumerator(); controls.MoveNext(); while (controls.Current != null) { if (controls.Current.Name == dr["ControlName"].ToString()) { TextBox txtChild = (TextBox)controls.Current; dr["Value"] = txtChild.Text; dr["ValueId"] = 0; break; } controls.MoveNext(); } } } JobMaterialField jmf = new JobMaterialField(); jmf.JobId = jobId; jmf.MaterialId = int.Parse(this.cmbMaterial.SelectedValue.ToString()); jmf.Quantity = int.Parse(this.txtQty.Text); da.InsertUpdateJobMaterial(dtMaterialAttributes, jmf); MessageBox.Show("Selected Material Successfully added to the Job"); LoadMaterialCombo(); var myObject = this.Owner as JobDetails; myObject.LoadJobDetails(); } catch (Exception ex) { if (ex.InnerException != null) { MessageBox.Show("Message:" + ex.Message + "Inner Message:" + ex.InnerException.Message); } MessageBox.Show(ex.Message); } }