public static RelationshipStatuses GetDistinctRelationshipStatus()
{
RelationshipStatuses relations = null;
// get a configured DbCommand object
DbCommand comm = DbAct.CreateCommand();
// set the stored procedure name
comm.CommandText = "up_GetDistinctRelationshipStatus";
// execute the stored procedure
DataTable dt = DbAct.ExecuteSelectCommand(comm);
// was something returned?
if (dt == null || dt.Rows.Count <= 0) return relations;
relations = new RelationshipStatuses();
relations.AddRange(dt.Rows.Cast<DataRow>()
.Select(dr =>
new RelationshipStatus(
FromObj.IntFromObj(dr["relationshipStatusID"])))
.Where(relation => relation.RelationshipStatusID != 0));
return relations;
}
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});
}
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 });
}
public static RelationshipStatuses GetDistinctRelationshipStatus()
{
RelationshipStatuses relations = null;
// get a configured DbCommand object
DbCommand comm = DbAct.CreateCommand();
// set the stored procedure name
comm.CommandText = "up_GetDistinctRelationshipStatus";
// execute the stored procedure
DataTable dt = DbAct.ExecuteSelectCommand(comm);
// was something returned?
if (dt != null && dt.Rows.Count > 0)
{
relations = new RelationshipStatuses();
RelationshipStatus relation = null;
foreach (DataRow dr in dt.Rows)
{
relation = new RelationshipStatus(FromObj.IntFromObj(dr["relationshipStatusID"]));
if (relation.RelationshipStatusID == 0) continue;
relations.Add(relation);
}
}
return relations;
}
