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