public JsonResponse Summary()
{ //Used for Menu Listing
//Stored Procedure Used for listing Admin_GetMenu
try
{
DataSet data = new DataSet();
data = new ADODataFunction().ExecuteDataset(Constants.Procedures.GetRoleList, null, CommandType.StoredProcedure);
resp = data.Tables[0].AsEnumerable().Select(a => new JsonResponse
{
Status = a.Field <string>("STATUS"),
Message = a.Field <string>("MESSAGE")
}).FirstOrDefault();
resp.Data = data.Tables[1].AsEnumerable().Select(a => new Role
{
RoleID = a.Field <int>("RoleID"),
Name = a.Field <string>("RoleName"),
NormalizedName = a.Field <string>("RoleDescription"),
ParentRoleName = a.Field <string>("ParentRoleName"),
ApplicationName = a.Field <string>("ApplicationName"),
LastUpdatedDate = a.Field <string>("LastUpdatedDate"),
IsActiveText = a.Field <string>("Status")
}).ToList();
}
catch
{
resp.Message = Constants.Service.Common_message;
}
return(resp);
}
public IEnumerable <State> ListAll()
{
//Used for unique State Master Listing
//Stored Procedure Used SP_GetState
DataSet data = new DataSet();
IEnumerable <State> StateList;
try
{
data = new ADODataFunction().ExecuteDataset(Constants.Procedures.GetStateList, null, CommandType.StoredProcedure);
StateList = data.Tables[1].AsEnumerable().Select(dataRow => new State
{
Id = dataRow.Field <long>("Id"),
StateName = dataRow.Field <string>("StateName"),
StateCode = dataRow.Field <string>("StateCode"),
GSTStateCode = dataRow.Field <int>("GSTStateCode"),
CountryId = dataRow.Field <long>("CountryId"),
CountryName = dataRow.Field <string>("CountryName"),
IsUnionTerritory = dataRow.Field <bool>("IsUnionTerritory"),
IsActiveText = dataRow.Field <string>("Status"),
LastUpdatedDate = dataRow.Field <string>("LastUpdatedDate")
}).ToList();
return(StateList);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// Data Summary
/// </summary>
/// <returns>Jsonresponse</returns>
public JsonResponse Summary()
{
try
{
DataSet data = new DataSet();
data = new ADODataFunction().ExecuteDataset(Constants.Procedures.GetSchemePlan, null, CommandType.StoredProcedure);
resp = data.Tables[0].AsEnumerable().Select(a => new JsonResponse
{
Status = a.Field <string>("STATUS"),
Message = a.Field <string>("MESSAGE")
}).FirstOrDefault();
resp.Data = data.Tables[1].AsEnumerable().Select(a => new SchemePlan
{
ID = a.Field <long>("Id")
,
Name = a.Field <string>("Name")
,
IsActiveText = a.Field <string>("Status")
,
LastUpdatedDate = a.Field <string>("LastUpdatedDate")
}).ToList();
}
catch
{
resp.Message = Constants.Service.Common_message;
}
return(resp);
}
/// <summary>
/// Fill SchemeType
/// </summary>
/// <returns></returns>
public List <SelectListItem> GetSchemeTypeList()
{
List <SelectListItem> scheme = new List <SelectListItem>();
DataSet dataSet = new ADODataFunction().ExecuteDataset(Constants.Procedures.FillSchemesDropdown, null);
if (dataSet != null && dataSet.Tables.Count > 0)
{
DataTable schemeDataTable = dataSet.Tables[0];
if (schemeDataTable != null && schemeDataTable.Rows.Count > 0)
{
for (int i = 0; i < schemeDataTable.Rows.Count; i++)
{
scheme.Add(new SelectListItem()
{
Text = string.IsNullOrEmpty(schemeDataTable.Rows[i]["Name"].ToString()) ? "" : Convert.ToString(schemeDataTable.Rows[i]["Name"]),
Value = string.IsNullOrEmpty(schemeDataTable.Rows[i]["ID"].ToString()) ? "" : Convert.ToString(schemeDataTable.Rows[i]["ID"]),
});
}
}
else
{
scheme.DefaultIfEmpty();
}
}
return(scheme);
}
public IEnumerable <Depository> ListAll()
{
//Used for Diository Listing
//Stored Procedure Used for listing Admin_GetDepository
IEnumerable <Depository> DepositoryList;
try
{
DataSet data = new DataSet();
data = new ADODataFunction().ExecuteDataset(Constants.Procedures.GetDepositorySummary, null, CommandType.StoredProcedure);
DepositoryList = data.Tables[1].AsEnumerable().Select(a => new Depository
{
Id = a.Field <long>("Id"),
DPCode = a.Field <string>("DPCode"),
DPName = a.Field <string>("DPName"),
AddressLine1 = a.Field <string>("Address"),
StateName = a.Field <string>("State"),
CityName = a.Field <string>("City"),
CountryName = a.Field <string>("Country"),
Pincode = a.Field <long>("Pincode"),
LastUpdatedDate = a.Field <string>("LastUpdatedDate"),
IsActiveText = a.Field <string>("Status")
}).ToList();
}
catch
{
return(null);
}
return(DepositoryList);
}
public IEnumerable <City> ListAll()
{
//Used for Unique City Listing
//Stored procedure used SP_GetCity
DataSet data = new DataSet();
IEnumerable <City> CityList;
try
{
data = new ADODataFunction().ExecuteDataset(Constants.Procedures.GetCityList, null, CommandType.StoredProcedure);
CityList = data.Tables[1].AsEnumerable().Select(dataRow => new City
{
Id = dataRow.Field <long>("Id"),
CityName = dataRow.Field <string>("CityName"),
CityTier = dataRow.Field <string>("CityTier"),
StateId = dataRow.Field <long>("StateId"),
StateName = dataRow.Field <string>("StateName"),
CountryId = dataRow.Field <long>("CountryId"),
CountryName = dataRow.Field <string>("CountryName"),
IsActiveText = dataRow.Field <string>("Status"),
LastUpdatedDate = dataRow.Field <string>("LastUpdatedDate")
}).ToList();
return(CityList);
}
catch (Exception ex)
{
// StackTrace CallStack = new StackTrace(ex, true);
// ex.Data["ErrDescription"] = ex.Data["ErrDescription"] != null ? ex.Data["ErrDescription"] : string.Format("Error captured in {0} on Line No {1} of Method {2}", CallStack.GetFrame(0).GetFileName(), CallStack.GetFrame(0).GetFileLineNumber(), CallStack.GetFrame(0).GetMethod().ToString());
// throw ex;
return(null);
}
}
//Get Relationship Data for Listing
public JsonResponse Summary()
{
try
{
DataSet data = new DataSet();
data = new ADODataFunction().ExecuteDataset(Constants.Procedures.GetRelationShipData, null, CommandType.StoredProcedure);
resp = data.Tables[0].AsEnumerable().Select(a => new JsonResponse
{
Status = a.Field <string>("STATUS"),
Message = a.Field <string>("MESSAGE")
}).FirstOrDefault();
resp.Data = data.Tables[1].AsEnumerable().Select(a => new Relationship
{
ID = a.Field <int>("ID")
,
RelationshipName = a.Field <string>("Relationship")
,
IsActiveText = a.Field <string>("IsActive")
,
LastUpdatedDate = a.Field <string>("LastUpdatedDate")
}).ToList();
}
catch (Exception ex)
{
resp.Message = Constants.Service.Common_message;
}
return(resp);
}
public ClientDepositoryDetails GetDepositryDetailData(long ID)
{
try
{
DataSet data = new DataSet();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", ID);
data = new ADODataFunction().ExecuteDataset(Constants.Procedures.GetDepositoryDetailsByID, param, CommandType.StoredProcedure);
ClientDepositoryDetails datas = data.Tables[0].AsEnumerable().Select(a => new ClientDepositoryDetails
{
ID = a.Field <long>("ID")
,
ClientID = a.Field <long>("ClientID")
,
DpId = a.Field <long>("DpId")
,
EffectiveFrom = a.Field <string>("EffectiveFrom")
,
EffectiveTo = a.Field <string>("EffectiveTo")
,
AccountNumber = a.Field <string>("AccountNumber")
}).FirstOrDefault();
return(datas);
}
catch (Exception ex)
{
return(null);
}
}
//public JsonResponse AddUpdateAccountDetails(List<ClientAccountList> model)
//{
// try
// {
// if (model != null && model.Count > 0)
// {
// DataTable dt = ConvertToDataTable(model);
// SqlParameter[] param = new SqlParameter[3];
// param[0] = new SqlParameter("@TableParam", dt);
// param[1] = new SqlParameter("@ClientID", model[0].ClientID);
// param[2] = new SqlParameter("@UserID", GetUserID());
// int i = new ADODataFunction().ExecuteNonQuery(Constants.Procedures.AddUpdateClientsAccounts, param, CommandType.StoredProcedure);
// // If it return was not equal to 0 then it affect some rows means data inserted.
// if (i != 0)
// {
// resp.Status = Constants.ResponseStatus.Success;
// resp.Message = Constants.Service.Data_insert_success;
// }
// // Else Show the error message.
// else
// {
// resp.Status = Constants.ResponseStatus.Failed;
// resp.Message = Constants.Service.Data_insert_failed;
// }
// }
// else
// {
// resp.Message = Constants.Service.Data_insert_failed;
// }
// }
// catch (Exception ex)
// {
// resp.Message = Constants.Service.Common_message;
// }
// return resp;
//}
public int AddUpdateClientPersonalDetails(ClientPersonal model)
{
try
{
SqlParameter[] param = new SqlParameter[17];
param[0] = new SqlParameter("@ID", model.ID);
param[1] = new SqlParameter("@ClientID", model.ClientID);
param[2] = new SqlParameter("@MaritalStatusID", model.MaritalStatusID);
param[3] = new SqlParameter("@MotherFirstName", model.MotherFirstName);
param[4] = new SqlParameter("@MotherLastName", model.MotherLastName);
param[5] = new SqlParameter("@AnualIncomeID", model.AnnualIncomeID);
param[6] = new SqlParameter("@TradingExperienceID", model.TradingExperienceID);
param[7] = new SqlParameter("@CommodityTradeClassificationID", model.CommodityTradeClassificationID);
param[8] = new SqlParameter("@IsPoliticalExperienceID", model.IsPoliticalExperienceID);
param[9] = new SqlParameter("@CitizenshipID", model.CitizenshipID);
param[10] = new SqlParameter("@ResidentialStatusID", model.ResidentialStatusID);
param[11] = new SqlParameter("@EducationID", model.EducationID);
param[12] = new SqlParameter("@SpouseOrFatherFirstName", model.SpouseOrFatherFirstName);
param[13] = new SqlParameter("@SpouseOrFatherLastName", model.SpouseOrFatherLastName);
param[14] = new SqlParameter("@MaidenFirstName", model.MaidenFirstName);
param[15] = new SqlParameter("@MaidenLastName", model.MaidenLastName);
param[16] = new SqlParameter("@UserID", GetUserID());
//param[16] = new SqlParameter("@UserID", Convert.ToInt32(GetUserID("RoleID")));
int i = new ADODataFunction().ExecuteNonQuery(Constants.Procedures.AddUpdateClientPersonalDetails, param, CommandType.StoredProcedure);
return(i);
}
catch (Exception ex)
{
return(0);
}
}
public ClientBankDetails GetBankDetailsData(long ID)
{
try
{
DataSet data = new DataSet();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", ID);
data = new ADODataFunction().ExecuteDataset(Constants.Procedures.GetBankDetailsByID, param, CommandType.StoredProcedure);
ClientBankDetails datas = data.Tables[0].AsEnumerable().Select(a => new ClientBankDetails
{
ID = a.Field <long>("ID")
,
ClientID = a.Field <long>("ClientID")
,
AccountType = a.Field <int>("AccountType")
,
IFSCCode = a.Field <string>("IFSCCode")
,
BranchMICRCode = a.Field <int>("BranchMICRCode")
,
BankAccountNumber = a.Field <string>("BankAccountNumber")
}).FirstOrDefault();
return(datas);
}
catch (Exception ex)
{
return(null);
}
}
public ClientSecondaryContact GetSecondaryContactDetailData(long ID)
{
try
{
DataSet data = new DataSet();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", ID);
data = new ADODataFunction().ExecuteDataset(Constants.Procedures.GetSecondaryContactDetailsByID, param, CommandType.StoredProcedure);
ClientSecondaryContact datas = data.Tables[0].AsEnumerable().Select(a => new ClientSecondaryContact
{
ID = a.Field <long>("ID")
,
ClientID = a.Field <long>("ClientID")
,
Name = a.Field <string>("Name")
,
MobileNumber = a.Field <string>("MobileNumber")
,
EmailId = a.Field <string>("EmailId")
,
Relationship = a.Field <int>("Relationship")
,
EffectiveFrom = a.Field <string>("EffectiveFrom")
,
EffectiveTo = a.Field <string>("EffectiveTo")
}).FirstOrDefault();
return(datas);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// Data Summary
/// </summary>
/// <returns>Jsonresponse</returns>
public IEnumerable <ClientGroup> Summary()
{
DataSet data = new DataSet();
IEnumerable <ClientGroup> clientGroup;
try
{
data = new ADODataFunction().ExecuteDataset("dbo.Admin_GetClientGroupSummary", null, CommandType.StoredProcedure);
clientGroup = data.Tables[1].AsEnumerable().Select(dataRow => new ClientGroup
{
Id = dataRow.Field <long>("Id"),
GroupName = dataRow.Field <string>("GroupName"),
AddressLine1 = dataRow.Field <string>("AddressLine1"),
Countries = dataRow.Field <string>("CountryName"),
States = dataRow.Field <string>("StateName"),
Cities = dataRow.Field <string>("CityName"),
Pincode = dataRow.Field <long>("Pincode"),
IsActiveText = dataRow.Field <string>("IsActive"),
LastUpdatedDate = dataRow.Field <string>("LastUpdatedDate")
}).ToList();
return(clientGroup);
}
catch (Exception ex)
{
// StackTrace CallStack = new StackTrace(ex, true);
// ex.Data["ErrDescription"] = ex.Data["ErrDescription"] != null ? ex.Data["ErrDescription"] : string.Format("Error captured in {0} on Line No {1} of Method {2}", CallStack.GetFrame(0).GetFileName(), CallStack.GetFrame(0).GetFileLineNumber(), CallStack.GetFrame(0).GetMethod().ToString());
throw ex;
}
}
/// <summary>
/// Fill Rta Dropdown
/// </summary>
/// <returns></returns>
public List <SelectListItem> FillRTAs()
{
List <SelectListItem> rta = new List <SelectListItem>();
DataSet dataSet = new ADODataFunction().ExecuteDataset("Admin_GetFilterForBulkUpload", null);
if (dataSet != null && dataSet.Tables.Count > 0)
{
DataTable rtaDataTable = dataSet.Tables[0];
if (rtaDataTable != null && rtaDataTable.Rows.Count > 0)
{
for (int i = 0; i < rtaDataTable.Rows.Count; i++)
{
rta.Add(new SelectListItem()
{
Text = string.IsNullOrEmpty(rtaDataTable.Rows[i]["Name"].ToString()) ? "" : Convert.ToString(rtaDataTable.Rows[i]["Name"]),
Value = string.IsNullOrEmpty(rtaDataTable.Rows[i]["ID"].ToString()) ? "" : Convert.ToString(rtaDataTable.Rows[i]["ID"]),
});
}
}
else
{
rta.DefaultIfEmpty();
}
}
return(rta);
}
public IEnumerable <Role> ListAll()
{
//Used for Menu Listing
//Stored Procedure Used for listing Admin_GetMenu
DataSet data = new DataSet();
IEnumerable <Role> RoleList;
try
{
data = new ADODataFunction().ExecuteDataset(Constants.Procedures.GetRoleList, null, CommandType.StoredProcedure);
RoleList = data.Tables[1].AsEnumerable().Select(a => new Role
{
RoleID = a.Field <int>("RoleID"),
Name = a.Field <string>("RoleName"),
NormalizedName = a.Field <string>("RoleDescription"),
ParentRoleName = a.Field <string>("ParentRoleName"),
ApplicationName = a.Field <string>("ApplicationName"),
LastUpdatedDate = a.Field <string>("LastUpdatedDate"),
IsActiveText = a.Field <string>("Status")
}).ToList();
}
catch
{
return(null);
}
return(RoleList);
}
public List <ClientAccountsMapping> GetClientAccountsData(long ClientID)
{
try
{
DataSet data = new DataSet();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ClientID", ClientID);
data = new ADODataFunction().ExecuteDataset(Constants.Procedures.GetClientAccountsByID, param, CommandType.StoredProcedure);
List <ClientAccountsMapping> datas = data.Tables[0].AsEnumerable().Select(a => new ClientAccountsMapping
{
ID = a.Field <long>("ID")
,
ClientID = a.Field <long>("L3_ClientID")
,
AccountTypeID = a.Field <int>("L4_AccountTypeID")
,
UCC = a.Field <string>("UCC")
}).ToList();
return(datas);
}
catch (Exception ex)
{
return(null);
}
}
public int AddUpdateClientAddresses(ClientAddresses model)
{
try
{
int i = 0;
SqlParameter[] param = new SqlParameter[16];
param[0] = new SqlParameter("@CurrentID", model.Current_ID);
param[1] = new SqlParameter("@ClientID", model.ClientID);
param[2] = new SqlParameter("@CurrentAddressLine1", model.Current_AddressLine1);
param[3] = new SqlParameter("@CurrentAddressLine2", model.Current_AddressLine2);
param[4] = new SqlParameter("@CurrentCountryID", model.Current_CountryID);
param[5] = new SqlParameter("@CurrentStateID", model.Current_StateID);
param[6] = new SqlParameter("@CurrentCityID", model.Current_CityID);
param[7] = new SqlParameter("@CurrentPinCode", model.Current_PinCode);
param[8] = new SqlParameter("@CoresspondingID", model.Coressponding_ID);
param[9] = new SqlParameter("@CoresspondingAddressLine1", model.Coressponding_AddressLine1);
param[10] = new SqlParameter("@CoresspondingAddressLine2", model.Coressponding_AddressLine2);
param[11] = new SqlParameter("@CoresspondingCountryID", model.Coressponding_CountryID);
param[12] = new SqlParameter("@CoresspondingStateID", model.Coressponding_StateID);
param[13] = new SqlParameter("@CoresspondingCityID", model.Coressponding_CityID);
param[14] = new SqlParameter("@CoresspondingPinCode", model.Coressponding_PinCode);
param[15] = new SqlParameter("@UserID", GetUserID());
//param[15] = new SqlParameter("@UserID", Convert.ToInt32(GetUserID("RoleID")));
i = new ADODataFunction().ExecuteNonQuery(Constants.Procedures.AddUpdateClientAddresses, param, CommandType.StoredProcedure);
return(i);
}
catch (Exception ex)
{
return(0);
}
}
//Get HoldingNature Data for Listing
public JsonResponse Summary()
{
try
{
DataSet data = new DataSet();
data = new ADODataFunction().ExecuteDataset("Admin_GetHoldingNatureMasterData", null, CommandType.StoredProcedure);
resp = data.Tables[0].AsEnumerable().Select(a => new JsonResponse
{
Status = a.Field <string>("STATUS"),
Message = a.Field <string>("MESSAGE")
}).FirstOrDefault();
resp.Data = data.Tables[1].AsEnumerable().Select(a => new HoldingNature
{
ID = a.Field <long>("ID")
, HNCode = a.Field <string>("HNCode")
, HoldingType = a.Field <string>("HoldingType")
, IsActiveText = a.Field <string>("IsActive")
, LastUpdatedDate = a.Field <string>("LastUpdatedDate")
}).ToList();
}
catch (Exception ex)
{
resp.Message = Constants.Service.Common_message;
}
return(resp);
}
public int AddUpdateClientMappingDetails(ClientMapping model)
{
try
{
SqlParameter[] param = new SqlParameter[13];
param[0] = new SqlParameter("@ID", model.ID);
param[1] = new SqlParameter("@ClientID", model.ClientID);
param[2] = new SqlParameter("@SBUID", model.SBUID);
param[3] = new SqlParameter("@RMId", model.RMId);
param[4] = new SqlParameter("@SecondaryRMId", model.SecondaryRMId);
param[5] = new SqlParameter("@BranchId", model.BranchId);
param[6] = new SqlParameter("@ModelId", model.ModelId);
param[7] = new SqlParameter("@HeadOfFamily", model.HeadOfFamily);
param[8] = new SqlParameter("@KYCValid", model.KYCValid);
param[9] = new SqlParameter("@KYCFormNo", model.KYCFormNo);
param[10] = new SqlParameter("@EffectiveFrom", model.EffectiveFrom);
param[11] = new SqlParameter("@EffectiveTo", model.EffectiveTo);
param[12] = new SqlParameter("@UserID", GetUserID());
//param[12] = new SqlParameter("@UserID", Convert.ToInt32(GetUserID("RoleID")));
int i = new ADODataFunction().ExecuteNonQuery(Constants.Procedures.AddUpdateClientMappingDetails, param, CommandType.StoredProcedure);
return(i);
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// Data Summary
/// </summary>
/// <returns>Jsonresponse</returns>
public JsonResponse Summary()
{
try
{
DataSet data = new DataSet();
data = new ADODataFunction().ExecuteDataset(Constants.Procedures.GetEquityBrokerSummary, null, CommandType.StoredProcedure);
resp = data.Tables[0].AsEnumerable().Select(a => new JsonResponse
{
Status = a.Field <string>("STATUS"),
Message = a.Field <string>("MESSAGE")
}).FirstOrDefault();
resp.Data = data.Tables[1].AsEnumerable().Select(a => new EquityBrokers
{
ID = a.Field <long>("Id")
,
Name = a.Field <string>("BrokerName")
,
BSEMembercode = a.Field <string>("BSEMemberCode")
,
NSEMembercode = a.Field <string>("NSEMemberCode")
,
MCXMembercode = a.Field <string>("MCXMemberCode")
,
IsActiveText = a.Field <string>("IsActive")
,
LastUpdatedDate = a.Field <string>("LastUpdatedDate")
}).ToList();
}
catch (Exception ex)
{
resp.Message = Constants.Service.Common_message;
}
return(resp);
}
public IEnumerable <Country> ListAll()
{
// Used for getting Country list
// Sp used is SP_GetCountry
DataSet data = new DataSet();
IEnumerable <Country> CountryList;
try
{ data = new ADODataFunction().ExecuteDataset(Constants.Procedures.GetCountryList, null, CommandType.StoredProcedure);
CountryList = data.Tables[1].AsEnumerable().Select(dataRow => new Country
{
Id = dataRow.Field <long>("Id"),
CountryName = dataRow.Field <string>("CountryName"),
Currency = dataRow.Field <string>("Currency"),
CurrencySymbolUnicode = dataRow.Field <string>("CurrencySymbolUnicode"),
TimeZoneName = dataRow.Field <string>("TimeZone"),
IsActiveText = dataRow.Field <string>("Status"),
LastUpdatedDate = dataRow.Field <string>("LastUpdatedDate")
}).ToList();
return(CountryList); }
catch (Exception ex)
{
return(null);
}
}
//Get Minimum Holding Period Years
public List <SelectListItem> GetMinimumHoldingPeriodYearsList()
{
List <SelectListItem> list = new List <SelectListItem>();
DataSet dataSet = new ADODataFunction().ExecuteDataset(Constants.Procedures.FillSchemesDropdown, null);
if (dataSet != null && dataSet.Tables.Count > 0)
{
DataTable dataTable = dataSet.Tables[7];
if (dataTable != null && dataTable.Rows.Count > 0)
{
for (int i = 0; i < dataTable.Rows.Count; i++)
{
list.Add(new SelectListItem()
{
Text = string.IsNullOrEmpty(dataTable.Rows[i]["Name"].ToString()) ? "" : Convert.ToString(dataTable.Rows[i]["Name"]),
Value = string.IsNullOrEmpty(dataTable.Rows[i]["ID"].ToString()) ? "" : Convert.ToString(dataTable.Rows[i]["ID"]),
});
}
}
else
{
list.DefaultIfEmpty();
}
}
return(list);
}
public JsonResponse Summary()
{
JsonResponse resp = new JsonResponse();
try
{
DataSet data = new DataSet();
data = new ADODataFunction().ExecuteDataset(Constants.Procedures.GetClientAccountSumary, null, CommandType.StoredProcedure);
resp.Data = data.Tables[0].AsEnumerable().Select(a => new JsonResponse
{
Status = a.Field <string>("STATUS"),
Message = a.Field <string>("MESSAGE")
}).FirstOrDefault();
resp.Data = data.Tables[1].AsEnumerable().Select(a => new ClientAccountsMapping
{
Client = a.Field <string>("Client"),
PrimaryRM = a.Field <string>("PrimaryRM"),
Accounts = a.Field <string>("AccountTypeName"),
UCC = a.Field <string>("UCC"),
LastUpdatedDate = a.Field <string>("LastUpdatedDate"),
IsActiveText = a.Field <string>("IsActive"),
ID = a.Field <long>("ID"),
}).ToList();
}
catch (Exception ex)
{
resp.Status = "F";
resp.Message = "Something went wrong";
}
return(resp);
}
public JsonResponse Summary()
{ //Used for Diository Listing
//Stored Procedure Used for listing Admin_GetDepository
try {
DataSet data = new DataSet();
data = new ADODataFunction().ExecuteDataset(Constants.Procedures.GetDepositorySummary, null, CommandType.StoredProcedure);
resp = data.Tables[0].AsEnumerable().Select(a => new JsonResponse
{
Status = a.Field <string>("STATUS"),
Message = a.Field <string>("MESSAGE")
}).FirstOrDefault();
resp.Data = data.Tables[1].AsEnumerable().Select(a => new Depository
{
Id = a.Field <long>("Id"),
DPCode = a.Field <string>("DPCode"),
DPName = a.Field <string>("DPName"),
AddressLine1 = a.Field <string>("Address"),
StateName = a.Field <string>("State"),
CityName = a.Field <string>("City"),
CountryName = a.Field <string>("Country"),
Pincode = a.Field <long>("Pincode"),
LastUpdatedDate = a.Field <string>("LastUpdatedDate"),
IsActiveText = a.Field <string>("Status")
}).ToList();
}
catch (Exception ex)
{
resp.Message = Constants.Service.Common_message;
}
return(resp);
}
public JsonResponse IsExists(long ClientID, int AccountTypeID, string UCC)
{
JsonResponse resp = new JsonResponse();
try
{
DataSet data = new DataSet();
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@ClientID", ClientID);
param[1] = new SqlParameter("@AccountTypeID", AccountTypeID);
param[2] = new SqlParameter("@UCC", UCC);
data = new ADODataFunction().ExecuteDataset(Constants.Procedures.ClientAccontIsExists, param, CommandType.StoredProcedure);
resp = data.Tables[0].AsEnumerable().Select(a => new JsonResponse
{
Status = a.Field <string>("STATUS"),
Message = a.Field <string>("MESSAGE")
}).FirstOrDefault();
}
catch (Exception ex)
{
resp.Status = "F";
resp.Message = "Something went wrong";
}
return(resp);
}
public JsonResponse Summary()
{ //Used for Employee Listing
//Stored Procedure Used for listing Admin_GetEmployee
try
{
DataSet data = new DataSet();
data = new ADODataFunction().ExecuteDataset(Constants.Procedures.GetSchemeNAV, null, CommandType.StoredProcedure);
resp = data.Tables[0].AsEnumerable().Select(a => new JsonResponse
{
Status = a.Field <string>("STATUS"),
Message = a.Field <string>("MESSAGE")
}).FirstOrDefault();
resp.Data = data.Tables[1].AsEnumerable().Select(a => new SchemeNAV
{
ID = a.Field <long>("ID"),
RTAName = a.Field <string>("RTAName"),
AMCName = a.Field <string>("AMCName"),
SchemeName = a.Field <string>("SchemeName"),
NAV = a.Field <decimal>("NAV"),
//NAVDate = a.Field<DateTime>(" NAVDate"),
LastUpdatedDate = a.Field <string>("LastUpdatedDate"),
// IsActiveText = a.Field<string>("Status")
}).ToList();
}
catch (Exception Ex)
{
resp.Message = Constants.Service.Common_message;
}
return(resp);
}
public JsonResponse ChangeStatus(long ID, bool Status)
{
JsonResponse resp = new JsonResponse();
try
{
DataSet data = new DataSet();
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@ID", ID);
param[1] = new SqlParameter("@Status", Status);
param[2] = new SqlParameter("@User", 1);
data = new ADODataFunction().ExecuteDataset(Constants.Procedures.ChangeStatusClientAccount, param, CommandType.StoredProcedure);
resp = data.Tables[0].AsEnumerable().Select(a => new JsonResponse
{
Status = a.Field <string>("STATUS"),
Message = a.Field <string>("MESSAGE")
}).FirstOrDefault();
}
catch (Exception ex)
{
resp.Status = "F";
resp.Message = "Something went wrong";
}
return(resp);
}
public JsonResponse Summary()
{
try
{
DataSet data = new DataSet();
data = new ADODataFunction().ExecuteDataset(Constants.Procedures.GetStateList, null, CommandType.StoredProcedure);
resp = data.Tables[0].AsEnumerable().Select(a => new JsonResponse
{
Status = a.Field <string>("STATUS"),
Message = a.Field <string>("MESSAGE")
}).FirstOrDefault();
resp.Data = data.Tables[1].AsEnumerable().Select(a => new State
{
Id = a.Field <long>("Id"),
StateName = a.Field <string>("StateName"),
StateCode = a.Field <string>("StateCode"),
GSTStateCode = a.Field <int>("GSTStateCode"),
CountryId = a.Field <long>("CountryId"),
CountryName = a.Field <string>("CountryName"),
IsUnionTerritory = a.Field <bool>("IsUnionTerritory"),
IsActiveText = a.Field <string>("Status"),
LastUpdatedDate = a.Field <string>("LastUpdatedDate")
}).ToList();
}
catch (Exception ex)
{
resp.Message = Constants.Service.Common_message;
}
return(resp);
}
public ClientAccountsMapping GetDataByID(long ID)
{
try
{
DataSet data = new DataSet();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", ID);
data = new ADODataFunction().ExecuteDataset(Constants.Procedures.GetClientAccountByID, param, CommandType.StoredProcedure);
return(data.Tables[0].AsEnumerable().Select(a => new ClientAccountsMapping
{
ID = a.Field <long>("ID"),
ClientID = a.Field <long>("L3_ClientID"),
AccountTypeID = a.Field <long>("L4_AccountTypeID"),
UCC = a.Field <string>("UCC"),
RMId = a.Field <long>("RMId"),
SecondaryRMId = a.Field <long>("SecondaryRMId"),
IsActive = a.Field <bool>("IsActive"),
CreatedBy = a.Field <long>("CreatedBy"),
CreatedOn = a.Field <DateTime>("CreatedOn"),
ModifiedBy = a.Field <long>("ModifiedBy"),
ModifiedOn = a.Field <DateTime>("ModifiedOn"),
IsDefault = a.Field <bool>("IsDefault"),
EffectiveFrom = a.Field <string>("EffectiveFrom"),
EffectiveTo = a.Field <string>("EffectiveTo")
}).FirstOrDefault());
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// Data Summary
/// </summary>
/// <returns>Jsonresponse</returns>
public IEnumerable <ClientFamily> Summary()
{
DataSet data = new DataSet();
IEnumerable <ClientFamily> clientfamily;
try
{
data = new ADODataFunction().ExecuteDataset("dbo.Admin_GetClientFamilySummary", null, CommandType.StoredProcedure);
clientfamily = data.Tables[0].AsEnumerable().Select(dataRow => new ClientFamily
{
Id = dataRow.Field <long>("Id"),
FamilyName = dataRow.Field <string>("FamilyName"),
FamilyShortName = dataRow.Field <string>("FamilyShortName"),
Groups = dataRow.Field <string>("GroupName"),
AddressLine1 = dataRow.Field <string>("AddressLine1"),
AddressLine2 = dataRow.Field <string>("AddressLine2"),
Countries = dataRow.Field <string>("CountryName"),
States = dataRow.Field <string>("StateName"),
Cities = dataRow.Field <string>("CityName"),
Pincode = dataRow.Field <long>("Pincode"),
Longitude = dataRow.Field <decimal>("Longitute"),
Latitude = dataRow.Field <decimal>("Latitude"),
IsActive = dataRow.Field <bool>("IsActive"),
LastUpdatedDate = dataRow.Field <string>("CreatedOn")
}).ToList();
return(clientfamily);
}
catch (Exception ex)
{
throw ex;
}
}
public IEnumerable <ZOI.BAL.Models.Enum> ListAll()
{
//Used for Employee Listing
//Stored Procedure Used for listing Admin_GetEmployee
DataSet data = new DataSet();
IEnumerable <ZOI.BAL.Models.Enum> EnumList;
try
{
data = new ADODataFunction().ExecuteDataset(Constants.Procedures.GetEnumList, null, CommandType.StoredProcedure);
EnumList = data.Tables[1].AsEnumerable().Select(a => new ZOI.BAL.Models.Enum
{
ID = a.Field <long>("Id"),
EnumType = a.Field <string>("EnumType"),
EnumValue = a.Field <int>("EnumValue"),
EnumCode = a.Field <string>("EnumCode"),
EnumDescription = a.Field <string>("EnumDescription"),
Icons = a.Field <string>("Icons"),
LastUpdatedDate = a.Field <string>("LastUpdatedDate"),
IsActiveText = a.Field <string>("Status")
}).ToList();
}
catch
{
return(null);
}
return(EnumList);
}
