public List <vGWCGetUserProfileList> GetGWCUserList(string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <vGWCGetUserProfileList> userProfileList = new List <vGWCGetUserProfileList>();
userProfileList = (from c in ce.vGWCGetUserProfileLists
orderby c.userID descending
select c).ToList();
return(userProfileList);
}
public List <V_WMS_GetHeadCycleCount> GetCycleCountMain(string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <V_WMS_GetHeadCycleCount> count = new List <V_WMS_GetHeadCycleCount>();
count = (from cm in ce.V_WMS_GetHeadCycleCount
orderby cm.ID descending
select cm).ToList();
return(count);
}
public List <VGetRollNameByDeptID> GetRoleMasterListByDepartmentID(long DepartmentID, long DesignationID, string[] conn)
{
BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <VGetRollNameByDeptID> lst = new List <VGetRollNameByDeptID>();
lst = (from data in db.VGetRollNameByDeptIDs
where data.TerritoryID == DepartmentID
select data).ToList();
return(lst);
}
/// <summary>
/// GetGroupListToBindDDL is providing List of Group for bind DDLGroup
/// </summary>
/// <returns></returns>
///
public List <mTermsConditionsGroup> GetGroupListToBindDDL(string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <mTermsConditionsGroup> Group = new List <mTermsConditionsGroup>();
Group = (from p in ce.mTermsConditionsGroups
orderby p.Sequence
select p).ToList();
return(Group);
}
//BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities();
#region GetTermConditionList
/// <summary>
/// GetTermConditionList is providing List of TermCondition
/// </summary>
/// <returns></returns>
///
public List <mTermsCondition> GetTermConditionList(string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <mTermsCondition> Designation = new List <mTermsCondition>();
Designation = (from p in ce.mTermsConditions
orderby p.Sequence
select p).ToList();
return(Designation);
}
protected string EmailGetEmailIDsByUserID(long UserID, string[] conn)
{
string result;
BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
mUserProfileHead user = new mUserProfileHead();
user = db.mUserProfileHeads.Where(u => u.ID == UserID).FirstOrDefault();
result = user.EmailID;
return(result);
}
public List <SP_GetProductListForInventory_Result> FillInventoryProductDetailByInventoryID(string paraSessionID, long paraInventoryID, string paraUserID, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <SP_GetProductListForInventory_Result> lst = new List <SP_GetProductListForInventory_Result>();
lst = (from db in ce.SP_GetProductListForInventory(paraInventoryID, paraUserID)
select db).ToList();
SaveTempData(lst, paraSessionID, paraUserID, conn);
return(lst);
}
public string GetAutoCancellationStatus(long DeptID, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
string result = "";
var output = (from p in ce.mTerritories
where p.ID == DeptID
select new { p.AutoCancel }).FirstOrDefault();
return(result = output.ToString());
}
/// <summary>
/// GetProductCategoryList is providing List of ProductCategory
/// </summary>
/// <returns></returns>
///
public List <vGetProductCagetoryList> GetProductCategoryList(string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <vGetProductCagetoryList> ProductCategory = new List <vGetProductCagetoryList>();
ProductCategory = (from p in ce.vGetProductCagetoryLists
orderby p.Sequence
select p).ToList();
return(ProductCategory);
}
public List <mDropdownValue> GetActivityList(string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <mDropdownValue> ActivityList = new List <mDropdownValue>();
ActivityList = (from c in ce.mDropdownValues
where c.Parameter == "Event"
select c).ToList();
return(ActivityList);
}
public List <mDropdownValue> GetMessageList(string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <mDropdownValue> MessageList = new List <mDropdownValue>();
MessageList = (from c in ce.mDropdownValues
where c.Parameter == "Message Type"
select c).ToList();
return(MessageList);
}
public List <vGWCGetUserList> GWCSearchUserList(long ComanyID, long DeptID, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <vGWCGetUserList> userProfileList = new List <vGWCGetUserList>();
userProfileList = (from c in ce.vGWCGetUserLists
where c.CompanyID == ComanyID && c.DepartmentID == DeptID
select c).ToList();
return(userProfileList);
}
public List <mDropdownValue> GetUserType(string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <mDropdownValue> UserTypeList = new List <mDropdownValue>();
UserTypeList = (from U in ce.mDropdownValues
where U.Parameter == "User"
select U).ToList();
return(UserTypeList);
}
public List <mCompany> GetCompanyName(string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <mCompany> companylist = new List <mCompany>();
companylist = (from cl in ce.mCompanies
orderby cl.Name
select cl).ToList();
return(companylist);
}
public List <mTitle> GetActiveTitleRecords(string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <mTitle> TitleList = new List <mTitle>();
TitleList = (from p in ce.mTitles
where p.Active == "Y"
select p).ToList();
return(TitleList);
}
public List <mDropdownValue> GetDestination(string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <mDropdownValue> Destinationlist = new List <mDropdownValue>();
Destinationlist = (from cl in ce.mDropdownValues
where cl.Parameter == "Destination"
select cl).ToList();
return(Destinationlist);
}
public List <mTitle> GetTitleList(string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <mTitle> TitleList = new List <mTitle>();
TitleList = (from p in ce.mTitles
select p).ToList();
return(TitleList);
}
public List <mDropdownValue> GetActionType(string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <mDropdownValue> Actiontype = new List <mDropdownValue>();
Actiontype = (from cl in ce.mDropdownValues
where cl.Parameter == "ActionType"
select cl).ToList();
return(Actiontype);
}
//<summary>
//GetDocumentList is providing List of Product
//</summary>
//<returns></returns>
public List <vGetInventoryVendorDetail> GetInvertoy_VendorList(string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <vGetInventoryVendorDetail> listOfInventoryVendor = new List <vGetInventoryVendorDetail>();
listOfInventoryVendor = (from C in ce.vGetInventoryVendorDetails
select C).ToList();
return(listOfInventoryVendor);
}
public List <mDropdownValue> GetObject(string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <mDropdownValue> objectlst = new List <mDropdownValue>();
objectlst = (from cl in ce.mDropdownValues
where cl.Parameter == "Table"
select cl).ToList();
return(objectlst);
}
public List <mPrefixMaster> GetPrefixList(string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <mPrefixMaster> ObjName = new List <mPrefixMaster>();
ObjName = (from p in ce.mPrefixMasters
orderby p.PreObjectName
select p).ToList();
return(ObjName);
}
public List <mInterfaceMap> FieldList(string TableName, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <mInterfaceMap> FieldList = new List <mInterfaceMap>();
FieldList = (from cl in ce.mInterfaceMaps
where cl.TableName == TableName
select cl).ToList();
return(FieldList);
}
public List <mDropdownValue> GetGroupListToBindDDLDropdown(string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <mDropdownValue> Group = new List <mDropdownValue>();
Group = (from p in ce.mDropdownValues
where p.Parameter == "Term"
select p).ToList();
return(Group);
}
public List <POR_SP_GetPartDetails_OfConsumption_Result> GetConsumptionPartDetailByConsumptionID(long ConsumptionID, long siteID, string sessionID, string userID, string CurrentObject, string[] conn)
{
BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <POR_SP_GetPartDetails_OfConsumption_Result> PartDetail = new List <POR_SP_GetPartDetails_OfConsumption_Result>();
PartDetail = (from sp in db.POR_SP_GetPartDetails_OfConsumption(0, ConsumptionID, siteID, "0", "0", 0)
select sp).ToList();
SaveTempDataToDB(PartDetail, sessionID, userID, CurrentObject, conn);
return(PartDetail);
}
public tCycleCountHead GetCyleCountHeadByID(long CycleHeadID, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
tCycleCountHead HeadCycle = new tCycleCountHead();
HeadCycle = (from p in ce.tCycleCountHeads
where p.ID == CycleHeadID
select p).FirstOrDefault();
return(HeadCycle);
}
/// <summary>
/// GetDesignationList is providing List of Designation
/// </summary>
/// <returns></returns>
///
public List <mStatutory> GetStatutoryList(string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <mStatutory> Statutory = new List <mStatutory>();
Statutory = (from p in ce.mStatutories
orderby p.Sequence
select p).ToList();
return(Statutory);
}
public List <vGetRoleMasterData> BindRoleMasterSummary(string[] conn)
{
BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <vGetRoleMasterData> lst = new List <vGetRoleMasterData>();
lst = (from data in db.vGetRoleMasterDatas
orderby data.DeptSequence, data.DesigSequence, data.mrSequence
select data).ToList();
return(lst);
}
public mTitle GetTitleByTitleID(long TitleId, string[] conn)
{
BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
mTitle TitleResult = new mTitle();
TitleResult = (from p in db.mTitles
where p.ID == TitleId
select p).FirstOrDefault();
return(TitleResult);
}
/// <summary>
/// GetDataToBindRoleMasterDetailsByRoleID
/// </summary>
/// <param name="RoleID"></param>
/// <param name="CompanyID"></param>
/// <returns></returns>
public List <SP_GetDataToBindRoleMaster_Result> GetDataToBindRoleMasterDetailsByRoleID(long RoleID, long CompanyID, string[] conn)
{
BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <SP_GetDataToBindRoleMaster_Result> lst = new List <SP_GetDataToBindRoleMaster_Result>();
lst = (from dbtable in db.SP_GetDataToBindRoleMaster(RoleID, CompanyID)
orderby(long)(dbtable.mSequence), (long)(dbtable.pSequence), (long)(dbtable.oSequence)
select dbtable).ToList();
return(lst);
}
public List <SP_GWCGetUserRoleDetail_Result> GetRoleDetails(long RoleID, long UserIdForRole, long CompanyID, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
List <SP_GWCGetUserRoleDetail_Result> lst = new List <SP_GWCGetUserRoleDetail_Result>();
lst = (from dbtable in ce.SP_GWCGetUserRoleDetail(RoleID, UserIdForRole, CompanyID)
orderby(long)(dbtable.mSequence), (long)(dbtable.pSequence), (long)(dbtable.oSequence)
select dbtable).ToList();
return(lst);
}
