private TblPurchaseOrderHeaderRequest UpdateOrInsertTblPurchaseOrderHeaderRequest(TblPurchaseOrderHeaderRequest newRow, int index, int user, out int outindex) { outindex = index; using (var context = new WorkFlowManagerDBEntities()) { var warehouse = context.TblWarehouses.FirstOrDefault(w => w.Iserial == newRow.TblWarehouse).Po; var seq = context.TblSequenceProductions.FirstOrDefault(w => w.Iserial == warehouse); var oldRow = (from e in context.TblPurchaseOrderHeaderRequests where e.Iserial == newRow.Iserial select e).SingleOrDefault(); if (oldRow != null) { newRow.CreatedBy = oldRow.CreatedBy; newRow.CreationDate = oldRow.CreationDate; SharedOperation.GenericUpdate(oldRow, newRow, context); } else { newRow.CreationDate = DateTime.Now; newRow.CreatedBy = user; newRow.Code = SharedOperation.HandelSequence(seq); context.TblPurchaseOrderHeaderRequests.AddObject(newRow); } context.SaveChanges(); return(newRow); } }
private List <ViewPurchaseOrderHeaderRequest> GetTblPurchaseOrderHeaderRequest(int skip, int take, string sort, string filter, Dictionary <string, object> valuesObjects, out int fullCount, out List <Vendor> vendorList) { using (var context = new WorkFlowManagerDBEntities()) { context.ViewPurchaseOrderHeaderRequests.MergeOption = MergeOption.NoTracking; IQueryable <ViewPurchaseOrderHeaderRequest> query; if (filter != null) { var parameterCollection = SharedOperation.ConvertToParamters(valuesObjects); fullCount = context.ViewPurchaseOrderHeaderRequests.Where(filter, parameterCollection.ToArray()).Count(); query = context.ViewPurchaseOrderHeaderRequests.Where(filter, parameterCollection.ToArray()).OrderBy(sort).Skip(skip).Take(take); } else { fullCount = context.ViewPurchaseOrderHeaderRequests.Count(); query = context.ViewPurchaseOrderHeaderRequests.OrderBy(sort).Skip(skip).Take(take); } var vendorListStrings = query.Select(x => x.Vendor); vendorList = context.Vendors.Where(x => vendorListStrings.Any(l => x.vendor_code == l)).ToList(); return(query.OrderByDescending(w => w.Iserial).ToList()); } }
private List <TblPurchaseOrderHeaderRequestPayment> UpdateOrInsertTblPurchaseOrderHeaderRequestPayments(List <TblPurchaseOrderHeaderRequestPayment> ListToSave) { using (var entity = new WorkFlowManagerDBEntities()) { foreach (var newRow in ListToSave) { if (newRow.Iserial == 0) { entity.TblPurchaseOrderHeaderRequestPayments.AddObject(newRow); } else { var oldRow = (from e in entity.TblPurchaseOrderHeaderRequestPayments where e.Iserial == newRow.Iserial select e).SingleOrDefault(); if (oldRow != null) { SharedOperation.GenericUpdate(oldRow, newRow, entity); } } } entity.SaveChanges(); return(ListToSave); } }
private TblService UpdateOrInsertTblService(TblService newRow, bool save, int index, int user, out int outindex) { outindex = index; using (var context = new WorkFlowManagerDBEntities()) { if (save) { context.TblServices.AddObject(newRow); } else { var oldRow = (from e in context.TblServices where e.Iserial == newRow.Iserial select e).SingleOrDefault(); if (oldRow != null) { GenericUpdate(oldRow, newRow, context); } } context.SaveChanges(); if (SharedOperation.UseAx()) { if (save) { InsertServiceItem(newRow, user); } } return(newRow); } }
private List <BankStatMatchingModel> GetLedgerDetailMatchedByBankStatDetailId( int headerId, int bankStatDetailId, bool isChecked, string company) { using (var context = new ccnewEntities(SharedOperation.GetSqlConnectionString(company))) { var header = context.TblBankStatHeaders.First(bs => bs.Iserial == headerId); var query = context.TblLedgerMainDetails.Where(v => v.TblJournalAccountType == 6 && v.EntityAccount == header.TblBank && context.TblBankStatDetailTblLedgerDetails.Any(bsdld => bsdld.TblLedgerMainDetail == v.Iserial && bsdld.TblBankStatDetail == bankStatDetailId && bsdld.TblBankStatDetail1.TblBankStatHeader == headerId)).Select( bsd => new BankStatMatchingModel() { IsLedger = true, Iserial = bsd.Iserial, IsChecked = isChecked, DocDate = bsd.TransDate, Description = bsd.Description, Amount = bsd.DrOrCr ? bsd.Amount.Value : (bsd.Amount.Value * -1), ChequeNo = bsd.TblBankCheque1.Cheque, DepositNo = bsd.PaymentRef, }); var result = query.ToList(); return(result); } }
private TblContractPaymentByPeriod UpdateOrInsertContractPaymentDetail( TblContractPaymentByPeriod newRow, int userIserial, int index, out int outindex) { outindex = index; newRow.TblContractHeader1 = null; using (var context = new WorkFlowManagerDBEntities()) { var oldRow = (from e in context.TblContractPaymentByPeriods where e.Iserial == newRow.Iserial select e).SingleOrDefault(); if (oldRow != null) { //context.Entry(oldRow).CurrentValues.SetValues(newRow); var result = SharedOperation.GenericUpdate(oldRow, newRow, context); if (result.Count() > 0) { oldRow.LastChangeDate = DateTime.Now; oldRow.LastChangeUser = userIserial; } } else { newRow.CreatedBy = userIserial; newRow.LastChangeUser = userIserial; newRow.CreationDate = DateTime.Now; newRow.LastChangeDate = DateTime.Now; context.TblContractPaymentByPeriods.AddObject(newRow); } context.SaveChanges(); return(newRow); } }
private List <TblSalaryApprovalDetail> GetSalaryApprovalDetail(int skip, int take, int ledgerHeader, string sort, string filter, Dictionary <string, object> valuesObjects, out int fullCount, out List <TblEmployee> EmpList, string company) { using (var context = new ccnewEntities(SharedOperation.GetSqlConnectionString(company))) { IQueryable <TblSalaryApprovalDetail> query; if (filter != null) { filter = filter + " and it.TblSalaryApprovalHeader ==(@Group0)"; valuesObjects.Add("Group0", ledgerHeader); var parameterCollection = SharedOperation.ConvertToParamters(valuesObjects); fullCount = context.TblSalaryApprovalDetails.Where(filter, parameterCollection.ToArray()).Count(); query = context.TblSalaryApprovalDetails.OrderBy(sort).Where(filter, parameterCollection.ToArray()).Skip(skip).Take(take); } else { fullCount = context.TblSalaryApprovalDetails.Count(v => v.TblSalaryApprovalHeader == ledgerHeader); query = context.TblSalaryApprovalDetails.OrderBy(sort).Where(v => v.TblSalaryApprovalHeader == ledgerHeader).Skip(skip).Take(take); } List <int> intList = query.Select(x => x.TblEmployee).ToList(); EmpList = context.TblEmployees.Where(x => intList.Contains(x.iserial)).ToList(); return(query.ToList()); } }
private TblSalaryApprovalHeader UpdateOrInsertSalaryApprovalHeader(TblSalaryApprovalHeader newRow, int index, int userIserial, out int outindex, string company) { outindex = index; using (var context = new ccnewEntities(SharedOperation.GetSqlConnectionString(company))) { try { var oldRow = context.TblSalaryApprovalHeaders.FirstOrDefault(th => th.Iserial == newRow.Iserial); if (oldRow != null)// الهيدر موجود قبل كده { oldRow.StoreApproved = newRow.StoreApproved; //foreach (var item in newRow.TblSalaryApprovalDetails.ToArray()) //{ // // هشوف بقى الى اتعدل والجديد // int temp; // //headeriserial = item.TblSalaryApprovalHeader; // item.TblSalaryApprovalHeader1 = null; // item.TblSalaryApprovalHeader = newRow.Iserial; // UpdateOrInsertSalaryApprovalDetail(item, userIserial, 1, out temp,company); // item.TblSalaryApprovalHeader1Reference = null; //} //context.Entry(oldRow).CurrentValues.SetValues(newRow); } else// الهيدر ده جديد { context.TblSalaryApprovalHeaders.AddObject(newRow); } context.SaveChanges(); } catch (Exception ex) { throw ex; } return(newRow); } }
private List <BankStatMatchingModel> GetLedgerDetailForMatching(int headerId, string company) { using (var context = new ccnewEntities(SharedOperation.GetSqlConnectionString(company))) { var header = context.TblBankStatHeaders.Include(nameof(TblBankStatHeader.TblCurrency1)).FirstOrDefault(bs => bs.Iserial == headerId && !bs.MatchApproved); var query = new List <BankStatMatchingModel>().AsQueryable(); if (header != null) { query = context.TblLedgerMainDetails.Where(v => v.TransDate <= header.ReconcileDate && (v.TblCurrency == header.TblCurrency || v.TblCurrency1.ExchangeRate == header.TblCurrency1.ExchangeRate) && v.TblJournalAccountType == 6 && v.EntityAccount == header.TblBank && !context.TblBankStatDetailTblLedgerDetails.Any(bsdld => bsdld.TblLedgerMainDetail == v.Iserial)).Select(bsd => new BankStatMatchingModel() { IsLedger = true, Iserial = bsd.Iserial, IsChecked = false, DocDate = bsd.TransDate ?? bsd.TblLedgerHeader1.DocDate, Description = bsd.Description, Amount = bsd.DrOrCr ? bsd.Amount.Value : (bsd.Amount.Value * -1), ChequeNo = bsd.TblBankCheque1.Cheque, DepositNo = bsd.PaymentRef, }); } var result = query.ToList(); //result.ForEach(r => r.Amount = Math.Round(r.Amount, roundFraction)); return(result); } }
private List <RouteCardInvoiceHeader> GetRouteCardInvoiceHeader(int skip, int take, string sort, string filter, Dictionary <string, object> valuesObjects, out int fullCount, out List <Vendor> Vendors) { using (var context = new WorkFlowManagerDBEntities()) { IQueryable <RouteCardInvoiceHeader> query; if (filter != null) { var parameterCollection = SharedOperation.ConvertToParamters(valuesObjects); fullCount = context.RouteCardInvoiceHeaders.Where(filter, parameterCollection.ToArray()).Count(); query = context.RouteCardInvoiceHeaders.Where(filter, parameterCollection.ToArray()).OrderBy(sort).Skip(skip).Take(take); } else { fullCount = context.RouteCardInvoiceHeaders.Count(); query = context.RouteCardInvoiceHeaders.OrderBy(sort).Skip(skip).Take(take); } var codes = query.Select(w => w.Vendor).ToList(); Vendors = context.Vendors.Where(x => codes.Contains(x.vendor_code)).ToList(); return(query.ToList()); } }
private TblBankStatHeader GetBankStatHeaderByIserial(int headerIserial, string company) { using (var context = new ccnewEntities(SharedOperation.GetSqlConnectionString(company))) { return(context.TblBankStatHeaders.FirstOrDefault(ah => ah.Iserial == headerIserial)); } }
private List <TblAdjustmentHeader> GetAdjustment(int skip, int take, string sort, string filter, Dictionary <string, object> valuesObjects, int userIserial, bool openningBalance, out int fullCount) { using (var context = new WorkFlowManagerDBEntities()) { var defaultQuery = context.TblAdjustmentHeaders.Include(nameof( TblAdjustmentHeader.TblWarehouse)).Where(a => a.IsOpeningBalance == openningBalance); IQueryable <TblAdjustmentHeader> query; if (filter != null) { var parameterCollection = SharedOperation.ConvertToParamters(valuesObjects); fullCount = defaultQuery.Where(filter, parameterCollection.ToArray()).Where(tr => context.TblAuthWarehouses.Any(aw => aw.AuthUserIserial == userIserial && aw.PermissionType == (short)AuthWarehouseType.Adjustment && (aw.WarehouseIserial == tr.WarehouseIserial))).Count(); query = defaultQuery.Where(filter, parameterCollection.ToArray()).OrderBy(sort).Where(tr => context.TblAuthWarehouses.Any(aw => aw.AuthUserIserial == userIserial && aw.PermissionType == (short)AuthWarehouseType.Adjustment && (aw.WarehouseIserial == tr.WarehouseIserial))); } else { fullCount = defaultQuery.Where(tr => context.TblAuthWarehouses.Any(aw => aw.AuthUserIserial == userIserial && aw.PermissionType == (short)AuthWarehouseType.Adjustment && (aw.WarehouseIserial == tr.WarehouseIserial))).Count(); query = defaultQuery.OrderBy(sort).Where(tr => context.TblAuthWarehouses.Any(aw => aw.AuthUserIserial == userIserial && aw.PermissionType == (short)AuthWarehouseType.Adjustment && (aw.WarehouseIserial == tr.WarehouseIserial))); } return(query.Skip(skip).Take(take).ToList()); } }
private TblDyeingOrderInvoiceHeader UpdateOrInsertDyeingOrderInvoiceHeader(TblDyeingOrderInvoiceHeader newRow, bool save, int index, out int outindex) { outindex = index; using (var context = new WorkFlowManagerDBEntities()) { if (save) { var seqCode = SharedOperation.GetChainSetup("GlDyeingPostSequence"); var seqProd = context.TblSequenceProductions.FirstOrDefault(w => w.Code == seqCode); newRow.Code = SharedOperation.HandelSequence(seqProd); context.TblDyeingOrderInvoiceHeaders.AddObject(newRow); } else { var oldRow = (from e in context.TblDyeingOrderInvoiceHeaders where e.Iserial == newRow.Iserial select e).SingleOrDefault(); if (oldRow != null) { SharedOperation.GenericUpdate(oldRow, newRow, context); } } context.SaveChanges(); return(newRow); } }
private TblAdjustmentTempDetail UpdateOrInsertAdjustmentTempDetail(TblAdjustmentTempDetail newRow, int index, out int outindex) { outindex = index; using (var context = new WorkFlowManagerDBEntities()) { try { var oldRow = (from e in context.TblAdjustmentTempDetails where e.Iserial == newRow.Iserial select e).SingleOrDefault(); if (oldRow != null) { //context.Entry(oldRow).CurrentValues.SetValues(newRow); SharedOperation.GenericUpdate(oldRow, newRow, context); } else { context.TblAdjustmentTempDetails.AddObject(newRow); } context.SaveChanges(); } catch (Exception ex) { } return(newRow); } }
private List <string> InsertRemainingImportedItems(int headerIserial, List <ImportedBankStatement> importedList, string company) { using (var entities = new ccnewEntities(SharedOperation.GetSqlConnectionString(company))) { var header = entities.TblBankStatHeaders.FirstOrDefault(ah => ah.Iserial == headerIserial); List <string> errors = new List <string>(); try { foreach (var item in importedList) { TblBankStatDetail detail = PrepareDetail(entities, header, item, errors); if (detail != null) { // Add detail header.TblBankStatDetails.Add(detail); } } entities.SaveChanges(); return(errors); } catch (Exception ex) { throw ex; } } }
private TblStyleTNAStatusDetail UpdateOrInsertTblStyleTNAStatusDetail(TblStyleTNAStatusDetail newRow, int index, out int outindex) { outindex = index; using (var context = new WorkFlowManagerDBEntities()) { // context.Connection.ConnectionTimeout = 0; var oldRow = (from e in context.TblStyleTNAStatusDetails where e.Iserial == newRow.Iserial select e).SingleOrDefault(); if (oldRow != null) { SharedOperation.GenericUpdate(oldRow, newRow, context); } else { context.TblStyleTNAStatusDetails.AddObject(newRow); } var styleTNA = context.TblStyleTNAHeaders.Include(nameof(TblStyleTNAHeader.TblStyle1)).Include(nameof(TblStyleTNAHeader.TblStyleTNAColorDetails)).FirstOrDefault(x => x.Iserial == newRow.TblStyleTNAHeader); styleTNA.TblStyleTNAStatus = newRow.TblStyleTnaStatus; if (styleTNA.TblStyleTNAStatus == 1) { GenerateSalesOrderFromTna(styleTNA); } context.SaveChanges(); return(newRow); } }
private TblDyeingOrderInvoiceMarkupTransProd UpdateOrInsertDyeingOrderInvoiceMarkupTransProds(TblDyeingOrderInvoiceMarkupTransProd newRow, bool save, int index, out int outindex, string company) { outindex = index; using (var entity = new ccnewEntities(SharedOperation.GetSqlConnectionString(company))) { var entityrow = entity.Entities.Any(w => w.Iserial == newRow.TblMarkupProd && w.scope == 0 && w.TblJournalAccountType == 9 && w.AccountIserial != 0); if (!entityrow) { newRow.Iserial = -1; return(newRow); } } using (var entity = new WorkFlowManagerDBEntities()) { newRow.TblMarkupProd1 = null; if (save) { entity.TblDyeingOrderInvoiceMarkupTransProds.AddObject(newRow); } else { var oldRow = (from e in entity.TblDyeingOrderInvoiceMarkupTransProds where e.Iserial == newRow.Iserial select e).SingleOrDefault(); if (oldRow != null) { SharedOperation.GenericUpdate(oldRow, newRow, entity); } } entity.SaveChanges(); return(newRow); } }
private List <TblStoreCommission> UpdateOrInsertStoreCommission(List <TblStoreCommission> newRows, string company)// int index, out int outindex, { //outindex = index; using (var context = new ccnewEntities(service.GetSqlConnectionString(company))) { try { foreach (var item in newRows) { var oldRow = context.TblStoreCommissions.FirstOrDefault(th => th.Tblstore == item.Tblstore); if (oldRow != null) { SharedOperation.GenericUpdate(oldRow, item, context); } else { item.TblStore1 = null; context.TblStoreCommissions.AddObject(item); } context.SaveChanges(); } } catch (Exception ex) { throw Helper.GetInnerException(ex); } return(newRows); } }
private TblUsersApprovalStatu UpdateOrInsertTblUsersApprovalStatus(TblUsersApprovalStatu newRow, bool save, int index, int user, out int outindex) { outindex = index; try { using (var context = new WorkFlowManagerDBEntities()) { if (save) { context.TblUsersApprovalStatus.AddObject(newRow); } else { var oldRow = (from e in context.TblUsersApprovalStatus where e.Iserial == newRow.Iserial select e).SingleOrDefault(); if (oldRow != null) { SharedOperation.GenericUpdate(oldRow, newRow, context); } } context.SaveChanges(); } return(newRow); } catch (Exception) { return(newRow); } }
public tbl_AccessoryAttributesHeader UpdateAccessoriesAttributes( tbl_AccessoryAttributesHeader header , List <tbl_AccessoryAttributesDetails> detailsToAdd , List <tbl_AccessoryAttributesDetails> detailsToUpdate, int userIserial) { try { //InsertAllNewAccessoryToAx(detailsToAdd, header, true); using (var context = new WorkFlowManagerDBEntities()) { // var htemp = context.tbl_AccessoryAttributesHeader.FirstOrDefault(x => x.Code == header.Code); // GenericUpdate(htemp, header, context); // var colorGroup = context.TblLkpColorGroups.FirstOrDefault(x => x.Code == "Acc").Iserial; foreach (var item in detailsToUpdate) { var dtemp = context.tbl_AccessoryAttributesDetails.FirstOrDefault( x => x.Iserial == item.Iserial); GenericUpdate(dtemp, item, context); } if (SharedOperation.UseAx()) { try { UpdateAccDetailsInAX(detailsToUpdate, userIserial); InsertAllNewAccessoryToAx(detailsToUpdate, header, false, userIserial); } catch (Exception) { } } foreach (var item in detailsToAdd) { context.tbl_AccessoryAttributesDetails.AddObject(item); } if (SharedOperation.UseAx()) { try { UpdateAccDetailsInAX(detailsToAdd, userIserial); } catch (Exception) { } } context.SaveChanges(); return(context.tbl_AccessoryAttributesHeader.Include(nameof(tbl_AccessoryAttributesHeader.tbl_AccessoryAttributesDetails)).FirstOrDefault(x => x.Code == header.Code)); } } catch (Exception ex) { throw ex; } }
private TblStore GetUserDefaultStore(int user, string company, int tblStore) { using (var context = new ccnewEntities(SharedOperation.GetSqlConnectionString(company))) { //var ccnewUserStore = context.TblUserWFMappings.FirstOrDefault(x => x.WFTblAuthUser == user).TblUser1.ActiveStore; var activeStore = context.TblStores.FirstOrDefault(x => x.iserial == tblStore); return(activeStore); } }
private List <TblBankTransactionType> GetLookUpBankTransactionType(string company) { using (var context = new ccnewEntities(SharedOperation.GetSqlConnectionString(company))) { IQueryable <TblBankTransactionType> query; query = context.TblBankTransactionTypes; return(query.ToList()); } }
private List <TblCurrencyTest> GetLookUpCurrency(string company) { using (var context = new ccnewEntities(SharedOperation.GetSqlConnectionString(company))) { IQueryable <TblCurrencyTest> query; query = context.TblCurrencyTests; return(query.ToList()); } }
private List <TblBankStatDetail> GetBankStatDetail(int skip, int take, int headerId, string company) { using (var context = new ccnewEntities(SharedOperation.GetSqlConnectionString(company))) { var query = context.TblBankStatDetails.Include(nameof(TblBankStatDetail.TblBankStatHeader1 )).Where(v => v.TblBankStatHeader == headerId).OrderBy(x => x.Iserial).Skip(skip).Take(take); var result = query.ToList(); return(result); } }
private void DeleteBankStatByIserial(int headerIserial, string company) { using (var entities = new ccnewEntities(SharedOperation.GetSqlConnectionString(company))) { var temp = entities.TblBankStatHeaders.FirstOrDefault(ah => ah.Iserial == headerIserial); if (temp != null) { entities.DeleteObject(temp); } entities.SaveChanges(); } }
public List <TblTradeAgreementTransaction> GetTblTradeAgreementTransaction(int skip, int take, string sort, string filter, Dictionary <string, object> valuesObjects, out int fullCount) { string itemCode = null; if (filter != null && valuesObjects != null && filter.Contains("it." + nameof(TblLkpSeason.Code))) { var val = valuesObjects.FirstOrDefault(k => k.Key.StartsWith(nameof(TblLkpSeason.Code))); if (val.Value != null) { itemCode = val.Value.ToString().Replace("%", ""); } var startIndex = filter.IndexOf(string.Format("it.{0} LIKE(", nameof(TblLkpSeason.Code))); var lastIndex = filter.IndexOf(")", startIndex); filter = filter.Remove(startIndex, lastIndex - startIndex + 1).Trim().Replace(" ", " ").Replace("and and", "and").Trim(); if (filter.StartsWith("and")) { filter = filter.Remove(0, 3); } if (filter.EndsWith("and")) { filter = filter.Remove(filter.Length - 3, 3); } valuesObjects.Remove(val.Key); //valuesObjects.Add(val.Key, "%%"); } using (var context = new WorkFlowManagerDBEntities()) { IQueryable <TblTradeAgreementTransaction> query = context.TblTradeAgreementTransactions.Include( nameof(TblTradeAgreementTransaction.TblLkpSeason1)); if (string.IsNullOrWhiteSpace(itemCode)) { query.Where(t => t.TblTradeAgreementHeaders.Any(h => h.TblTradeAgreementDetails.Any(d => context.FabricAccSearches.Any(f => f.Iserial == d.ItemCode && f.Code == itemCode)))); } if (!string.IsNullOrWhiteSpace(filter)) { var parameterCollection = SharedOperation.ConvertToParamters(valuesObjects); fullCount = context.TblTradeAgreementTransactions.Where(filter, parameterCollection.ToArray()).Count(); query = query.Where(filter, parameterCollection.ToArray()).OrderBy(sort).Skip(skip).Take(take); } else { fullCount = context.TblTradeAgreementTransactions.Count(); query = query.OrderBy(sort).Skip(skip).Take(take); } return(query.ToList()); } }
private int DeleteSalaryApprovalDetail(TblSalaryApprovalDetail row, int userIserial, string company) { using (var context = new ccnewEntities(SharedOperation.GetSqlConnectionString(company))) { var oldRow = (from e in context.TblSalaryApprovalDetails where e.Iserial == row.Iserial select e).SingleOrDefault(); if (oldRow != null) { context.DeleteObject(oldRow); context.SaveChanges(); } } return(row.Iserial); }
private int DeleteBankStatHeader(TblBankStatHeader row, string company) { using (var context = new ccnewEntities(SharedOperation.GetSqlConnectionString(company))) { var oldRow = (from e in context.TblBankStatHeaders where e.Iserial == row.Iserial select e).SingleOrDefault(); if (oldRow != null) { context.DeleteObject(oldRow); } context.SaveChanges(); } return(row.Iserial); }
public List <Models.Inv.AuthWarehouseModel> GetAuthJournalSetting(int userIserial, string company) { using (var context = new ccnewEntities(SharedOperation.GetSqlConnectionString(company))) { return(context.TblJournalSettings.Select(w => new Models.Inv.AuthWarehouseModel() { WarehouseIserial = w.Iserial, WarehoseEname = w.Ename, WarehouseCode = w.Aname, IsGranted = context.TblAuthUserJournalSettings.Any(aw => aw.TblAuthUser == userIserial && aw.TblJournalSetting == w.Iserial) }).ToList()); } }
public void DeleteReservationOrder(Tbl_ReservationHeader reservationHeader, int userIserial) { var axapta = new Axapta();//Ready To be Dependent from Ax if (SharedOperation.UseAx()) { var credential = new NetworkCredential("bcproxy", "around1"); TblAuthUser userToLogin; using (var model = new WorkFlowManagerDBEntities()) { userToLogin = model.TblAuthUsers.SingleOrDefault(x => x.Iserial == userIserial); } axapta.LogonAs(userToLogin.User_Win_Login, userToLogin.User_Domain, credential, "Ccm", null, null, null); } using (var entities = new WorkFlowManagerDBEntities()) { var headerRow = entities.Tbl_ReservationHeader.SingleOrDefault(x => x.Iserial == reservationHeader.Iserial); var rows = entities.Tbl_ReservationMainDetails.Include("Tbl_ReservationDetails").Include("Tbl_ReservationHeader1").Where(x => x.Tbl_ReservationHeader == reservationHeader.Iserial); foreach (var mainRow in rows) { foreach (var detailsRow in mainRow.Tbl_ReservationDetails.ToList()) { entities.DeleteObject(detailsRow); if (SharedOperation.UseAx()) { var importNew = axapta.CreateAxaptaObject("CreateProductionJournals"); if (detailsRow.AxPicklingListJournal != null) { importNew.Call("deletejournal", 0, detailsRow.AxPicklingListJournal, 0); } } } entities.DeleteObject(mainRow); } entities.DeleteObject(headerRow); entities.SaveChanges(); } if (SharedOperation.UseAx()) { axapta.Logoff(); } }