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);
}
}
