private Tbl_Wf_CuttingOrder DeleteCuttingOrder(Tbl_Wf_CuttingOrder order)
{
using (var entities = new WorkFlowManagerDBEntities())
{
var cuttingOrderQuery = (from c in entities.Tbl_Wf_CuttingOrder.Include("tbl_MarkerDetail.TblColor")
where c.MarkerIserial == order.MarkerIserial &&
c.InspectionIserial == order.InspectionIserial
select c).FirstOrDefault();
if (cuttingOrderQuery != null)
{
//var inspection =
// entities.Tbl_fabricInspectionDetail.FirstOrDefault(x => x.Iserial == order.InspectionIserial);
//if (inspection != null)
//{
// inspection.RemainingMarkerRollQty = (float)(inspection.RemainingMarkerRollQty +
// cuttingOrderQuery.RollAssignedQty);
//}
var reservationLines = entities.Tbl_ReservationRec.Include("Tbl_ReservationDetails1").FirstOrDefault(x => x.Tbl_FabricInspectionDetails == order.InspectionIserial &&
x.Tbl_ReservationDetails1.SalesOrder == cuttingOrderQuery.tbl_MarkerDetail.SalesOrder && x.Tbl_ReservationDetails1.SalesOrderColor == cuttingOrderQuery.tbl_MarkerDetail.TblColor.Code);
if (reservationLines != null)
{
entities.DeleteObject(reservationLines);
}
entities.DeleteObject(cuttingOrderQuery);
entities.SaveChanges();
return(order);
}
}
return(null);
}
public void DeletePurchaseOrder(tbl_PurchaseOrderHeader _Header, List <tbl_PurchaseOrderDetails> _Details)
{
using (var context = new WorkFlowManagerDBEntities())
{
try
{
var rch = (from x in context.tbl_PurchaseOrderHeader.ToList()
where x.TransID == _Header.TransID
select x).FirstOrDefault();
context.DeleteObject(rch);
foreach (var item in context.tbl_PurchaseOrderDetails
.Where
(
x => x.Trans_TransactionHeader == rch.TransID
).ToList())
{
context.DeleteObject(item);
}
context.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
}
public void DeleteDyeingOrderAcc(int dyeingHeaderIserial)
{
using (var entities = new WorkFlowManagerDBEntities())
{
var detailsList = entities.TblDyeingOrdersDetailsAccs.Include("DyeingOrderDetailsServicesAccs").Where(x => x.DyeingProductionOrder == dyeingHeaderIserial);
foreach (var item in detailsList)
{
foreach (var service in item.DyeingOrderDetailsServicesAccs.ToList())
{
entities.DeleteObject(service);
}
entities.DeleteObject(item);
}
var mainDetailsList = entities.TblDyeingOrdersMainDetailsACCs.Where(x => x.DyeingProductionOrder == dyeingHeaderIserial);
foreach (var item in mainDetailsList)
{
entities.DeleteObject(item);
}
var header = entities.TblDyeingOrdersHeaderAccs.SingleOrDefault(x => x.DyeingProductionOrder == dyeingHeaderIserial);
entities.DeleteObject(header);
entities.SaveChanges();
}
}
private int DeleteSml(TblSeasonalMasterList row)
{
using (var context = new WorkFlowManagerDBEntities())
{
var oldRow = (from e in context.TblSeasonalMasterLists
where e.Iserial == row.Iserial
select e).SingleOrDefault();
if (oldRow != null)
{
context.DeleteObject(oldRow);
}
//Delete from [TblTechPackBOMStyleColor]
try
{
var oldTechPackBOMStyleColorRow = (from e in context.TblTechPackBOMStyleColors
where e.TechPackBOM1.TblStyle == row.TblStyle && e.StyleColor == row.TblColor
select e).ToList();
foreach (var item in oldTechPackBOMStyleColorRow)
{
context.DeleteObject(item);
}
} catch { }
context.SaveChanges();
}
return(row.Iserial);
}
public void DeleteDyeingMainDetailsAcc(TblDyeingOrdersMainDetailsACC maindetails)
{
using (var entities = new WorkFlowManagerDBEntities())
{
var detailsList = entities.TblDyeingOrdersDetailsAccs.Include("DyeingOrderDetailsServicesAccs").Where(x => x.DyeingProductionOrder == maindetails.DyeingProductionOrder &&
x.TransactionType == maindetails.TransactionType && x.TransId == maindetails.TransId);
foreach (var item in detailsList)
{
foreach (var service in item.DyeingOrderDetailsServicesAccs.ToList())
{
entities.DeleteObject(service);
}
entities.DeleteObject(item);
}
var mainDet = entities.TblDyeingOrdersMainDetailsACCs.SingleOrDefault(x => x.DyeingProductionOrder == maindetails.DyeingProductionOrder &&
x.TransactionType == maindetails.TransactionType && x.TransId == maindetails.TransId);
entities.DeleteObject(mainDet);
entities.SaveChanges();
}
}
private int FamilyCategory_UpdateOrDeleteTblStyleCategoryLink(string brand, int section, int direction, int category, bool save)
{
using (var context = new WorkFlowManagerDBEntities())
{
if (save)
{
TblStyleCategoryLink newRow = new TblStyleCategoryLink();
newRow.TblBrand = brand;
newRow.TblLkpBrandSection = section;
newRow.TblLkpDirection = direction;
newRow.TblStyleCategory = category;
context.TblStyleCategoryLinks.AddObject(newRow);
}
else
{
//Delete From TblLkpstyleCategoryLink
var oldCategoryRow = (from e in context.TblStyleCategoryLinks
where e.TblLkpBrandSection == section &&
e.TblBrand == brand && e.TblLkpDirection == direction && e.TblStyleCategory == category
select e).SingleOrDefault();
if (oldCategoryRow != null)
{
context.DeleteObject(oldCategoryRow);
}
context.SaveChanges();
//Delete From TblLkpFamilyCategoryLink
var oldFamilyRow = (from e in context.TblFamilyCategoryLinks
where e.TblLkpBrandSection == section &&
e.TblBrand == brand && e.TblLkpDirection == direction && e.TblStyleCategory == category
select e);
foreach (var row in oldFamilyRow)
{
if (row != null)
{
context.DeleteObject(row);
}
}
context.SaveChanges();
//Delete From TblLkpFamilyCategoryLink
var oldSubFamilyRow = (from e in context.TblSubFamilyCategoryLinks
where e.TblLkpBrandSection == section &&
e.TblBrand == brand && e.TblLkpDirection == direction && e.TblStyleCategory == category
select e);
foreach (var row in oldSubFamilyRow)
{
if (row != null)
{
context.DeleteObject(row);
}
}
context.SaveChanges();
}
return(context.SaveChanges());
}
}
private int FamilyCategory_UpdateOrDeleteTblStyleTNARoute(int tblstyle, int TblStyleTNA, bool save)
{
using (var context = new WorkFlowManagerDBEntities())
{
if (save)
{
TblStyleTNARoute newRow = new TblStyleTNARoute();
newRow.TblStyle = tblstyle;
newRow.TblStyleTNA = TblStyleTNA;
context.TblStyleTNARoutes.AddObject(newRow);
return(context.SaveChanges());
}
else
{
//Delete From TblStyleTNARoute
var oldStyleTNARouteRow = (from e in context.TblStyleTNARoutes
where e.TblStyle == tblstyle &&
e.TblStyleTNA == TblStyleTNA
select e).SingleOrDefault();
if (oldStyleTNARouteRow != null)
{
context.DeleteObject(oldStyleTNARouteRow);
}
return(context.SaveChanges());
}
}
}
public void UpdateRFQSubHeader(List <tbl_RFQDetail> _RFQObjToUpdate, List <tbl_RFQDetail> _RFQObjToADD, List <tbl_RFQDetail> _RFQObjToDelete)
{
using (var contex = new WorkFlowManagerDBEntities())
{
foreach (var item in _RFQObjToADD)
{
contex.tbl_RFQDetail.AddObject(item);
}
foreach (var item in _RFQObjToUpdate)
{
var temp = (from x in contex.tbl_RFQDetail
where x.SubHeaderID == item.SubHeaderID
select x).SingleOrDefault();
GenerUpdate(temp, item, contex);
}
foreach (var temp in _RFQObjToDelete.Select(item => (from x in contex.tbl_RFQDetail
where x.SubHeaderID == item.SubHeaderID
select x).SingleOrDefault()))
{
contex.DeleteObject(temp);
}
contex.SaveChanges();
}
}
private TblCheckListLink UpdateOrDeleteTblCheckListLink(TblCheckListLink newRow, bool save, int index, out int outindex)
{
outindex = index;
using (var context = new WorkFlowManagerDBEntities())
{
if (save)
{
context.TblCheckListLinks.AddObject(newRow);
}
else
{
var oldRow = (from e in context.TblCheckListLinks
where e.TblCheckListGroup == newRow.TblCheckListGroup &&
e.TblCheckListItem == newRow.TblCheckListItem
select e).SingleOrDefault();
if (oldRow != null)
{
context.DeleteObject(oldRow);
}
}
context.SaveChanges();
return(newRow);
}
}
public void SaveAuthWarehouses(int userIserial, short PermissionIserial,
List <Models.Inv.AuthWarehouseModel> authList)
{
using (var context = new WorkFlowManagerDBEntities())
{
// Add Items
var curruntAuthList = context.TblAuthWarehouses.Where(aw =>
aw.AuthUserIserial == userIserial &&
aw.PermissionType == PermissionIserial).ToList();
foreach (var item in curruntAuthList)
{
context.DeleteObject(item);
}
var itemsToAdd = authList.Where(a => a.IsGranted);// &&
foreach (var item in itemsToAdd)
{
context.TblAuthWarehouses.AddObject(new TblAuthWarehouse()
{
WarehouseIserial = item.WarehouseIserial,
AuthUserIserial = userIserial,
PermissionType = PermissionIserial
});
}
context.SaveChanges();
}
}
private TblUserBrandSection UpdateOrDeleteTblUserBrandSection(TblUserBrandSection newRow, bool save, int index, out int outindex)
{
outindex = index;
using (var context = new WorkFlowManagerDBEntities())
{
if (save)
{
context.TblUserBrandSections.AddObject(newRow);
}
else
{
var oldRow = (from e in context.TblUserBrandSections
where e.TblLkpBrandSection == newRow.TblLkpBrandSection &&
e.BrandCode == newRow.BrandCode && e.TblAuthUser == newRow.TblAuthUser
select e).SingleOrDefault();
if (oldRow != null)
{
context.DeleteObject(oldRow);
}
}
context.SaveChanges();
return(newRow);
}
}
private void UpdateOrDeletedAccSubGroupSizeLink(TblAccSubGroupSizeLink newRow, bool save, int index, out int outindex)
{
outindex = index;
using (var context = new WorkFlowManagerDBEntities())
{
if (save)
{
var oldRow = (from e in context.TblAccSubGroupSizeLinks
where e.TblAccSize == newRow.TblAccSize &&
e.tbl_AccessoriesSubGroup == newRow.tbl_AccessoriesSubGroup
select e).SingleOrDefault();
if (oldRow == null)
{
context.TblAccSubGroupSizeLinks.AddObject(newRow);
}
}
else
{
var oldRow = (from e in context.TblAccSubGroupSizeLinks
where e.TblAccSize == newRow.TblAccSize &&
e.tbl_AccessoriesSubGroup == newRow.tbl_AccessoriesSubGroup
select e).SingleOrDefault();
if (oldRow != null)
{
context.DeleteObject(oldRow);
}
}
context.SaveChanges();
}
}
private int DeleteTblRecInvHeaderProd(TblRecInvHeaderProd row, int index, string company)
{
using (var entity = new WorkFlowManagerDBEntities())
{
var query = (from e in entity.TblRecInvHeaderProds
where e.Iserial == row.Iserial
select e).SingleOrDefault();
entity.CommandTimeout = 0;
if (query != null)
{
entity.DeleteObject(query);
using (var context = new ccnewEntities(GetSqlConnectionString(company)))
{
var ledgerheader = context.TblLedgerHeaders.FirstOrDefault(w => w.TblJournalLink == query.Iserial && w.TblTransactionType == 100);
if (ledgerheader != null)
{
context.DeleteObject(ledgerheader);
}
}
}
entity.SaveChanges();
}
return(row.Iserial);
}
public void UpdateRFQFollowUps(List <tbl_RFQFollowup> _RFQObjToUpdate, List <tbl_RFQFollowup> _RFQObjToADD, List <tbl_RFQFollowup> _RFQObjToDelete)
{
using (var contex = new WorkFlowManagerDBEntities())
{
foreach (var item in _RFQObjToADD)
{
contex.tbl_RFQFollowup.AddObject(item);
}
foreach (var item in _RFQObjToUpdate)
{
var temp = (from x in contex.tbl_RFQFollowup
where x.Iserial == item.Iserial
select x).SingleOrDefault();
GenerUpdate(temp, item, contex);
}
foreach (var temp in _RFQObjToDelete.Select(item => (from x in contex.tbl_RFQFollowup
where x.Iserial == item.Iserial
select x).SingleOrDefault()))
{
contex.DeleteObject(temp);
}
contex.SaveChanges();
}
}
public void UpdateNewPurchDetails(List <tblNewRFQPurchLine> purchToAdd,
List <tblNewRFQPurchLine> purchToUpdate, List <tblNewRFQPurchLine> purchToDelete)
{
using (var context = new WorkFlowManagerDBEntities())
{
foreach (var orderDetail in purchToAdd)
{
context.tblNewRFQPurchLines.AddObject(orderDetail);
}
foreach (var orderDetail in purchToUpdate)
{
var temp = (from x in context.tblNewRFQPurchLines
where x.Iserial == orderDetail.Iserial
select x).SingleOrDefault();
GenerUpdate(temp, orderDetail, context);
}
foreach (var purh in purchToDelete)
{
context.DeleteObject(purchToDelete);
}
try
{
var saveChanges = context.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
}
public void UpdateRFQSubHeaderServices(List <tbl_RFQDetailService> rfqObjToUpdate,
List <tbl_RFQDetailService> rfqObjToAdd, List <tbl_RFQDetailService> rfqObjToDelete)
{
using (var contex = new WorkFlowManagerDBEntities())
{
foreach (var item in rfqObjToAdd)
{
contex.tbl_RFQDetailService.AddObject(item);
}
foreach (var item in rfqObjToUpdate)
{
var temp = (from x in contex.tbl_RFQDetailService
where x.Iserial == item.Iserial
select x).SingleOrDefault();
GenerUpdate(temp, item, contex);
}
foreach (var temp in rfqObjToDelete.Select(item => (from x in contex.tbl_RFQDetailService
where x.Iserial == item.Iserial
select x).SingleOrDefault()))
{
contex.DeleteObject(temp);
}
contex.SaveChanges();
}
}
private TblFamilyLink UpdateOrDeleteTblFamilyLink(TblFamilyLink newRow, bool save, int index, out int outindex)
{
outindex = index;
using (var context = new WorkFlowManagerDBEntities())
{
if (save)
{
context.TblFamilyLinks.AddObject(newRow);
}
else
{
var oldRow = (from e in context.TblFamilyLinks
where e.TblFamily == newRow.TblFamily &&
e.TblBrand == newRow.TblBrand &&
e.TblLkpBrandSection == newRow.TblLkpBrandSection
select e).SingleOrDefault();
if (oldRow != null)
{
context.DeleteObject(oldRow);
}
}
context.SaveChanges();
return(newRow);
}
}
public List <tblNewRFQSizeDetail> UpdateOrInsertNewRfqSizeDetail(List <tblNewRFQSizeDetail> newRows, List <tblNewRFQSizeDetail> deletedRows)
{
using (var context = new WorkFlowManagerDBEntities())
{
foreach (var newRow in newRows)
{
var oldRow = (from e in context.tblNewRFQSizeDetails
where e.Iserial == newRow.Iserial
select e).SingleOrDefault();
if (oldRow != null)
{
GenericUpdate(oldRow, newRow, context);
}
else
{
context.tblNewRFQSizeDetails.AddObject(newRow);
}
}
foreach (var TblRFSDetail in deletedRows)
{
context.DeleteObject(TblRFSDetail);
}
context.SaveChanges();
}
return(newRows);
}
private void DeleteAdjustmentByIserial(int headerIserial, int CountingHeaderIserial)
{
using (var entities = new WorkFlowManagerDBEntities())
{
var temp = entities.TblAdjustmentHeaders.FirstOrDefault(ah => ah.Iserial == headerIserial);
var countingTemp = entities.TblAdjustmentHeaders.FirstOrDefault(ah => ah.Iserial == CountingHeaderIserial);
if (temp != null)
{
entities.DeleteObject(temp);
}
if (countingTemp != null)
{
entities.DeleteObject(countingTemp);
}
entities.SaveChanges();
}
}
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();
}
}
public void DeleteDyeingDetailsAcc(int iserial)
{
using (var entities = new WorkFlowManagerDBEntities())
{
var details = entities.TblDyeingOrdersDetailsAccs.Include("DyeingOrderDetailsServicesAccs").SingleOrDefault(x => x.Iserial == iserial);
if (details != null)
{
foreach (var service in details.DyeingOrderDetailsServicesAccs.ToList())
{
entities.DeleteObject(service);
}
entities.DeleteObject(details);
}
entities.SaveChanges();
}
}
public void RouteCardFabric(int iserial)
{
using (var context = new WorkFlowManagerDBEntities())
{
var rch = (context.RouteCardFabrics.SingleOrDefault(x => x.Iserial == iserial));
context.DeleteObject(rch);
context.SaveChanges();
}
}
public void DeleteUser(int Iserial)
{
using (WorkFlowManagerDBEntities context = new WorkFlowManagerDBEntities())
{
tbl_Auth_User user = context.tbl_Auth_User.Where(x => x.iserial == Iserial).Single();
context.DeleteObject(user);
context.SaveChanges();
}
}
public void DeleteRoutCard(int routeHeader, int userIserial)
{
using (var context = new WorkFlowManagerDBEntities())
{
var rch = (context.RouteCardHeaders.SingleOrDefault(x => x.Iserial == routeHeader));
var det = context.RouteCardDetails.Where(x => x.Direction == rch.Direction && x.RoutGroupID == rch.RoutGroupID &&
x.Trans_TransactionHeader == rch.TransID);
foreach (var item in det)
{
context.DeleteObject(item);
}
if (SharedOperation.UseAx())
{
DeleteAXroute(rch, userIserial);
}
context.DeleteObject(rch);
context.SaveChanges();
}
}
public void DeletePurchDetail(int detailSerial)
{
using (var context = new WorkFlowManagerDBEntities())
{
var temp = (from x in context.tbl_PurchaseOrderDetails
where x.Iserial == detailSerial
select x).SingleOrDefault();
context.DeleteObject(temp);
context.SaveChanges();
}
}
public void DeleteTechPackDesignDetails(int _tblTechPackDetail)
{
using (var context = new WorkFlowManagerDBEntities())
{
var oldRow = (from e in context.tblTechPackDetails
where e.Iserial == _tblTechPackDetail
select e).SingleOrDefault();
if (oldRow != null)
{
//Delete Log
var oldLogRow = (from e in context.tblTechPackLogs
where e.tblTechPackDetail == oldRow.Iserial
select e).ToList();
foreach (var item in oldLogRow)
{
context.DeleteObject(item);
}
context.DeleteObject(oldRow);
}
context.SaveChanges();
}
}
private int CheckApprovedSalesOrderColorCancelRequest(int tblSalesOrderColor)
{
using (var context = new WorkFlowManagerDBEntities())
{
var color = context.TblSalesOrderColors.Where(x => x.Iserial == tblSalesOrderColor && x.RequestForCancel == 2);
if (color != null)
{
context.DeleteObject(color.FirstOrDefault());
return(context.SaveChanges());
}
return(0);
}
}
public void DeleteBarcodeDisplaySettingsHeader(int Iserial)
{
using (var context = new WorkFlowManagerDBEntities())
{
var barcodeSettingRowQuery = (from h in context.BarcodeDisplaySettingsHeaders
where h.Iserial == Iserial
select h).SingleOrDefault();
var HeaderIserial = barcodeSettingRowQuery.Iserial;
var details = (from h in context.BarcodeDisplaySettingsDetails
where h.BarcodeDisplaySettingsHeader == HeaderIserial
select h).ToList();
foreach (var item in details)
{
context.DeleteObject(item);
}
context.DeleteObject(barcodeSettingRowQuery);
context.SaveChanges();
}
}
public int DeleteUser(int Iserial)
{
using (var context = new WorkFlowManagerDBEntities())
{
var user = context.TblAuthUsers.SingleOrDefault(x => x.Iserial == Iserial);
if (user != null)
{
context.DeleteObject(user);
}
context.SaveChanges();
}
return(Iserial);
}
public void UpdatePurchlineAdditionalCosts(List <tbl_PurchaseOrder_AdditionalCost> rfqObjToUpdate)
{
try
{
using (var contex = new WorkFlowManagerDBEntities())
{
foreach (var item in rfqObjToUpdate.Select(x => x.ParentPurchLineSerial).Distinct())
{
var item1 = item;
var temp = (from x in rfqObjToUpdate
let chk = CheckAdditionalCosts(x)
where x.ParentPurchLineSerial == item1 &&
!chk
select x);
foreach (var tempd in temp.ToList())
{
contex.tbl_PurchaseOrder_AdditionalCost.AddObject(tempd);
}
var tempdlh = (from x in contex.tbl_PurchaseOrder_AdditionalCost
.Where(z => z.ParentPurchLineSerial == item).ToList()
where rfqObjToUpdate.Any(z => z.Iserial != x.Iserial)
select x);
foreach (var tempdl in tempdlh)
{
contex.DeleteObject(tempdl);
}
}
foreach (var item in rfqObjToUpdate)
{
var temp = (from x in contex.tbl_PurchaseOrder_AdditionalCost
where x.Iserial == item.Iserial
select x).SingleOrDefault();
if (temp != null)
{
GenerUpdate(temp, item, contex);
}
}
contex.SaveChanges();
}
}
catch (Exception)
{
throw;
}
}