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);
}
}
