private void btnSave_Click(object sender, EventArgs e) { InventorySettingsModel objmodel = new InventorySettingsModel(); objmodel.qtydecimalplaces = Convert.ToInt32(tbxDecimalpla.Text.Trim()); objmodel.ItemwiseDecPlaces = Convert.ToInt32(tbxItemwiseDp.Text.Trim()); objmodel.AlternateUnitsofItems = chkUnititems.Checked == true ? true : false; objmodel.EnableMultiGodownInventory = chkEnablemultiGowon.Checked == true ? true : false; objmodel.EnableManufacturingFeatures = chkMultifeature.Checked == true ? true : false; objmodel.EnableSalesQuotation = chkEnableSalesquation.Checked == true ? true : false; objmodel.EnablePurchaseQuotation = chkEnablePurQuation.Checked == true ? true : false; objmodel.EnableOrderProcessing = chkEnableOrderProc.Checked == true ? true : false; objmodel.EnableSalePurchaseChallan = chkBudgets.Checked == true ? true : false; objmodel.CarryMaterialIssuedReceiptNextFY = chkCarrymaterialIssued.Checked == true ? true : false; objmodel.ItenSizingInformationfromItemDescp = chkPickItemSizeingInformation.Checked == true ? true : false; objmodel.StockUpdationdateinDualVouchers = chkSeparateStockUpdationDual.Checked == true ? true : false; objmodel.StockValuatioriforItems = chkSeparatestockvalation.Checked == true ? true : false; objmodel.AccountingPureInventory = chkAccountinginPureInventory.Checked == true ? true : false; objmodel.PartyWiseItemcode = chkEnablePartywiseItems.Checked == true ? true : false; objmodel.AllowSalesReturninsalesVoucher = chkAllowsalesreturnSalesvoucher.Checked == true ? true : false; objmodel.AllowPurchaseReturninPurchase = chkAllowPurchaseReturninpv.Checked == true ? true : false; objmodel.ValidateSalesReturnWithOrginal = chkValidatesaleswithos.Checked == true ? true : false; objmodel.ValidatePurcReturnWithOrginal = chkValidatePurcwithOp.Checked = true ? true : false; objmodel.BillSundryNarration = chkEnableBillsudarynarration.Checked == true ? true : false; objmodel.InvoiceBarcode = chkInvoicebarcodePrinting.Checked == true ? true : false; objmodel.ItemwiseDiscountType = cbxItemwisetype.SelectedItem.ToString(); objmodel.StockValMethod = cbxStockvalmethod.SelectedItem.ToString(); objmodel.TagSalePurcAcc = cbxSalePurcAcc.SelectedItem.ToString(); objmodel.TagStockAccWith = cbxStockvalmethod.SelectedItem.ToString(); objmodel.Scheme = chkEnableScheme.Checked == true ? true : false; objmodel.JobWork = chkEnablejobwork.Checked == true ? true : false; objmodel.ParameterizedDetails = chkParmeterrized.Checked == true ? true : false; objmodel.BatchWiseDetails = chkBatchwise.Checked == true ? true : false; objmodel.SerialnowiseDetails = chkSerialnoWise.Checked == true ? true : false; objmodel.MRPwiseDetails = chkMrpWise.Checked == true ? true : false; objmodel.ItemDefaultPrisceDuringvchModifi = chkItemdefaultPrise.Checked == true ? true : false; objmodel.FreeQuantityinVouchers = chkEnablefreeQuantity.Checked == true ? true : false; objmodel.LastTransactionSales = chkTransationduringsales.Checked == true ? true : false; objmodel.LastTransactionPurchase = chkTransDuringPurchase.Checked == true ? true : false; objmodel.AdditionalExpensesVchwise = chkAllowExpensesVoucherwise.Checked = true ? true : false; objmodel.ExpensePurctoItems = chkAllowExpensetoItems.Checked = true ? true : false; objmodel.ImagesNoteswithMaster = chkMaintainimage.Checked = true ? true : false; objmodel.ItemsCurrentBalVchEntry = chkShowItemscurrentBalance.Checked = true ? true : false; objmodel.DrugLicence = chkMaintaindurgLice.Checked = true ? true : false; objmodel.DatewiseItemPricing = chkEnableDatewiseItemPricing.Checked = true ? true : false; objmodel.CalItemSalePricePurchasePrice = chkCalculateItemsale.Checked = true ? true : false; objmodel.UpdatePricesItemMaster = chkUpdatePrices.Checked = true ? true : false; objmodel.PackingDetailsinVouchers = chkEnablepackingDetails.Checked = true ? true : false; objmodel.DonotMaintainStockBala = cbxDontMaintainStockBalance.SelectedItem.ToString(); objmodel.ItemwiseMarkupType = cbxItemwisemarkup.SelectedItem.ToString(); bool isscusses = objInvBl.SaveInventorySetting(objmodel); if (isscusses) { MessageBox.Show("Saved Scussfully"); } }
public async Task <OperationDataResult <InventorySettingsModel> > GetSettings() { var sdkCore = await _coreService.GetCore(); await using var sdkDbContext = sdkCore.DbContextHelper.GetDbContext(); try { var option = _options.Value; var siteIds = _dbContext.AssignedSites .AsNoTracking() .Where(x => x.WorkflowState != Constants.WorkflowStates.Removed) .Select(site => site.SiteUid) .ToList(); var assignetSites = sdkDbContext.Sites .AsNoTracking() .Where(x => x.WorkflowState != Constants.WorkflowStates.Removed) .Where(x => siteIds.Contains((int)x.MicrotingUid)) .Select(x => new SiteNameDto((int)x.MicrotingUid, x.Name, x.CreatedAt, x.UpdatedAt)) .ToList(); var settings = new InventorySettingsModel { AssignedSites = assignetSites, FolderId = option.FolderId, }; return(new OperationDataResult <InventorySettingsModel>(true, settings)); } catch (Exception e) { Trace.TraceError(e.Message); _logger.LogError(e.Message); return(new OperationDataResult <InventorySettingsModel>(false, _inventoryLocalizationService.GetString("ErrorWhileObtainingInventorySettings"))); } }
/// <summary> /// </summary> /// <param name="objAccountGrp"></param> /// <returns>True/False</returns> public bool SaveInventorySetting(InventorySettingsModel objInventory) { string Query = string.Empty; DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@DecemalPlaces", objInventory.qtydecimalplaces)); paramCollection.Add(new DBParameter("@IwDecPlaces", objInventory.ItemwiseDecPlaces)); paramCollection.Add(new DBParameter("@altunits", objInventory.AlternateUnitsofItems, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@multigodown", objInventory.EnableMultiGodownInventory, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@manufacturing", objInventory.EnableManufacturingFeatures, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@salequotation", objInventory.EnableSalesQuotation, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@Purchasequotation", objInventory.EnablePurchaseQuotation, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@orderprocessing", objInventory.EnableOrderProcessing, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@salesbypurchasechall", objInventory.EnableSalePurchaseChallan, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@carrypendingmat", objInventory.CarryMaterialIssuedReceiptNextFY, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@pickitemWSizing", objInventory.ItenSizingInformationfromItemDescp, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@separatestockUpdation", objInventory.StockUpdationdateinDualVouchers, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@separatestockvalidation", objInventory.StockValuatioriforItems, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@Accountinginpure", objInventory.AccountingPureInventory, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@enablepartwise", objInventory.PartyWiseItemcode, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@allowsalesreturn", objInventory.AllowSalesReturninsalesVoucher, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@allowpurchasereturn", objInventory.AllowPurchaseReturninPurchase, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@validatesalesreturn", objInventory.ValidateSalesReturnWithOrginal, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@validatepurchasereturn", objInventory.ValidatePurcReturnWithOrginal, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@enablebillsundary", objInventory.BillSundryNarration, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@invoicebarcode", objInventory.InvoiceBarcode, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@itemwisediscount", objInventory.ItemwiseDiscountType)); paramCollection.Add(new DBParameter("@stockvalmethod", objInventory.StockValMethod)); paramCollection.Add(new DBParameter("@tagsalacc", objInventory.TagSalePurcAcc)); paramCollection.Add(new DBParameter("@tagstockacc", objInventory.TagStockAccWith)); paramCollection.Add(new DBParameter("@enablescheme", objInventory.Scheme, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@enablejobwork", objInventory.JobWork, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@parameterizeddetail", objInventory.ParameterizedDetails, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@batchwisedetails", objInventory.BatchWiseDetails, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@serialnowise", objInventory.SerialnowiseDetails, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@mrpwise", objInventory.MRPwiseDetails, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@skipitems", objInventory.ItemDefaultPrisceDuringvchModifi, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@enablefreequantity", objInventory.FreeQuantityinVouchers, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@SLTSales", objInventory.LastTransactionSales, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@SLTPurchase", objInventory.LastTransactionSales, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@AAEvoucher", objInventory.AdditionalExpensesVchwise, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@AEPurchase", objInventory.ExpensePurctoItems, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@Matainimages", objInventory.ImagesNoteswithMaster, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@Showitemcurrentblancevoucher", objInventory.ItemsCurrentBalVchEntry, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@DurgLicence", objInventory.DrugLicence, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@calItemsaleprcfrompurcprc", objInventory.CalItemSalePricePurchasePrice, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@updatepriceinit", objInventory.UpdatePricesItemMaster, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@enablepackingdetails", objInventory.PackingDetailsinVouchers, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@donotmaintainstockbal", objInventory.DonotMaintainStockBala)); paramCollection.Add(new DBParameter("@itemwisemarkuptype", objInventory.ItemwiseMarkupType)); paramCollection.Add(new DBParameter("@datewiseItemprising", objInventory.DatewiseItemPricing, System.Data.DbType.Boolean)); //paramCollection.Add(new DBParameter("@companyact", objInventory.CreatedBy)); Query = "INSERT INTO inventorysettings (`qtydecimalplaces`,`ItemwiseDecPlaces`,`AlternateUnitsofItems`,`MultiGodownInventory`,`ManufacturingFeatures`,`SalesQuotation`," + "`PurchaseQuotation`,`OrderProcessing`,`SalePurchaseChallan`,`MaterialIssuedReceiptNextFY`,`ItenSizingInformationfromItemDescp`," + "`StockUpdationdateinDualVouchers`,`StockValuatioriforItems`,`AccountingPureInventory`,`PartyWiseItemcode`,`SalesReturninsalesVoucher`,`PurchaseReturninPurchase`," + "`ValidateSalesReturnWithOrginal`,`ValidatePurcReturnWithOrginal`,`BillSundryNarration`,`InvoiceBarcode`,`ItemwiseDiscountType`,`StockValMethod`,`TagSalePurcAcc`," + "`TagStockAccWith`,`Scheme`,`JobWork`,`ParameterizedDetails`,`BatchWiseDetails`,`Serialno.wiseDetails`,`MRPwiseDetails`,`ItemDefaultPrisceDuringvchModifi`," + "`FreeQuantityinVouchers`,`LastTransactionSales`,`LastTransactionPurchase`,`AdditionalExpensesVchwise`,`ExpensePurctoItems`,`ImagesNoteswithMaster`,`ItemsCurrentBalVchEntry`,`DrugLicence`,`CalItemSalePricePurchasePrice`,`UpdatePricesItemMaster`,`PackingDetailsinVouchers`,`DonotMaintainStockBala`,`ItemwiseMarkupType`,`DatewiseItemPricing`)" + "VALUES (@DecemalPlaces,@IwDecPlaces,@altunits,@multigodown,@manufacturing,@salequotation,@Purchasequotation,@orderprocessing,@salesbypurchasechall," + "@carrypendingmat,@pickitemWSizing,@separatestockUpdation,@separatestockvalidation,@Accountinginpure,@enablepartwise,@allowsalesreturn,@allowpurchasereturn," + "@validatesalesreturn,@validatepurchasereturn,@enablebillsundary,@invoicebarcode,@itemwisediscount,@stockvalmethod,@tagsalacc,@tagstockacc,@enablescheme,@enablejobwork,@parameterizeddetail,@batchwisedetails,@serialnowise,@mrpwise," + "@skipitems,@enablefreequantity,@SLTSales,@SLTPurchase,@AAEvoucher,@AEPurchase,@Matainimages,@Showitemcurrentblancevoucher,@DurgLicence,@calItemsaleprcfrompurcprc,@updatepriceinit,@enablepackingdetails,@donotmaintainstockbal,@itemwisemarkuptype,@datewiseItemprising)"; //"@decimalplac,@maitainsubled,@postingaccounts,@doubleentery,@showaccountbal,@maintainimages,@balancesheet,@ledgerrecon,@chekprinting,@interestrate,@enableparty,@showparydashbord)"; return(_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0); }
public void Handler() { InboundRequest inboundRequest = null; ToaRequestResult inboundResult = null; int? aid = null; WorkOrderModel workOrderModel = null; try { _log.Notice("Starting WorkOrderSave Handler."); object wotype = EventHandlerServices.GetEventHandlerService().getFieldFromWorOrderRecord(_workOrderRecord, "WO_Type"); object overrideRequest = EventHandlerServices.GetEventHandlerService().getFieldFromWorOrderRecord(_workOrderRecord, "Override_Request"); object timeSlot = EventHandlerServices.GetEventHandlerService().getFieldFromWorOrderRecord(_workOrderRecord, "WO_Time_Slot"); object wodate = EventHandlerServices.GetEventHandlerService().getFieldFromWorOrderRecord(_workOrderRecord, "WO_Date"); object resolutionDue = EventHandlerServices.GetEventHandlerService().getFieldFromWorOrderRecord(_workOrderRecord, "Resolution_Due"); if (null == wotype) { return; } if (overrideRequest != null) { if (timeSlot == null || wodate == null) { return; } } else { if (timeSlot == null || wodate == null) { if (resolutionDue == null) { return; } } } _log.Notice("Converting from RecordContext to WorkOrder Model started"); workOrderModel = EventHandlerServices.GetEventHandlerService().GetWorkOrderModel(_recordContext); _log.Notice("Convertion from RecordContext to WorkOrder Model completed"); //Appointments 'key' fields are set in the constuctor of below object var activitySettings = new ActivitySettingsModel(); //Inventory 'key' fields are set in the constuctor of below object var inventorySettings = new InventorySettingsModel(); _log.Notice("Initialize InboundRequest"); inboundRequest = new InboundRequest(new List <IToaModel>() { workOrderModel }); inboundRequest.PropertiesMode = Client.Common.PropertiesMode.Replace; inboundRequest.AllowChangeDate = Client.Common.AllowChangeDate.Yes; inboundRequest.ActivitySettings = activitySettings; inboundRequest.InventorySettings = inventorySettings; _log.Notice("Invoking TOA Server using Inbound API Started"); inboundResult = InboundService.GetService().BeginSyncRequest(inboundRequest); if (inboundResult != null) { _log.Notice("Invoking TOA Server using Inbound API Completed"); ToaExceptionManager manager = new ToaExceptionManager(); _log.Notice("Processing Inbound API Response Result"); aid = manager.ProcessInboundResult(inboundResult); _log.Notice("Completed Processing Inbound API Response Result"); if (aid == null) { _cancelEventArgs.Cancel = true; return; } } else { foreach (IGenericField field in _workOrderRecord.GenericFields) { if (field.Name.Equals("WO_Status")) { TextInfo textInfo = new CultureInfo("en-US", false).TextInfo; field.DataValue.Value = textInfo.ToTitleCase(ToaStringsUtil.GetString(Client.Common.ActivityStatus.NotCreated)); break; } } } } catch (Exception ex) { _log.Error(ex.Message, ex.StackTrace); MessageBox.Show(ToaExceptionMessages.UnexpectedError, ToaExceptionMessages.TitleError, MessageBoxButton.OK, MessageBoxImage.Error); } try { _log.Notice("Updating WorkOrder Record."); workOrderModel.TOA_AID = (aid != null) ? aid : 0; UpdateWorkOrderRecord(inboundResult, workOrderModel); _log.Notice("WorkOrder Record Updated."); _log.Notice("Exiting WorkOrderSave Handler."); } catch (Exception ex) { _log.Error(ex.Message, ex.StackTrace); MessageBox.Show(ToaExceptionMessages.UnexpectedError, ToaExceptionMessages.TitleError, MessageBoxButton.OK, MessageBoxImage.Error); } }