public void DeleteSubMenuOfMenu(int menuID, string addedBy) { List <ENTRY_SETTINGS> entrySetting = _entrySettingsRepo.Filter(s => s.MenuID == menuID && s.AddedBy == addedBy && s.MenuID != null && s.AddedBy != null).ToList(); if (entrySetting.Count > 0) { foreach (var set in entrySetting) { ENTRY_GRID_COLUMNS egc = _entryGrdColRepo.Filter(X => X.ENTRY_SETTING_ID == set.ENTRY_SETTING_ID).FirstOrDefault(); if (egc != null) { ENTRY_GRID_COLUMNS egc_ = new ENTRY_GRID_COLUMNS { ENTRY_SETTING_ID = egc.ENTRY_SETTING_ID, ACC_COLOR = egc.ACC_COLOR, ACC_INDEX = egc.ACC_INDEX, ACC_WIDTH = egc.ACC_WIDTH, COST_CENTER_COLOR = egc.COST_CENTER_COLOR, COST_CENTER_INDEX = egc.COST_CENTER_INDEX, COST_CENTER_WIDTH = egc.COST_CENTER_WIDTH, CREDIT_COLOR = egc.CREDIT_COLOR, CREDIT_INDEX = egc.CREDIT_INDEX, CREDIT_WIDTH = egc.CREDIT_WIDTH, DEBIT_COLOR = egc.DEBIT_COLOR, DEBIT_INDEX = egc.DEBIT_INDEX, DEBIT_WIDTH = egc.DEBIT_WIDTH, REMARKS_COLOR = egc.REMARKS_COLOR, REMARKS_INDEX = egc.REMARKS_INDEX, REMARKS_WIDTH = egc.REMARKS_WIDTH, AddedBy = egc.AddedBy, AddedOn = egc.AddedOn, UpdatedBy = egc.UpdatedBy, updatedOn = egc.updatedOn, ACC_COLOR_HEXA = egc.ACC_COLOR_HEXA, COST_CENTER_COLOR_HEXA = egc.COST_CENTER_COLOR_HEXA, CREDIT_COLOR_HEXA = egc.CREDIT_COLOR_HEXA, DEBIT_COLOR_HEXA = egc.DEBIT_COLOR_HEXA, REMARKS_COLOR_HEXA = egc.REMARKS_COLOR_HEXA, // TaxAccountID = entity.TaxAccountID }; _entryGrdColRepo.Delete(egc_, egc.ENTRY_SETTING_ID); ENTRY_SETTINGS et = new ENTRY_SETTINGS { ENTRY_SETTING_ID = set.ENTRY_SETTING_ID, ACCEPT_DIST_ACC = set.ACCEPT_DIST_ACC, AUTO_POSTING = set.AUTO_POSTING, COSTCENTER_BELONG = set.COSTCENTER_BELONG, CURRENCY_ID = set.CURRENCY_ID, ENTRY_ACC_ID = set.ENTRY_ACC_ID, ENTRY_SETTING_AR_ABRV = set.ENTRY_SETTING_AR_ABRV, ENTRY_SETTING_AR_NAME = set.ENTRY_SETTING_AR_NAME, ENTRY_SETTING_EN_ABRV = set.ENTRY_SETTING_EN_ABRV, ENTRY_SETTING_EN_NAME = set.ENTRY_SETTING_EN_NAME, ENTRY_TYPE_ID = set.ENTRY_TYPE_ID, AddedBy = set.AddedBy, AddedOn = set.AddedOn, UpdatedBy = set.UpdatedBy, updatedOn = set.updatedOn, TaxAccountID = set.TaxAccountID, MenuID = set.MenuID }; _entrySettingsRepo.Delete(et, set.ENTRY_SETTING_ID); } } } List <BILL_SETTINGS> billSetting = _billSettingsRepo.Filter(b => b.MenuID == menuID && b.AddedBy == addedBy).ToList(); if (billSetting.Count > 0) { foreach (var bill in billSetting) { BILL_GRID_COLUMNS billgrdCol = _billGrdColRepo.Filter(x => x.BILL_SETTING_ID == bill.BILL_SETTING_ID).FirstOrDefault(); if (billgrdCol != null) { BILL_GRID_COLUMNS bgc = new BILL_GRID_COLUMNS { AddedBy = billgrdCol.AddedBy, AddedOn = billgrdCol.AddedOn, BILL_GRID_ID = billgrdCol.BILL_GRID_ID, BILL_REMARKS_INDEX = billgrdCol.BILL_REMARKS_INDEX, BILL_REMARKS_WIDTH = billgrdCol.BILL_REMARKS_WIDTH, BILL_SETTING_ID = billgrdCol.BILL_SETTING_ID, CEXTERNALLEXPENSES_INDEX = billgrdCol.CEXTERNALLEXPENSES_INDEX, CEXTERNALLEXPENSES_WIDTH = billgrdCol.CEXTERNALLEXPENSES_WIDTH, CINVENTORYVALUE_INDEX = billgrdCol.CINVENTORYVALUE_INDEX, CINVENTORYVALUE_WIDTH = billgrdCol.CINVENTORYVALUE_WIDTH, CTOTALCURR_INDEX = billgrdCol.CTOTALCURR_INDEX, CTOTALCURR_WIDTH = billgrdCol.CTOTALCURR_WIDTH, CTOTALWITHEXPENSES_INDEX = billgrdCol.CTOTALWITHEXPENSES_INDEX, CTOTALWITHEXPENSES_WIDTH = billgrdCol.CTOTALWITHEXPENSES_WIDTH, DISC_RATE_INDEX = billgrdCol.DISC_RATE_INDEX, DISC_RATE_WIDTH = billgrdCol.DISC_RATE_WIDTH, DISC_VALUE_INDEX = billgrdCol.DISC_VALUE_INDEX, DISC_VALUE_WIDTH = billgrdCol.DISC_VALUE_WIDTH, EMPLOYEE_INDEX = billgrdCol.EMPLOYEE_INDEX, EMPLOYEE_WIDTH = billgrdCol.EMPLOYEE_WIDTH, END_USERS_INDEX = billgrdCol.END_USERS_INDEX, END_USERS_WIDTH = billgrdCol.END_USERS_WIDTH, EXPIRED_DATE_INDEX = billgrdCol.EXPIRED_DATE_INDEX, EXPIRED_DATE_WIDTH = billgrdCol.EXPIRED_DATE_WIDTH, EXPORT_INDEX = billgrdCol.EXPORT_INDEX, EXPORT_WIDTH = billgrdCol.EXPORT_WIDTH, EXTRA_RATE_INDEX = billgrdCol.EXTRA_RATE_INDEX, EXTRA_RATE_WIDTH = billgrdCol.EXTRA_RATE_WIDTH, EXTRA_VALUE_INDEX = billgrdCol.EXTRA_VALUE_INDEX, EXTRA_VALUE_WIDTH = billgrdCol.EXTRA_VALUE_WIDTH, GIFTS_INDEX = billgrdCol.GIFTS_INDEX, GIFTS_WIDTH = billgrdCol.GIFTS_WIDTH, HALF_WHOLE_INDEX = billgrdCol.HALF_WHOLE_INDEX, HALF_WHOLE_WIDTH = billgrdCol.HALF_WHOLE_WIDTH, ITEM_INDEX = billgrdCol.ITEM_INDEX, ITEM_REMAIN_QTY_INDEX = billgrdCol.ITEM_REMAIN_QTY_INDEX, ITEM_WIDTH = billgrdCol.ITEM_WIDTH, ITEM_REMAIN_QTY_WIDTH = billgrdCol.ITEM_REMAIN_QTY_WIDTH, LAST_BUY_INDEX = billgrdCol.LAST_BUY_INDEX, LAST_BUY_WIDTH = billgrdCol.LAST_BUY_WIDTH, PRODUCTION_DATE_INDEX = billgrdCol.PRODUCTION_DATE_INDEX, PRODUCTION_DATE_WIDTH = billgrdCol.PRODUCTION_DATE_WIDTH, QTY_INDEX = billgrdCol.QTY_INDEX, QTY_WIDTH = billgrdCol.QTY_WIDTH, RETAIL_INDEX = billgrdCol.RETAIL_INDEX, RETAIL_WIDTH = billgrdCol.RETAIL_WIDTH, TOTAL_INDEX = billgrdCol.TOTAL_INDEX, TOTAL_WIDTH = billgrdCol.TOTAL_WIDTH, UNIT_COST_INDEX = billgrdCol.UNIT_COST_INDEX, UNIT_COST_WIDTH = billgrdCol.UNIT_COST_WIDTH, UNIT_INDEX = billgrdCol.UNIT_INDEX, UNIT_WIDTH = billgrdCol.UNIT_WIDTH, UpdatedBy = billgrdCol.UpdatedBy, updatedOn = billgrdCol.updatedOn, WHOLE_INDEX = billgrdCol.WHOLE_INDEX, WHOLE_WIDTH = billgrdCol.WHOLE_WIDTH, }; _billGrdColRepo.Delete(bgc, billgrdCol.BILL_GRID_ID); } BILL_SETTINGS bs = new BILL_SETTINGS { ABRV_BILL = bill.ABRV_BILL, ACC_COST_ID = bill.ACC_COST_ID, ACC_DISC_ID = bill.ACC_DISC_ID, ACC_EXTRA_ID = bill.ACC_EXTRA_ID, ACC_GIFT_ID = bill.ACC_GIFT_ID, ACC_ITEM_ID = bill.ACC_ITEM_ID, ACC_PAY_ID = bill.ACC_PAY_ID, ACC_STORE_ID = bill.ACC_STORE_ID, AddedBy = bill.AddedBy, AddedOn = bill.AddedOn, ADD_BILL_ENTRY_WITH_THE_MAIN_CURRENCY_RATE = bill.ADD_BILL_ENTRY_WITH_THE_MAIN_CURRENCY_RATE, ALTERNATE_COLOR = bill.ALTERNATE_COLOR, AUTOMATIC_DISCOUNT = bill.AUTOMATIC_DISCOUNT, BILL_ABRV_AR = bill.BILL_ABRV_AR, BILL_ABRV_EN = bill.BILL_ABRV_EN, BILL_AR_NAME = bill.BILL_AR_NAME, BILL_EN_NAME = bill.BILL_EN_NAME, BILL_PAY_TYPE = bill.BILL_PAY_TYPE, BILL_SELL_TYPE_ID = bill.BILL_SELL_TYPE_ID, BILL_SETTING_ID = bill.BILL_SETTING_ID, BILL_SHORTCUT = bill.BILL_SHORTCUT, BILL_SHOW_NAME = bill.BILL_SHOW_NAME, BILL_TYPE_ID = bill.BILL_TYPE_ID, COM_STORE_ID = bill.COM_STORE_ID, CONTINEOUS_INVENTORY = bill.CONTINEOUS_INVENTORY, COST_CENTER_ID = bill.COST_CENTER_ID, CURRENCY_ID = bill.CURRENCY_ID, CURRENCY_RATE = bill.CURRENCY_RATE, DEFAULT_COLOR = bill.DEFAULT_COLOR, Disable = bill.Disable, DISABLE_BILL_PAY_TYPE = bill.DISABLE_BILL_PAY_TYPE, FIRSTBILLMESSAGE = bill.FIRSTBILLMESSAGE, FIRST_EXPIRE = bill.FIRST_EXPIRE, GENERATE_COST_ENTRY = bill.GENERATE_COST_ENTRY, GENERATE_ENTRY_STATE = bill.GENERATE_ENTRY_STATE, GST = bill.GST, GSTNAME = bill.GSTNAME, HEADERBILLMESSAGE = bill.HEADERBILLMESSAGE, IS_AUTO_POSTING = bill.IS_AUTO_POSTING, IS_IT_CASHER_BILL = bill.IS_IT_CASHER_BILL, IS_IT_SALES_POINT = bill.IS_IT_SALES_POINT, IS_IT_SERVICE_BILL = bill.IS_IT_SERVICE_BILL, IS_IT_TAX_SALE_BILL = bill.IS_IT_TAX_SALE_BILL, IS_IT_THREADING = bill.IS_IT_THREADING, LAST_PAY_PRICE = bill.LAST_PAY_PRICE, MIN_QTY = bill.MIN_QTY, MODULE_CARS = bill.MODULE_CARS, NUMBEROFCOPIES = bill.NUMBEROFCOPIES, OUT_MINUS = bill.OUT_MINUS, PRICE_COST_EFFECT = bill.PRICE_COST_EFFECT, PRINTHALFPAGE = bill.PRINTHALFPAGE, PRINTHALFPAGEBYLONG = bill.PRINTHALFPAGEBYLONG, PRINTLANDSCIP = bill.PRINTLANDSCIP, PRINT_BILL_AS_RESET_OR_AS_BILL = bill.PRINT_BILL_AS_RESET_OR_AS_BILL, PRINT_BILL_AUTOMATIC = bill.PRINT_BILL_AUTOMATIC, PST = bill.PST, PSTNAME = bill.PSTNAME, REPEATETHE_ITEM_AT_THE_BILL = bill.REPEATETHE_ITEM_AT_THE_BILL, SATTLEMENT_INCOME_LIST = bill.SATTLEMENT_INCOME_LIST, SEARCH_ONLY_BY_DEAULT_UNIT = bill.SEARCH_ONLY_BY_DEAULT_UNIT, SECONDBILLMESSAGE = bill.SECONDBILLMESSAGE, SERIAL_NUMBER = bill.SERIAL_NUMBER, SHOW_BILL_PAY_TYPE = bill.SHOW_BILL_PAY_TYPE, SHOW_COST_CENTER = bill.SHOW_COST_CENTER, SHOW_EMPLOYEE = bill.SHOW_EMPLOYEE, SHOW_THE_COMPANY_DATA_ON_BILL = bill.SHOW_THE_COMPANY_DATA_ON_BILL, SHOW_THE_CURRENCY = bill.ABRV_BILL, SHOW_THE_CURRENT_QTY_ON_BILL = bill.SHOW_THE_CURRENT_QTY_ON_BILL, SHOW_THE_ITEM_CODE_ON_BILL = bill.SHOW_THE_ITEM_CODE_ON_BILL, SHOW_THE_LAST_BALANCE_ON_THE_BILL = bill.SHOW_THE_LAST_BALANCE_ON_THE_BILL, SHOW_THE_LAST_DATE_FOR_RETURN = bill.SHOW_THE_LAST_DATE_FOR_RETURN, SHOW_THE_RETURN_PERCENTAGE = bill.SHOW_THE_RETURN_PERCENTAGE, STORE_EFFECT_STATE = bill.STORE_EFFECT_STATE, THESECONDCELLISTHEITEMCELLNOTTHEQUANTITY = bill.THESECONDCELLISTHEITEMCELLNOTTHEQUANTITY, TO_COM_STORE_ID = bill.TO_COM_STORE_ID, UpdatedBy = bill.UpdatedBy, UpdatedOn = bill.UpdatedOn, ALTERNATE_COLOR_HEXA = bill.ALTERNATE_COLOR_HEXA, DEFAULT_COLOR_HEXA = bill.DEFAULT_COLOR_HEXA, Tax = bill.Tax, CommissionTax = bill.CommissionTax, IsAccount = bill.IsAccount, IsBillDate = bill.IsBillDate, IsBillRemarks = bill.IsBillRemarks, IsCompStoreID = bill.IsCompStoreID, IsCurrency = bill.IsCurrency, IsCurrencyTrans = bill.IsCurrencyTrans, IsCustAccID = bill.IsCustAccID, IsEmpID = bill.IsEmpID, IsItemAccID = bill.IsItemAccID, IsPayTypes = bill.IsPayTypes, IsPayWay = bill.IsPayWay, IsSellType = bill.IsSellType, IsShiftNumber = bill.IsShiftNumber, BillAccountName = bill.BillAccountName, BillEmpName = bill.BillEmpName, IsToCompStore = bill.IsToCompStore, IsTotalExtra = bill.IsTotalExtra, IsTotalMustPaid = bill.IsTotalMustPaid, IsTotalPaid = bill.IsTotalPaid, // IsTotalPrice = entity.IsTotalPrice, IsTotalRemaining = bill.IsTotalRemaining, AccWagesID = bill.AccWagesID, IsItems = bill.IsItems, IsItemsGroups = bill.IsItemsGroups, AccSalesID = bill.AccSalesID, AccVatRateID = bill.AccVatRateID, MenuID = bill.MenuID }; _billSettingsRepo.Delete(bs, bill.BILL_SETTING_ID); } } // return true; }
public Task <bool> DeleteAsync(Entry_SettingsVM entity) { return(Task.Run <bool>(() => { ENTRY_GRID_COLUMNS egc = entryGrdColRepo.Filter(X => X.ENTRY_SETTING_ID == entity.ENTRY_SETTING_ID).FirstOrDefault(); if (egc != null) { ENTRY_GRID_COLUMNS egc_ = new ENTRY_GRID_COLUMNS { ENTRY_SETTING_ID = egc.ENTRY_SETTING_ID, ACC_COLOR = egc.ACC_COLOR, ACC_INDEX = egc.ACC_INDEX, ACC_WIDTH = egc.ACC_WIDTH, COST_CENTER_COLOR = egc.COST_CENTER_COLOR, COST_CENTER_INDEX = egc.COST_CENTER_INDEX, COST_CENTER_WIDTH = egc.COST_CENTER_WIDTH, CREDIT_COLOR = egc.CREDIT_COLOR, CREDIT_INDEX = egc.CREDIT_INDEX, CREDIT_WIDTH = egc.CREDIT_WIDTH, DEBIT_COLOR = egc.DEBIT_COLOR, DEBIT_INDEX = egc.DEBIT_INDEX, DEBIT_WIDTH = egc.DEBIT_WIDTH, REMARKS_COLOR = egc.REMARKS_COLOR, REMARKS_INDEX = egc.REMARKS_INDEX, REMARKS_WIDTH = egc.REMARKS_WIDTH, AddedBy = egc.AddedBy, AddedOn = egc.AddedOn, UpdatedBy = egc.UpdatedBy, updatedOn = egc.updatedOn, ACC_COLOR_HEXA = egc.ACC_COLOR_HEXA, COST_CENTER_COLOR_HEXA = egc.COST_CENTER_COLOR_HEXA, CREDIT_COLOR_HEXA = egc.CREDIT_COLOR_HEXA, DEBIT_COLOR_HEXA = egc.DEBIT_COLOR_HEXA, REMARKS_COLOR_HEXA = egc.REMARKS_COLOR_HEXA, // TaxAccountID = entity.TaxAccountID }; entryGrdColRepo.Delete(egc_, egc.ENTRY_SETTING_ID); } UserMenu menu = userMenuRepo.Filter(u => u.EntrySettingID == entity.ENTRY_SETTING_ID).FirstOrDefault(); if (menu != null) { UserMenu userMenu = new UserMenu(); { userMenu.ID = menu.ID; userMenu.Code = menu.Code; userMenu.ARName = menu.ARName; userMenu.LatName = menu.LatName; userMenu.MenuLink = menu.MenuLink; userMenu.MenuClass = menu.MenuClass; userMenu.IconClass = menu.IconClass; userMenu.IconImageURL = menu.IconImageURL; userMenu.MenuID = menu.MenuID; userMenu.DisplayOrNot = menu.DisplayOrNot; userMenu.UserShortcut = menu.UserShortcut; userMenu.UserRoleID = menu.UserRoleID; userMenu.MenuType = menu.MenuType; userMenu.LanguageID = menu.LanguageID; userMenu.ResourceURL = menu.ResourceURL; userMenu.ResourceContent = menu.ResourceContent; userMenu.Notes = menu.Notes; userMenu.AddedBy = menu.AddedBy; userMenu.AddedOn = menu.AddedOn; userMenu.UpdatedBy = menu.UpdatedBy; userMenu.UpdatedOn = menu.UpdatedOn; userMenu.Active = menu.Active; userMenu.Position = menu.Position; userMenu.CountryID = menu.CountryID; userMenu.FRName = menu.FRName; userMenu.URName = menu.URName; userMenu.TRName = menu.TRName; userMenu.BillSetiingID = menu.BillSetiingID; userMenu.EntrySettingID = menu.EntrySettingID; }; userMenuRepo.Delete(userMenu, menu.ID); } ENTRY_SETTINGS et = new ENTRY_SETTINGS { ENTRY_SETTING_ID = entity.ENTRY_SETTING_ID, ACCEPT_DIST_ACC = entity.ACCEPT_DIST_ACC, AUTO_POSTING = entity.AUTO_POSTING, COSTCENTER_BELONG = entity.COSTCENTER_BELONG, CURRENCY_ID = entity.CURRENCY_ID, ENTRY_ACC_ID = entity.ENTRY_ACC_ID, ENTRY_SETTING_AR_ABRV = entity.ENTRY_SETTING_AR_ABRV, ENTRY_SETTING_AR_NAME = entity.ENTRY_SETTING_AR_NAME, ENTRY_SETTING_EN_ABRV = entity.ENTRY_SETTING_EN_ABRV, ENTRY_SETTING_EN_NAME = entity.ENTRY_SETTING_EN_NAME, ENTRY_TYPE_ID = entity.ENTRY_TYPE_ID, AddedBy = entity.AddedBy, AddedOn = entity.AddedOn, UpdatedBy = entity.UpdatedBy, updatedOn = entity.updatedOn, TaxAccountID = entity.TaxAccountID, MenuID = entity.MenuID, IsTaxable = entity.IsTaxable, TaxRate = entity.TaxRate, IsEnableTaxEdit = entity.IsEnableTaxEdit, TimesNumberOfPrinting = entity.TimesNumberOfPrinting, EntryModeID = entity.EntryModeID, IsTaxesIncluded = entity.IsTaxesIncluded, IsRepeatItem = entity.IsRepeatItem, IsQuickAccount = entity.IsQuickAccount, ExemptVatRate = entity.ExemptVatRate, MainVatRate = entity.MainVatRate, IsShowTaxesBox = entity.IsShowTaxesBox, IsTaxAccForAccount = entity.IsTaxAccForAccount }; entrySettingRepo.Delete(et, entity.ENTRY_SETTING_ID); return true; })); }