/// <summary> /// Function to add data to StockTable With Batch /// </summary> public void BatchTableWithStockAndProductBatchFill() { try { BatchSP spBatch = new BatchSP(); BatchInfo infoBatch = new BatchInfo(); StockPostingSP spStockPosting = new StockPostingSP(); StockPostingInfo infoStockPosting = new StockPostingInfo(); for (int inI = 0; inI < dgvProductCreation.RowCount - 1; inI++) { infoBatch.ManufacturingDate = Convert.ToDateTime(dgvProductCreation.Rows[inI].Cells["dgvtxManfDate"].Value); infoBatch.ExpiryDate = Convert.ToDateTime(dgvProductCreation.Rows[inI].Cells["dgvtxtExpDate"].Value); infoBatch.BatchNo = dgvProductCreation.Rows[inI].Cells["dgvtxtbatch"].Value.ToString(); if (btnSave.Text == "Update") { infoBatch.ProductId = decProductIdForEdit; } else { infoBatch.ProductId = decSaveProduct; } infoBatch.Extra1 = string.Empty; infoBatch.Extra2 = string.Empty; infoBatch.ExtraDate = DateTime.Now; infoBatch.narration = string.Empty; infoBatch.barcode = Convert.ToString(spBatch.AutomaticBarcodeGeneration()); decBatchId = spBatch.BatchAddReturnIdentity(infoBatch); infoStockPosting.AgainstInvoiceNo = string.Empty; infoStockPosting.AgainstVoucherNo = string.Empty; infoStockPosting.Date = PublicVariables._dtCurrentDate; infoStockPosting.AgainstVoucherTypeId = 0; infoStockPosting.InvoiceNo = Convert.ToString(decSaveProduct); infoStockPosting.VoucherNo = Convert.ToString(decSaveProduct); infoStockPosting.VoucherTypeId = 2; infoStockPosting.UnitId = Convert.ToDecimal(dgvProductCreation.Rows[inI].Cells["dgvcmbUnit"].Value); infoStockPosting.InwardQty = Convert.ToDecimal(dgvProductCreation.Rows[inI].Cells["dgvtxtqty"].Value); infoStockPosting.OutwardQty = 0; infoStockPosting.Rate = Convert.ToDecimal(dgvProductCreation.Rows[inI].Cells["dgvtxtrate"].Value); infoStockPosting.FinancialYearId = PublicVariables._decCurrentFinancialYearId; infoStockPosting.Extra1 = string.Empty; infoStockPosting.Extra2 = string.Empty; infoStockPosting.ExtraDate = DateTime.Now; if ((dgvProductCreation.Rows[inI].Cells["dgvcmbrack"].Visible) == false) { infoStockPosting.RackId = 1; } else { infoStockPosting.RackId = Convert.ToDecimal(dgvProductCreation.Rows[inI].Cells["dgvcmbrack"].Value); } if ((dgvProductCreation.Rows[inI].Cells["dgvcmbtgodown"].Visible) == false) { infoStockPosting.GodownId = 1; } else { infoStockPosting.GodownId = Convert.ToDecimal(dgvProductCreation.Rows[inI].Cells["dgvcmbtgodown"].Value); } if (btnSave.Text == "Update") { infoStockPosting.ProductId = decProductIdForEdit; } else { infoStockPosting.ProductId = decSaveProduct; } if (cmbAllowBatch.SelectedIndex == 0) { infoStockPosting.BatchId = 0; } else { infoStockPosting.BatchId = decBatchId; } decCheck = spStockPosting.StockPostingAdd(infoStockPosting); } } catch (Exception ex) { MessageBox.Show("PC:18" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to save batch /// </summary> public void BatchWithBarCode() { BatchSP spBatch = new BatchSP(); BatchInfo infoBatch = new BatchInfo(); Int32 inBarcode = spBatch.AutomaticBarcodeGeneration(); infoBatch.BatchNo = "NA"; infoBatch.ExpiryDate = DateTime.Now; infoBatch.ManufacturingDate = DateTime.Now; infoBatch.partNo = txtPartNo.Text.Trim(); if (btnSave.Text == "Update") { infoBatch.ProductId = decProductIdForEdit; } else { infoBatch.ProductId = decSaveProduct; } infoBatch.narration = string.Empty; infoBatch.ExtraDate = DateTime.Now; infoBatch.barcode = Convert.ToString(inBarcode); infoBatch.Extra1 = string.Empty; infoBatch.Extra2 = string.Empty; inBatchIdWithPartNoNA = spBatch.BatchAddWithBarCode(infoBatch); }
/// <summary> /// Function to save batch /// </summary> public void BatchTableFill() { try { BatchSP spBatch = new BatchSP(); BatchInfo infoBatch = new BatchInfo(); for (int inI = 0; inI < dgvProductCreation.RowCount - 1; inI++) { infoBatch.ManufacturingDate = Convert.ToDateTime(dgvProductCreation.Rows[inI].Cells["dgvtxManfDate"].Value); infoBatch.ExpiryDate = Convert.ToDateTime(dgvProductCreation.Rows[inI].Cells["dgvtxtExpDate"].Value); infoBatch.BatchNo = dgvProductCreation.Rows[inI].Cells["dgvtxtbatch"].Value.ToString(); infoBatch.barcode = Convert.ToString(spBatch.AutomaticBarcodeGeneration()); if (btnSave.Text == "Update") { infoBatch.ProductId = decProductIdForEdit; } else { infoBatch.ProductId = decSaveProduct; } infoBatch.Extra1 = string.Empty; infoBatch.Extra2 = string.Empty; infoBatch.ExtraDate = DateTime.Now; infoBatch.narration = string.Empty; decBatchId = spBatch.BatchAddAndDelete(infoBatch, decProductIdForEdit); dgvProductCreation.Rows[inI].Cells["dgvtxtbatchId"].Value = decBatchId; } } catch (Exception ex) { MessageBox.Show("PC:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function for New Row Added To tbl_Batch /// </summary> /// <param name="inI"></param> public void BatchTableNewRows(int inI) { try { BatchSP spBatch = new BatchSP(); BatchInfo infoBatch = new BatchInfo(); infoBatch.ManufacturingDate = Convert.ToDateTime(dgvProductCreation.Rows[inI].Cells["dgvtxManfDate"].Value); infoBatch.ExpiryDate = Convert.ToDateTime(dgvProductCreation.Rows[inI].Cells["dgvtxtExpDate"].Value); infoBatch.BatchNo = dgvProductCreation.Rows[inI].Cells["dgvtxtbatch"].Value.ToString(); infoBatch.ProductId = decProductIdForEdit; infoBatch.Extra1 = string.Empty; infoBatch.Extra2 = string.Empty; infoBatch.ExtraDate = DateTime.Now; infoBatch.narration = string.Empty; infoBatch.barcode = Convert.ToString(spBatch.AutomaticBarcodeGeneration()); decimal decId = spBatch.BatchAddReturnIdentity(infoBatch); //decimal decId = spBatch.StockPostingAdd(infoBatch); dgvProductCreation.Rows[inI].Cells["dgvtxtbatchId"].Value = decId; } catch (Exception ex) { MessageBox.Show("PC:73" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
//Jamshi //public void SaveFunction() //{ // try // { // BatchSP spBatch = new BatchSP(); // BatchInfo infoBatch = new BatchInfo(); // infoBatch.BatchNo = txtBatchName.Text.Trim(); // infoBatch.ProductId = Convert.ToDecimal(cmbProduct.SelectedValue.ToString()); // infoBatch.ManufacturingDate = Convert.ToDateTime(txtMfgDate.Text); // infoBatch.ExpiryDate = Convert.ToDateTime(txtExpiryDate.Text); // infoBatch.narration = txtNarration.Text.Trim(); // infoBatch.Extra1 = string.Empty; // infoBatch.Extra2 = string.Empty; // if (spBatch.BatchNameAndProductNameCheckExistence(txtBatchName.Text.Trim(), Convert.ToDecimal(cmbProduct.SelectedValue.ToString()), 0) == false) // { // if (dtpMfgDate.Value <= dtpExpiryDate.Value) // { // spBatch.BatchAddParticularFields(infoBatch); // Messages.SavedMessage(); // Clear(); // } // else // { // Messages.InformationMessage(" Can't save batch with mfg date greater than expiry date"); // txtMfgDate.Select(); // } // } // else // { // Messages.InformationMessage(" Already exist"); // txtBatchName.Focus(); // } // } // catch (Exception ex) // { // MessageBox.Show("B1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); // } //} //public void EditFunction() //{ // try // { // BatchSP spBatch = new BatchSP(); // BatchInfo infoBatch = new BatchInfo(); // infoBatch.BatchNo = txtBatchName.Text.Trim(); // infoBatch.ProductId = Convert.ToDecimal(cmbProduct.SelectedValue.ToString()); // infoBatch.ManufacturingDate = Convert.ToDateTime(txtMfgDate.Text); // infoBatch.ExpiryDate = Convert.ToDateTime(txtExpiryDate.Text); // infoBatch.narration = txtNarration.Text.Trim(); // infoBatch.Extra1 = string.Empty; // infoBatch.Extra2 = string.Empty; // infoBatch.BatchId = decId; // if (spBatch.BatchNameAndProductNameCheckExistence(txtBatchName.Text.Trim(), Convert.ToDecimal(cmbProduct.SelectedValue.ToString()), decBatchId) == false) // { // spBatch.BatchEdit(infoBatch); // Messages.UpdatedMessage(); // SearchClear(); // Clear(); // } // else // { // Messages.InformationMessage("Already exists"); // txtBatchName.Focus(); // } // } // catch (Exception ex) // { // MessageBox.Show("B2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); // } //} /// <summary> /// Functin to save and update batch /// </summary> public void SaveOrEdit() { try { if (txtBatchName.Text.Trim() == string.Empty) { Messages.InformationMessage("Enter batch name"); txtBatchName.Focus(); } else if (cmbProduct.SelectedIndex == -1) { Messages.InformationMessage("Select product"); cmbProduct.Focus(); } else { BatchSP spBatch = new BatchSP(); BatchInfo infoBatch = new BatchInfo(); infoBatch.BatchNo = txtBatchName.Text.Trim(); infoBatch.ProductId = Convert.ToDecimal(cmbProduct.SelectedValue.ToString()); infoBatch.ManufacturingDate = Convert.ToDateTime(txtMfgDate.Text); infoBatch.ExpiryDate = Convert.ToDateTime(txtExpiryDate.Text); infoBatch.narration = txtNarration.Text.Trim(); infoBatch.Extra1 = string.Empty; infoBatch.Extra2 = string.Empty; Int32 inBarcode = spBatch.AutomaticBarcodeGeneration(); // updated by jaseel infoBatch.barcode = Convert.ToString(inBarcode); if (btnSave.Text == "Save") { //Jamshi //if (PublicVariables.isMessageAdd) //{ // if (Messages.SaveMessage()) // { // SaveFunction(); // } //} //else //{ // SaveFunction(); //} if (Messages.SaveConfirmation()) { if (spBatch.BatchNameAndProductNameCheckExistence(txtBatchName.Text.Trim(), Convert.ToDecimal(cmbProduct.SelectedValue.ToString()), 0) == false) { if (dtpMfgDate.Value <= dtpExpiryDate.Value) { spBatch.BatchAddParticularFields(infoBatch); Messages.SavedMessage(); Clear(); } else { Messages.InformationMessage(" Can't save batch with mfg date greater than expiry date"); txtMfgDate.Select(); } } else { Messages.InformationMessage(" Already exist"); txtBatchName.Focus(); } } } else { //Jamshi //if (PublicVariables.isMessageEdit) //{ // if (Messages.UpdateMessage()) // { // EditFunction(); // } //} //else //{ // EditFunction(); //} if (Messages.UpdateConfirmation()) { infoBatch.BatchId = decId; if (spBatch.BatchNameAndProductNameCheckExistence(txtBatchName.Text.Trim(), Convert.ToDecimal(cmbProduct.SelectedValue.ToString()), decBatchId) == false) { spBatch.BatchEdit(infoBatch); Messages.UpdatedMessage(); SearchClear(); Clear(); } else { Messages.InformationMessage("Already exists"); txtBatchName.Focus(); } } } } } catch (Exception ex) { MessageBox.Show("B1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to save /// </summary> public void SaveFunction() { try { int inRowCount = dgvMultipleProductCreation.RowCount; BatchSP spBatch = new BatchSP(); BatchInfo infoBatch = new BatchInfo(); ProductSP spProduct = new ProductSP(); ProductInfo infoProduct = new ProductInfo(); UnitConvertionSP spUnitConvertion = new UnitConvertionSP(); UnitConvertionInfo infoUnitConvertion = new UnitConvertionInfo(); for (int i = 0; i < inRowCount - 1; i++) { infoProduct.GroupId = Convert.ToDecimal(cmbProductGroup.SelectedValue.ToString()); infoProduct.UnitId = Convert.ToDecimal(cmbUnit.SelectedValue.ToString()); infoProduct.TaxId = Convert.ToDecimal(cmbTax.SelectedValue.ToString()); if (cmbGoDown.SelectedIndex != -1) { infoProduct.GodownId = Convert.ToDecimal(cmbGoDown.SelectedValue.ToString()); } else { infoProduct.GodownId = 0; } if (cmbRack.SelectedIndex != -1) { infoProduct.RackId = Convert.ToDecimal(cmbRack.SelectedValue.ToString()); } else { infoProduct.RackId = 0; } infoProduct.MinimumStock = 0; infoProduct.MaximumStock = 0; infoProduct.ReorderLevel = 0; infoProduct.IsallowBatch = false; infoProduct.Ismultipleunit = false; infoProduct.IsBom = false; infoProduct.Isopeningstock = false; infoProduct.IsActive = true; infoProduct.IsshowRemember = false; infoProduct.Narration = string.Empty; infoProduct.Extra1 = string.Empty; infoProduct.Extra2 = string.Empty; infoProduct.PartNo = string.Empty; infoProduct.TaxapplicableOn = cmbTaxApplication.SelectedItem.ToString(); infoProduct.ProductCode = dgvMultipleProductCreation.Rows[i].Cells["dgvtxtProductCode"].Value.ToString().Trim(); infoProduct.ProductName = dgvMultipleProductCreation.Rows[i].Cells["dgvtxtProductName"].Value.ToString().Trim(); if (dgvMultipleProductCreation.Rows[i].Cells["dgvcmbBrand"].Value != null) { infoProduct.BrandId = Convert.ToDecimal(dgvMultipleProductCreation.Rows[i].Cells["dgvcmbBrand"].Value.ToString()); } else { infoProduct.BrandId = 1; } if (dgvMultipleProductCreation.Rows[i].Cells["dgvcmbModel"].Value != null) { infoProduct.ModelNoId = Convert.ToDecimal(dgvMultipleProductCreation.Rows[i].Cells["dgvcmbModel"].Value.ToString()); } else { infoProduct.ModelNoId = 1; } if (dgvMultipleProductCreation.Rows[i].Cells["dgvcmbSize"].Value != null) { infoProduct.SizeId = Convert.ToDecimal(dgvMultipleProductCreation.Rows[i].Cells["dgvcmbSize"].Value.ToString()); } else { infoProduct.SizeId = 1; } infoProduct.PurchaseRate = Convert.ToDecimal(dgvMultipleProductCreation.Rows[i].Cells["dgvtxtPurchaseRate"].Value.ToString()); infoProduct.SalesRate = Convert.ToDecimal(dgvMultipleProductCreation.Rows[i].Cells["dgvtxtSalesRate"].Value.ToString()); infoProduct.Mrp = Convert.ToDecimal(dgvMultipleProductCreation.Rows[i].Cells["dgvtxtMRP"].Value.ToString()); decIdentity = spProduct.ProductAdd(infoProduct); //...................................................................ADD UNIT TO UNIT CONVERSION TABLE...................................................................................// infoUnitConvertion.ProductId = decIdentity; infoUnitConvertion.UnitId = Convert.ToDecimal(cmbUnit.SelectedValue.ToString()); infoUnitConvertion.ConversionRate = 1; infoUnitConvertion.ExtraDate = DateTime.Now; infoUnitConvertion.Quantities = string.Empty; infoUnitConvertion.Extra1 = string.Empty; infoUnitConvertion.Extra2 = string.Empty; spUnitConvertion.UnitConvertionAdd(infoUnitConvertion); //...................................................................ADD BATCH TO BATCH TABLE...................................................................................// Int32 inBarcode = spBatch.AutomaticBarcodeGeneration(); infoBatch.BatchNo = "NA"; infoBatch.ExpiryDate = DateTime.Now; infoBatch.ManufacturingDate = DateTime.Now; infoBatch.partNo = string.Empty; infoBatch.ProductId = decIdentity; infoBatch.narration = string.Empty; infoBatch.ExtraDate = DateTime.Now; infoBatch.barcode = Convert.ToString(inBarcode); infoBatch.Extra1 = string.Empty; infoBatch.Extra2 = string.Empty; spBatch.BatchAddWithBarCode(infoBatch); } Messages.SavedMessage(); Clear(); } catch (Exception ex) { MessageBox.Show("MPC14:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }