/// <summary> /// Save or edit function /// </summary> public void SaveOrEdit() { SettingsSP spSetting = new SettingsSP(); try { decimal decIdentity = 0; DeliveryNoteMasterSP SpDeliveryNoteMaster = new DeliveryNoteMasterSP(); DeliveryNoteMasterInfo InfoDeliveryNoteMaster = new DeliveryNoteMasterInfo(); InfoDeliveryNoteMaster = SpDeliveryNoteMaster.DeliveryNoteMasterView(Convert.ToDecimal(cmbDeliveryNoteNo.SelectedValue)); RejectionInMasterInfo InfoRejectionInMaster = new RejectionInMasterInfo(); RejectionInDetailsInfo InfoRejectionInDetails = new RejectionInDetailsInfo(); RejectionInDetailsSP SpRejectionInDetails = new RejectionInDetailsSP(); StockPostingInfo InfoStockPosting = new StockPostingInfo(); StockPostingSP SpStockPosting = new StockPostingSP(); if (isAutomatic) { InfoRejectionInMaster.VoucherNo = strVoucherNo; InfoRejectionInMaster.InvoiceNo = txtRejectionInNo.Text; } else { InfoRejectionInMaster.VoucherNo = txtRejectionInNo.Text; InfoRejectionInMaster.InvoiceNo = txtRejectionInNo.Text; } InfoRejectionInMaster.VoucherTypeId = decRejectionInVoucherTypeId; InfoRejectionInMaster.SuffixPrefixId = decRejectionInSuffixPrefixId; InfoRejectionInMaster.Date = DateTime.Parse(txtDate.Text); InfoRejectionInMaster.LedgerId = Convert.ToDecimal(cmbCashorParty.SelectedValue.ToString()); InfoRejectionInMaster.PricinglevelId = cmbPricingLevel.SelectedValue == null ? 0 : Convert.ToDecimal(cmbPricingLevel.SelectedValue.ToString()); InfoRejectionInMaster.EmployeeId = cmbSalesMan.SelectedValue == null ? 1 : Convert.ToDecimal(cmbSalesMan.SelectedValue.ToString()); InfoRejectionInMaster.Narration = txtNarration.Text.Trim(); InfoRejectionInMaster.ExchangeRateId = cmbCurrency.SelectedValue == null ? 0 : Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()); InfoRejectionInMaster.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text); InfoRejectionInMaster.UserId = PublicVariables._decCurrentUserId; InfoRejectionInMaster.LrNo = txtLRNo.Text.Trim(); InfoRejectionInMaster.TransportationCompany = txtTransportationCompany.Text.Trim(); InfoRejectionInMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId; InfoRejectionInMaster.Extra1 = string.Empty; InfoRejectionInMaster.Extra2 = string.Empty; InfoRejectionInMaster.DeliveryNoteMasterId = Convert.ToDecimal(cmbDeliveryNoteNo.SelectedValue == null ? "" : cmbDeliveryNoteNo.SelectedValue.ToString()); if (decRejectionInIdToEdit == 0) { decIdentity = spRejectionInMaster.RejectionInMasterAdd(InfoRejectionInMaster); } else { InfoRejectionInMaster.RejectionInMasterId = decRejectionInIdToEdit; spRejectionInMaster.RejectionInMasterEdit(InfoRejectionInMaster); } if (decRejectionInIdToEdit == 0) { InfoRejectionInDetails.RejectionInMasterId = decIdentity; } else { SpRejectionInDetails.DeleteRejectionInDetailsByRejectionInMasterId(decRejectionInIdToEdit); SpStockPosting.DeleteStockPostingByAgnstVouTypeIdAndAgnstVouNo(decRejectionInVoucherTypeId, strVoucherNo); InfoRejectionInDetails.RejectionInMasterId = decRejectionInIdToEdit; } foreach (DataGridViewRow dgvrow in dgvProduct.Rows) { InfoRejectionInDetails.DeliveryNoteDetailsId = Convert.ToDecimal(dgvrow.Cells["dgvtxDeliveryNoteDetailsId"].Value.ToString()); InfoRejectionInDetails.ProductId = Convert.ToDecimal(dgvrow.Cells["dgvtxtProductId"].Value.ToString()); InfoRejectionInDetails.Qty = Convert.ToDecimal(dgvrow.Cells["dgvtxtQuantity"].Value.ToString()); InfoRejectionInDetails.Rate = Convert.ToDecimal(dgvrow.Cells["dgvtxtRate"].Value.ToString()); InfoRejectionInDetails.UnitId = Convert.ToDecimal(dgvrow.Cells["dgvcmbUnit"].Value.ToString()); InfoRejectionInDetails.UnitConversionId = Convert.ToDecimal(dgvrow.Cells["dgvtxtUnitConversionId"].Value.ToString());//0;//check InfoRejectionInDetails.BatchId = Convert.ToDecimal(dgvrow.Cells["dgvcmbBatch"].Value.ToString()); InfoRejectionInDetails.GodownId = Convert.ToDecimal(dgvrow.Cells["dgvcmbGodown"].Value.ToString()); InfoRejectionInDetails.RackId = Convert.ToDecimal(dgvrow.Cells["dgvcmbRack"].Value.ToString()); InfoRejectionInDetails.Amount = Convert.ToDecimal(dgvrow.Cells["dgvtxtAmount"].Value.ToString()); InfoRejectionInDetails.SlNo = Convert.ToInt32(dgvrow.Cells["dgvtxtSlNo"].Value.ToString()); InfoRejectionInDetails.Extra1 = string.Empty; InfoRejectionInDetails.Extra2 = string.Empty; SpRejectionInDetails.RejectionInDetailsAdd(InfoRejectionInDetails); InfoStockPosting.Date = Convert.ToDateTime(txtDate.Text); InfoStockPosting.VoucherTypeId = InfoDeliveryNoteMaster.VoucherTypeId; InfoStockPosting.VoucherNo = InfoDeliveryNoteMaster.VoucherNo; InfoStockPosting.InvoiceNo = InfoDeliveryNoteMaster.InvoiceNo; InfoStockPosting.ProductId = Convert.ToDecimal(dgvrow.Cells["dgvtxtProductId"].Value.ToString()); InfoStockPosting.BatchId = Convert.ToDecimal(dgvrow.Cells["dgvcmbBatch"].Value.ToString()); InfoStockPosting.UnitId = Convert.ToDecimal(dgvrow.Cells["dgvcmbUnit"].Value.ToString()); InfoStockPosting.GodownId = Convert.ToDecimal(dgvrow.Cells["dgvcmbGodown"].Value.ToString()); InfoStockPosting.RackId = Convert.ToDecimal(dgvrow.Cells["dgvcmbRack"].Value.ToString()); InfoStockPosting.AgainstVoucherTypeId = decRejectionInVoucherTypeId; if (isAutomatic) { InfoStockPosting.AgainstInvoiceNo = txtRejectionInNo.Text; InfoStockPosting.AgainstVoucherNo = strVoucherNo; } else { InfoStockPosting.AgainstInvoiceNo = txtRejectionInNo.Text; InfoStockPosting.AgainstVoucherNo = txtRejectionInNo.Text; } InfoStockPosting.InwardQty = Convert.ToDecimal(dgvrow.Cells["dgvtxtQuantity"].Value.ToString()); InfoStockPosting.OutwardQty = 0; InfoStockPosting.Rate = Convert.ToDecimal(dgvrow.Cells["dgvtxtRate"].Value.ToString()); InfoStockPosting.FinancialYearId = PublicVariables._decCurrentFinancialYearId; InfoStockPosting.Extra1 = string.Empty; InfoStockPosting.Extra2 = string.Empty; SpStockPosting.StockPostingAdd(InfoStockPosting); } if (decRejectionInIdToEdit == 0) { Messages.SavedMessage(); if (cbxPrintAfterSave.Checked) { if (spSetting.SettingsStatusCheck("Printer") == "Dot Matrix") { PrintForDotMatrix(decIdentity); } else { Print(decIdentity); } } } else { Messages.UpdatedMessage(); if (cbxPrintAfterSave.Checked) { if (spSetting.SettingsStatusCheck("Printer") == "Dot Matrix") { PrintForDotMatrix(decRejectionInIdToEdit); } else { Print(decRejectionInIdToEdit); } } this.Close(); } } catch (Exception ex) { MessageBox.Show("RI:23" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// function to Rejection In updation /// </summary> public void RejectionInview() { decimal decRejectioInMasterId = 0; try { btnSave.Text = "Update"; btnDelete.Enabled = true; isFromRejectionInRegister = true; RejectionInMasterSP SpRejectionInMaster = new RejectionInMasterSP(); RejectionInMasterInfo InfoRejectionInMaster = new RejectionInMasterInfo(); InfoRejectionInMaster = SpRejectionInMaster.RejectionInMasterView(decRejectionInIdToEdit); DeliveryNoteMasterSP SpDeliveryNoteMaster = new DeliveryNoteMasterSP(); DeliveryNoteMasterInfo InfoDeliveryNoteMaster = new DeliveryNoteMasterInfo(); InfoDeliveryNoteMaster = SpDeliveryNoteMaster.DeliveryNoteMasterView(InfoRejectionInMaster.DeliveryNoteMasterId); strRejectionInVoucherNo = SpRejectionInMaster.GetRejectionInVoucherNo(InfoRejectionInMaster.RejectionInMasterId); decRejectionInVoucherTypeId = InfoRejectionInMaster.VoucherTypeId; decRejectionInSuffixPrefixId = InfoRejectionInMaster.SuffixPrefixId; strVoucherNo = InfoRejectionInMaster.VoucherNo; VoucherTypeSP spVoucherType = new VoucherTypeSP(); isAutomatic = spVoucherType.CheckMethodOfVoucherNumbering(decRejectionInVoucherTypeId); if (!isAutomatic) { txtRejectionInNo.ReadOnly = false; txtRejectionInNo.Focus(); } else { txtRejectionInNo.ReadOnly = true; txtDate.Focus(); } txtRejectionInNo.Text = InfoRejectionInMaster.InvoiceNo; txtDate.Text = InfoRejectionInMaster.Date.ToString("dd-MMM-yyyy"); dtpDate.Value = Convert.ToDateTime(txtDate.Text); cmbCashorParty.SelectedValue = InfoRejectionInMaster.LedgerId; cmbVoucherType.SelectedValue = InfoDeliveryNoteMaster.VoucherTypeId; cmbPricingLevel.SelectedValue = InfoRejectionInMaster.PricinglevelId; cmbDeliveryNoteNo.SelectedValue = InfoRejectionInMaster.DeliveryNoteMasterId; cmbSalesMan.SelectedValue = InfoRejectionInMaster.EmployeeId; cmbCurrency.SelectedValue = InfoRejectionInMaster.ExchangeRateId; txtTransportationCompany.Text = InfoRejectionInMaster.TransportationCompany; txtNarration.Text = InfoRejectionInMaster.Narration; txtLRNo.Text = InfoRejectionInMaster.LrNo; txtTotalAmount.Text = Convert.ToString(InfoRejectionInMaster.TotalAmount); RejectionInDetailsSP SpRejectionInDetails = new RejectionInDetailsSP(); DataTable dtblRejectionInDetails = SpRejectionInDetails.RejectionInDetailsViewByRejectionInMasterId(decRejectionInIdToEdit); decRejectioInMasterId = Convert.ToDecimal(dtblRejectionInDetails.Rows[0]["voucherTypeId"].ToString()); VoucherTypeInfo infoVoucherType = new VoucherTypeInfo(); infoVoucherType = spVoucherType.VoucherTypeView(decRejectioInMasterId); this.Text = infoVoucherType.VoucherTypeName; foreach (DataRow drRejectionInDetails in dtblRejectionInDetails.Rows) { isDoCellValueChange = false; DGVGodownComboFill(); dgvProduct.Rows.Add(); dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvtxtProductId"].Value = drRejectionInDetails["productId"].ToString(); dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvtxDeliveryNoteDetailsId"].Value = drRejectionInDetails.ItemArray[2].ToString(); AssignProductDefaultValues(dgvProduct.Rows.Count - 1, Convert.ToDecimal(drRejectionInDetails.ItemArray[3].ToString())); DGVBatchComboFill(dgvProduct.Rows.Count - 1, Convert.ToDecimal(drRejectionInDetails.ItemArray[3].ToString())); dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvtxtQuantity"].Value = drRejectionInDetails["qty"].ToString(); isDoCellValueChange = true; dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvcmbUnit"].Value = Convert.ToDecimal(drRejectionInDetails["unitId"].ToString()); dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvtxtUnitConversionId"].Value = Convert.ToDecimal(drRejectionInDetails["unitconversionId"].ToString()); dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvcmbGodown"].Value = Convert.ToDecimal(drRejectionInDetails["godownId"].ToString()); dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvcmbRack"].Value = Convert.ToDecimal(drRejectionInDetails["rackId"].ToString()); dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvcmbBatch"].Value = Convert.ToDecimal(drRejectionInDetails["batchId"].ToString()); dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvtxtRate"].Value = drRejectionInDetails["rate"].ToString(); dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvtxtAmount"].Value = drRejectionInDetails["amount"].ToString(); dgvProduct.CurrentCell = null; } SerialNo(); CalcTotalAmt(); isDoCellValueChange = true; isDoAfterGridFill = true; isFromRejectionInRegister = false; } catch (Exception ex) { MessageBox.Show("RI:35" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }