/// <summary> /// GetRequisitionDetailsByID is providing List of RequisitionDetails ByID /// </summary> /// <returns></returns> /// public tPartReqDetail GetRequisitionDetailsByPRD_ID(long RecID, string[] conn) { BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));; tPartReqDetail ReqDetails = new tPartReqDetail(); ReqDetails = ce.tPartReqDetails.Where(p => p.PRM_ID == RecID).First(); ce.Detach(ReqDetails); return(ReqDetails); }
/// <summary> /// GetMaterialIssueDetailsByID is providing List of Material Issue Details ByID /// </summary> /// <returns></returns> /// public tMINDetail GetMaterialIssueDetailsByID(long RecID, string[] conn) { BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); tMINDetail IssueDetails = new tMINDetail(); IssueDetails = ce.tMINDetails.Where(p => p.MIN_ID == RecID).FirstOrDefault(); ce.Detach(IssueDetails); return(IssueDetails); }
/// <summary> /// GetRequisitionByID is providing List of Requisition ByID /// </summary> /// <returns></returns> /// public tPartRequisition GetRequisitionByID(long RecID, string[] conn) { BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));; tPartRequisition Requisition = new tPartRequisition(); Requisition = ce.tPartRequisitions.Where(p => p.PRM_ID == RecID).FirstOrDefault(); ce.Detach(Requisition); return(Requisition); }
/// <summary> /// GetGRNDetailsByID is providing List of GRN Details ByID /// </summary> /// <returns></returns> /// public tGRNDetail GetGRNDetailsByID(long RecID, string[] conn) { BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); tGRNDetail GRNDetails = new tGRNDetail(); GRNDetails = ce.tGRNDetails.Where(p => p.GRN_ID == RecID).FirstOrDefault(); ce.Detach(GRNDetails); return(GRNDetails); }
/// <summary> /// GetDepartmentListByID is providing List of DepartmentList ByID /// </summary> /// <returns></returns> /// public v_GetSiteDetails GetTerritoryListByID(long TerritoryId, string[] conn) { BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));; v_GetSiteDetails Territory = new v_GetSiteDetails(); Territory = ce.v_GetSiteDetails.Where(p => p.ID == TerritoryId).FirstOrDefault(); ce.Detach(Territory); return(Territory); }
public mPrefixMaster GetPrefixMasterByID(int PrefID, string[] conn) { BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); mPrefixMaster PrID = new mPrefixMaster(); PrID = (from p in ce.mPrefixMasters where p.PreID == PrefID select p).FirstOrDefault(); ce.Detach(PrID); return(PrID); }
/// <summary> /// GetTaxListByID is providing List of Tax By ID /// </summary> /// <returns></returns> /// public mTaxSetup GetTaxListByID(int taxId, string[] conn) { BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); mTaxSetup TaxID = new mTaxSetup(); TaxID = (from p in ce.mTaxSetups where p.ID == taxId select p).FirstOrDefault(); ce.Detach(TaxID); return(TaxID); }
/// <summary> /// GetDesignationListByID is providing List of DesignationList By ID /// </summary> /// <returns></returns> /// public mStatutory GetGetStatutoryListByID(int statutoryId, string[] conn) { BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); mStatutory StatutoryID = new mStatutory(); StatutoryID = (from p in ce.mStatutories where p.ID == statutoryId select p).FirstOrDefault(); ce.Detach(StatutoryID); return(StatutoryID); }
/// <summary> /// GetUserCreationList is providing List of User /// </summary> /// <returns></returns> /// public mUserProfileHead GetUserByID(long UserID, string[] conn) { BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); mUserProfileHead User = new mUserProfileHead(); User = (from p in ce.mUserProfileHeads where p.ID == UserID select p).FirstOrDefault(); ce.Detach(User); return(User); }
/// <summary> /// GetDepartmentListByID is providing List of DepartmentList ByID /// </summary> /// <returns></returns> /// public mDepartment GetDepartmentListByID(int DepartmentId, string[] conn) { BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));; mDepartment DepartmentID = new mDepartment(); DepartmentID = (from p in ce.mDepartments where p.ID == DepartmentId select p).FirstOrDefault(); ce.Detach(DepartmentID); return(DepartmentID); }
/// <summary> /// GetLeadSourceList is providing List of LeadSource /// </summary> /// <returns></returns> /// public mContactType GetContactTypeListByID(int ContactTypeId, string[] conn) { BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); mContactType ContactType1 = new mContactType(); ContactType1 = (from p in ce.mContactTypes where p.ID == ContactTypeId select p).FirstOrDefault(); ce.Detach(ContactType1); return(ContactType1); }
public mUOM GetProductUOMListByID(int prdUOMId, string[] conn) { BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); mUOM ProductUOMID = new mUOM(); ProductUOMID = (from p in ce.mUOMs where p.ID == prdUOMId select p).FirstOrDefault(); ce.Detach(ProductUOMID); return(ProductUOMID); }
/// <summary> /// GetProductSubCategoryListByID is providing List of ProductSubCategory By ID /// </summary> /// <returns></returns> /// public mProductSubCategory GetProductSubCategoryListByID(int ProductSubCategoryId, string[] conn) { BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); mProductSubCategory PrdSubCategoryID = new mProductSubCategory(); PrdSubCategoryID = (from p in ce.mProductSubCategories where p.ID == ProductSubCategoryId select p).FirstOrDefault(); ce.Detach(PrdSubCategoryID); return(PrdSubCategoryID); }
/// <summary> /// GetRouteList is providing List of Route /// </summary> /// <returns></returns> /// public mRoute GetRouteListByID(int RouteId, string[] conn) { BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); mRoute RouteList = new mRoute(); RouteList = (from p in ce.mRoutes where p.ID == RouteId select p).FirstOrDefault(); ce.Detach(RouteList); return(RouteList); }
/// <summary> /// GetDesignationListByID is providing List of DesignationList By ID /// </summary> /// <returns></returns> /// public mDesignation GetDesignationListByID(int designationId, string[] conn) { BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); mDesignation DesignationID = new mDesignation(); DesignationID = (from p in ce.mDesignations where p.ID == designationId select p).FirstOrDefault(); ce.Detach(DesignationID); return(DesignationID); }
/// <summary> /// GetApprovalRecordByID is providing List of Approval By ID for Edit mode /// </summary> /// <returns></returns> /// public mApprovalLevel GetApprovalRecordByID(int approvalId, string[] conn) { BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); mApprovalLevel ApprovalID = new mApprovalLevel(); ApprovalID = (from p in ce.mApprovalLevels where p.ID == approvalId select p).FirstOrDefault(); ce.Detach(ApprovalID); return(ApprovalID); }
/// <summary> /// GetDesignationListByID is providing List of DesignationList By ID /// </summary> /// <returns></returns> /// public long GetDesignationIDByName(string designation, string[] conn) { BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); mDesignation DesignationID = new mDesignation(); DesignationID = (from p in ce.mDesignations where p.Name == designation select p).FirstOrDefault(); ce.Detach(DesignationID); return(DesignationID.ID); }
/// <summary> /// GetDiscountListByID is providing List of DiscountList By ID for Edit mode /// </summary> /// <returns></returns> /// public tDiscountHead GetDiscountListByID(int discountId, string[] conn) { BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); tDiscountHead ActivityID = new tDiscountHead(); ActivityID = (from p in db.tDiscountHeads where p.ID == discountId select p).FirstOrDefault(); db.Detach(ActivityID); return(ActivityID); }
/// <summary> /// GetDiscountListByID is providing List of DiscountList By ID for Edit mode /// </summary> /// <returns></returns> /// public tTargetPlan GetTargetListByID(int targetId, string[] conn) { BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); tTargetPlan TargetID = new tTargetPlan(); TargetID = (from p in db.tTargetPlans where p.ID == targetId select p).FirstOrDefault(); db.Detach(TargetID); return(TargetID); }