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