private void btn_save_Click(object sender, EventArgs e) { try { if (txt_ItemName.Text.Length == 0) { MsgBox.Error("Please enter item name"); } else if (cmb_ItemType.Text.Length == 0) { MsgBox.Error("Please Select item type "); } else if (txt_purchasePrice.Text.Length == 0) { MsgBox.Error(" Please enter purchase price "); } else { MapItemData obj = new MapItemData(); obj.itemID = Reference; if (obj.select() == 1) { if (MsgBox.Question("This item already in the item file do you need to change the item ?") == System.Windows.Forms.DialogResult.Yes) { new UI.UpdateItemForm().ShowDialog(); } } else { if (DbBackValue == 0) { obj.EmployeeID = Login.EmployeeID; obj.WarehouseCode = warehouseCode.Text; obj.ItemName = txt_ItemName.Text; obj.ItemType = cmb_ItemType.Text; obj.ItemDesc = txt_ItemDesc.Text; obj.DateTime = dtp_Date.Value.ToString(); obj.BatchID = txt_batchNo.Text; obj.ManifacturingDate = dtp_mfgDate.Value.Date.ToString().Substring(0, 9); obj.ExpireDate = dtp_expDate.Value.Date.ToString().Substring(0, 9); obj.PurchasePrice = Convert.ToDouble(txt_purchasePrice.Text); obj.CashInWoleSale = Convert.ToDouble(txt_cashWholeSale.Text); obj.VatPercentage = Convert.ToDouble(txt_Vat.Text); obj.VatAmount = Convert.ToDouble(txt_taxAmt.Text); obj.TotalPurchase = Convert.ToInt32(txt_totPurchaseQty.Text); obj.TotalQuantity = Convert.ToInt32(txt_totQty.Text); obj.NetAmount = Convert.ToDouble(txt_netAmount.Text); } else { obj.itemID = Reference; obj.EmployeeID = Login.EmployeeID; obj.WarehouseCode = warehouseCode.Text; obj.ItemName = txt_ItemName.Text; obj.ItemType = cmb_ItemType.Text; obj.ItemDesc = txt_ItemDesc.Text; obj.DateTime = dtp_Date.Value.ToString(); obj.BatchID = txt_batchNo.Text; obj.ManifacturingDate = dtp_mfgDate.Value.Date.ToString().Substring(0, 9); obj.ExpireDate = dtp_expDate.Value.Date.ToString().Substring(0, 9); obj.PurchasePrice = Convert.ToDouble(txt_purchasePrice.Text); obj.CashInWoleSale = Convert.ToDouble(txt_cashWholeSale.Text); obj.VatPercentage = Convert.ToDouble(txt_Vat.Text); obj.VatAmount = Convert.ToDouble(txt_taxAmt.Text); obj.TotalPurchase = Convert.ToInt32(txt_totPurchaseQty.Text); obj.TotalQuantity = Convert.ToInt32(txt_totQty.Text); obj.NetAmount = Convert.ToDouble(txt_netAmount.Text); } int result = obj.save(); if (result == 1) { MsgBox.Show(1); } else { MsgBox.Show(3); } } } } catch (Exception ex) { MsgBox.Exception(ex); } finally { } }