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); } }
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 AddUpdateClientSecondaryContactDetails(ClientSecondaryContact model) { try { SqlParameter[] param = new SqlParameter[9]; param[0] = new SqlParameter("@ID", model.ID); param[1] = new SqlParameter("@ClientID", model.ClientID); param[2] = new SqlParameter("@Relationship", model.Relationship); param[3] = new SqlParameter("@MobileNumber", model.MobileNumber); param[4] = new SqlParameter("@EmailId", model.EmailId); param[5] = new SqlParameter("@EffectiveFrom", model.EffectiveFrom); param[6] = new SqlParameter("@EffectiveTo", model.EffectiveTo); param[7] = new SqlParameter("@Name", model.Name); param[8] = new SqlParameter("@UserID", GetUserID()); //param[8] = new SqlParameter("@UserID", Convert.ToInt32(GetUserID("RoleID"))); int i = new ADODataFunction().ExecuteNonQuery(Constants.Procedures.AddUpdateClientSecondaryContactDetails, param, CommandType.StoredProcedure); return(i); } catch (Exception ex) { return(0); } }