public static YouAres GetDistinctYouAres() { YouAres youAres = null; // get a configured DbCommand object DbCommand comm = DbAct.CreateCommand(); // set the stored procedure name comm.CommandText = "up_GetDistinctYouAres"; // execute the stored procedure DataTable dt = DbAct.ExecuteSelectCommand(comm); // was something returned? if (dt == null || dt.Rows.Count <= 0) return youAres; youAres = new YouAres(); youAres.AddRange(dt.Rows.Cast<DataRow>() .Select(dr => new YouAre(FromObj.IntFromObj(dr["youAreID"]))) .Where(youAre => youAre.YouAreID != 0)); return youAres; }
private void InterestIdentityViewBags() { /// var interins = new InterestedIns(); interins.GetAll(); interins.Sort(delegate(InterestedIn p1, InterestedIn p2) { return p1.LocalizedName.CompareTo(p2.LocalizedName); }); ViewBag.InterestedIns = interins.Select(x => new { InterestedInID = x.InterestedInID, LocalizedName = x.LocalizedName }); /// var relationshipStatuses = new RelationshipStatuses(); relationshipStatuses.GetAll(); relationshipStatuses.Sort(delegate(RelationshipStatus p1, RelationshipStatus p2) { return p1.LocalizedName.CompareTo(p2.LocalizedName); }); ViewBag.RelationshipStatuses = relationshipStatuses.Select(x => new { RelationshipStatusID = x.RelationshipStatusID, LocalizedName = x.LocalizedName }); /// var youAres = new YouAres(); youAres.GetAll(); youAres.Sort(delegate(YouAre p1, YouAre p2) { return p1.LocalizedName.CompareTo(p2.LocalizedName); }); ViewBag.YouAres = youAres.Select(x => new { YouAreID = x.YouAreID, LocalizedName = x.LocalizedName }); }
private int ReverseYouAreByInterestName(int? interesetedinID) { if (interesetedinID == null) return 0; InterestedIn iiinets = new InterestedIn(); iiinets.Get(Convert.ToInt32(interesetedinID)); YouAres iins = new YouAres(); iins.GetAll(); foreach (YouAre inn1 in iins) { if (inn1.Name == iiinets.Name) { return inn1.YouAreID; ; } } return 0; }
private void InterestIdentityViewBags() { var interins = new InterestedIns(); interins.GetAll(); interins.Sort( (p1, p2) => String.Compare(p1.LocalizedName, p2.LocalizedName, StringComparison.Ordinal)); ViewBag.InterestedIns = interins.Select(x => new {x.InterestedInID, x.LocalizedName}); var relationshipStatuses = new RelationshipStatuses(); relationshipStatuses.GetAll(); relationshipStatuses.Sort( (p1, p2) => String.Compare(p1.LocalizedName, p2.LocalizedName, StringComparison.Ordinal)); ViewBag.RelationshipStatuses = relationshipStatuses.Select(x => new {x.RelationshipStatusID, x.LocalizedName}); var youAres = new YouAres(); youAres.GetAll(); youAres.Sort((p1, p2) => String.Compare(p1.LocalizedName, p2.LocalizedName, StringComparison.Ordinal)); ViewBag.YouAres = youAres.Select(x => new {x.YouAreID, x.LocalizedName}); }
public static YouAres GetDistinctYouAres() { YouAres youAres = null; // get a configured DbCommand object DbCommand comm = DbAct.CreateCommand(); // set the stored procedure name comm.CommandText = "up_GetDistinctYouAres"; // execute the stored procedure DataTable dt = DbAct.ExecuteSelectCommand(comm); // was something returned? if (dt != null && dt.Rows.Count > 0) { youAres = new YouAres(); YouAre youAre=null; foreach (DataRow dr in dt.Rows) { youAre = new YouAre(FromObj.IntFromObj(dr["youAreID"])); if (youAre.YouAreID == 0) continue; youAres.Add(youAre); } } return youAres; }