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 ClientMainViewModel() { ClientDetails = new ClientMain(); AddressDetails = new ClientAddresses(); BankDetails = new ClientBankDetails(); DepositryDetails = new ClientDepositoryDetails(); EquityBrokerDetails = new ClientEquityBrokerDetails(); PersonalDetails = new ClientPersonal(); SecondaryContactDetails = new ClientSecondaryContact(); MappingDetails = new ClientMapping(); }
public int AddUpdateClientDepositoryDetails(ClientDepositoryDetails model) { try { SqlParameter[] param = new SqlParameter[7]; param[0] = new SqlParameter("@ID", model.ID); param[1] = new SqlParameter("@ClientID", model.ClientID); param[2] = new SqlParameter("@DpId", model.DpId); param[3] = new SqlParameter("@AccountNumber", model.AccountNumber); param[4] = new SqlParameter("@EffectiveFrom", model.EffectiveFrom); param[5] = new SqlParameter("@EffectiveTo", model.EffectiveTo); //param[6] = new SqlParameter("@UserID", Convert.ToInt32(GetUserID("RoleID"))); param[6] = new SqlParameter("@UserID", GetUserID()); int i = new ADODataFunction().ExecuteNonQuery(Constants.Procedures.AddUpdateClientDepositoryDetails, param, CommandType.StoredProcedure); return(i); } catch (Exception ex) { return(0); } }