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