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