void AddUpdateData() { try { ep1.Clear(); if (string.IsNullOrEmpty(cmbItemSetName.Text.Trim())) { ep1.SetError(cmbItemSetName, "This field is Required.."); cmbItemSetName.Focus(); return; } if (string.IsNullOrEmpty(cmbItemName.Text.Trim())) { ep1.SetError(cmbItemName, "This field is Required.."); cmbItemName.Focus(); return; } if (string.IsNullOrEmpty(txtQTY.Text.Trim())) { ep1.SetError(txtQTY, "This field is Required.."); txtQTY.Focus(); return; } MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); int?Iout = 0; int TM01_MAIN_PRODUCTID = 0, TM01_PRODUCTID = 0, TM02_PRODUCTSIZEID = 0, TM02_MAIN_PRODUCTSIZEID = 0; int.TryParse(cmbItemSetName.SelectedValue.ToString(), out TM01_MAIN_PRODUCTID); // int.TryParse(cmbMainItemSize.SelectedValue.ToString(), out TM02_MAIN_PRODUCTSIZEID); int.TryParse(cmbItemName.SelectedValue.ToString(), out TM01_PRODUCTID); // int.TryParse(cmbItemSize.SelectedValue.ToString(), out TM02_PRODUCTSIZEID); int TM03_QTY = 0; int.TryParse(txtQTY.Text.Trim(), out TM03_QTY); MyDa.USP_VP_ADDUPDATE_PRODUCTITEM(Datalayer.iTM03_PRODUCTITEMID, TM01_MAIN_PRODUCTID, TM01_PRODUCTID, TM03_QTY, Datalayer.iT001_COMPANYID, ref Iout); if (Iout > 0) { if (Datalayer.iTM03_PRODUCTITEMID == 0) { Datalayer.InsertMessageBox(sPageName); } else { Datalayer.UpdateMessageBox(sPageName); } } else { if (Datalayer.iTM03_PRODUCTITEMID == 0) { Datalayer.DosenotInsertMessageBox(sPageName); } else { Datalayer.DosenotUpdateMessageBox(sPageName); } } ResetData(); } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }