/* Reference from GetCompanyFaceValueDetails Method in CompaniesSL.cs*/
/// <summary>
/// This method is used for the get NSEGroup Details
/// </summary>
/// <param name="i_sConnectionString">DB Connection string</param>
/// <param name="i_nGroupID">NSEGroup ID</param>
/// <returns>Object NSEGroup DTO</returns>
public NSEGroupDTO Get_NSEGroup_Details(string i_sConnectionString, int i_nGroupId)
{
NSEGroupDTO objNSEGroupDTO = new NSEGroupDTO();
try
{
using (var objNSEGroupDAL = new NSEGroupDAL())
{
objNSEGroupDTO = objNSEGroupDAL.GetSingleGroupDetails(i_sConnectionString, i_nGroupId);
}
}
catch (Exception exp)
{
throw exp;
}
return(objNSEGroupDTO);
}
/* Reference from GetCompanyFaceValueDetails Method in CompaniesSL.cs*/
/// <summary>
/// This method is used for the get NSEGroup Id
/// </summary>
/// <param name="i_sConnectionString">DB Connection string</param>
/// <param name="i_nGroupID">NSEGroup ID</param>
/// <returns>Object NSEGroupDetailsDTO</returns>
public List <NSEGroupDetailsDTO> GetgroupId(string i_sConnectionString, int GroupId, int TransId)
{
List <NSEGroupDetailsDTO> lstGroupId = new List <NSEGroupDetailsDTO>();
try
{
using (var objNSEGrpDateDAL = new NSEGroupDAL())
{
lstGroupId = objNSEGrpDateDAL.GetgroupId(i_sConnectionString, GroupId, TransId).ToList <NSEGroupDetailsDTO>();
}
}
catch (Exception exp)
{
throw exp;
}
return(lstGroupId);
}
/* Reference from GetCompanyFaceValueDetails Method in CompaniesSL.cs*/
/// <summary>
/// This method is used for the get NSEGroup Details
/// </summary>
/// <param name="i_sConnectionString">DB Connection string</param>
/// <param name="i_nGroupID">NSEGroup ID</param>
/// <returns>Object NSEGroup DTO</returns>
public List <NSEGroupDetailsDTO> Get_Group_TransactionId(string i_sConnectionString, int GroupId)
{
List <NSEGroupDetailsDTO> lstGroupTransIdList = new List <NSEGroupDetailsDTO>();
try
{
using (var objNSEGroupDocDAL = new NSEGroupDAL())
{
lstGroupTransIdList = objNSEGroupDocDAL.GetGroupwiseTransactionId(i_sConnectionString, GroupId).ToList <NSEGroupDetailsDTO>();
}
}
catch (Exception exp)
{
throw exp;
}
return(lstGroupTransIdList);
}
/* Reference from GetCompanyFaceValueDetails Method in CompaniesSL.cs*/
/// <summary>
/// This method is used for the get NSEGroup Details
/// </summary>
/// <param name="i_sConnectionString">DB Connection string</param>
/// <param name="i_nGroupID">NSEGroup ID</param>
/// <returns>Object NSEGroup DTO</returns>
public List <NSEGroupDTO> Get_Group_Date(string i_sConnectionString, int GroupId)
{
List <NSEGroupDTO> lstGroupDate = new List <NSEGroupDTO>();
try
{
using (var objNSEGrpDateDAL = new NSEGroupDAL())
{
lstGroupDate = objNSEGrpDateDAL.GetgroupDate(i_sConnectionString, GroupId).ToList <NSEGroupDTO>();
}
}
catch (Exception exp)
{
throw exp;
}
return(lstGroupDate);
}
/* Reference from SaveDetails Method in CompaniesSL.cs*/
/// <summary>
/// This method is used for the saving Group details.
/// <param name="sConnectionString">DB Connection String</param>
/// <param name="m_objNSEGroupDTO">NSEGroupDTO objects</param>
/// <returns>if save then return true else return false</returns>
public bool Save_New_NSEDocument(string i_sConnectionString, NSEGroupDocumentMappingDTO m_objGroupDocumentDTO, string GUID)
{
bool bReturn = false;
try
{
using (var objGroupDocumentDAL = new NSEGroupDAL())
{
bReturn = objGroupDocumentDAL.SaveNSEDocument(i_sConnectionString, m_objGroupDocumentDTO, GUID);
}
}
catch (Exception exp)
{
throw exp;
}
return(bReturn);
}
/* Reference from SaveDetails Method in CompaniesSL.cs*/
/// <summary>
/// This method is used for the saving Group details.
/// <param name="sConnectionString">DB Connection String</param>
/// <param name="m_objNSEGroupDetailsDTO">NSEGroupDetailsDTO objects</param>
/// <returns>if save then return true else return false</returns>
public List <NSEGroupDetailsDTO> Save_NSEGroup_Details(string i_sConnectionString, NSEGroupDetailsDTO m_objNSEGroupDetailsDTO)
{
List <NSEGroupDetailsDTO> lstGroupDetails = new List <NSEGroupDetailsDTO>();
try
{
using (var objNSEGroupDAL = new NSEGroupDAL())
{
lstGroupDetails = objNSEGroupDAL.SaveGroupDetails(i_sConnectionString, m_objNSEGroupDetailsDTO).ToList <NSEGroupDetailsDTO>();
}
}
catch (Exception exp)
{
throw exp;
}
return(lstGroupDetails);
}
/* Reference from Delete Method in CompaniesSL.cs*/
/// <summary>
/// This method is used for the delete User From NSEGroup
/// </summary>
/// <param name="sConnectionString">DB COnnection string</param>
/// <param name="m_objNSEGroupDTO">NSEGroupDTO objects</param>
/// <param name="i_nGroupID">NSEGroup ID</param>
/// <param name="i_nUserInfoId">User ID</param>
/// <returns>if delete return true else false</returns>
public bool Delete_User_From_NSEGroup(string i_sConnectionString, NSEGroupDetailsDTO m_objNSEGroupDTO)
{
bool bReturn = false;
try
{
using (var objNSEGroupDAL = new NSEGroupDAL())
{
bReturn = objNSEGroupDAL.Delete(i_sConnectionString, m_objNSEGroupDTO);
}
}
catch (Exception exp)
{
throw exp;
}
return(bReturn);
}
/* Reference from SaveDetails Method in CompaniesSL.cs*/
/// <summary>
/// This method is used for the saving Group details.
/// <param name="sConnectionString">DB Connection String</param>
/// <param name="m_objNSEGroupDTO">NSEGroupDTO objects</param>
/// <returns>if save then return true else return false</returns>
//public bool Save_New_NSEGroup(string i_sConnectionString, NSEGroupDTO m_objNSEGroupDTO)
public List <NSEGroupDTO> Save_New_NSEGroup(string i_sConnectionString, NSEGroupDTO m_objNSEGroupDTO)
{
bool bReturn = false;
List <NSEGroupDTO> lstGroup = new List <NSEGroupDTO>();
try
{
using (var objNSEGroupDAL = new NSEGroupDAL())
{
lstGroup = objNSEGroupDAL.SaveGroup(i_sConnectionString, m_objNSEGroupDTO).ToList <NSEGroupDTO>();
}
}
catch (Exception exp)
{
throw exp;
}
return(lstGroup);
}
/* Reference from GetCompanyFaceValueDetails Method in CompaniesSL.cs*/
/// <summary>
/// This method is used for the get NSEGroup Details
/// </summary>
/// <param name="i_sConnectionString">DB Connection string</param>
/// <param name="i_nGroupID">NSEGroup ID</param>
/// <returns>Object NSEGroup DTO</returns>
public List <NSEGroupDocumentMappingDTO> Get_Singledocument_Details(string i_sConnectionString, int TransactionId)
{
List <NSEGroupDocumentMappingDTO> lstSingleDocumentList = new List <NSEGroupDocumentMappingDTO>();
//InsiderTradingDAL.CompanyDAL objCompanyDAL = new InsiderTradingDAL.CompanyDAL();
try
{
using (var objNSEGroupDocDAL = new NSEGroupDAL())
{
lstSingleDocumentList = objNSEGroupDocDAL.GetSingleNSEDocumentDetails(i_sConnectionString, TransactionId).ToList <NSEGroupDocumentMappingDTO>();
}
}
catch (Exception exp)
{
throw exp;
}
return(lstSingleDocumentList);
}
/* Reference from GetCompanyFaceValueDetails Method in CompaniesSL.cs*/
/// <summary>
/// This method is used for the get NSEGroup Details
/// </summary>
/// <param name="i_sConnectionString">DB Connection string</param>
/// <param name="i_nGroupID">NSEGroup ID</param>
/// <returns>Object NSEGroup DTO</returns>
public List <NSEGroupDocumentMappingDTO> Get_All_NSEGroupDocument(string i_sConnectionString, int GroupId, int UserInfoIdCheck)
{
List <NSEGroupDocumentMappingDTO> lstGroupDocumentList = new List <NSEGroupDocumentMappingDTO>();
//InsiderTradingDAL.CompanyDAL objCompanyDAL = new InsiderTradingDAL.CompanyDAL();
try
{
using (var objNSEGroupDocDAL = new NSEGroupDAL())
{
lstGroupDocumentList = objNSEGroupDocDAL.GetNSEDocumentDetails(i_sConnectionString, GroupId, UserInfoIdCheck).ToList <NSEGroupDocumentMappingDTO>();
}
}
catch (Exception exp)
{
throw exp;
}
return(lstGroupDocumentList);
}
/* Reference from GetPeriodEndPerformedUserInfoList Method in UserInfoSL.cs*/
/// <summary>
/// This method is used for fetching the list NSEGroup
/// </summary>
/// <param name="i_sConnectionString">Connection string for which database</param>
/// <returns>NSEGroup Information List</returns>
public IEnumerable <NSEGroupDTO> Get_All_NSEGroup(string i_sConnectionString)
{
IEnumerable <NSEGroupDTO> NSEGroupInfoList = new List <NSEGroupDTO>();
try
{
using (var objNSEGroupDAL = new NSEGroupDAL())
{
NSEGroupInfoList = objNSEGroupDAL.getGroupsDetails(i_sConnectionString);
}
}
catch (Exception exp)
{
throw exp;
}
return(NSEGroupInfoList);
}
/* Reference from UpdateStatus Method in CODashboardSL.cs*/
/// <summary>
/// This function will be for updating NSEGroup
/// </summary>
/// <param name="i_sConnectionString"></param>
/// <param name="i_nGroupID">NSEGroup ID</param>
/// <returns></returns>
public bool Update_NSEGroup(string i_sConnectionString, NSEGroupDTO m_objNSEGroupDTO)
{
bool bReturnValue = false;
try
{
//CODashboardDAL objCODashboardDAL = new CODashboardDAL();
using (var objNSEGroupDAL = new NSEGroupDAL())
{
bReturnValue = objNSEGroupDAL.UpdateGroup(i_sConnectionString, m_objNSEGroupDTO);
}
}
catch (Exception exp)
{
throw exp;
}
return(bReturnValue);
}
