public void AddProperties()
{
tbl_MembershipType membershiptype = new tbl_MembershipType(this.mtyCode);
this.Name = membershiptype.mtyName;
SFG_ProdCode code = SFG_ProdCode.GetFromIntCode(this.mtyCode);
this.PublicationCode = code.ExtCode;
}
public void AddProperties()
{
tbl_MembershipType membershiptype = new tbl_MembershipType(this.mtyCode);
this.Name = membershiptype.mtyName;
SFG_ProdCode code = SFG_ProdCode.GetFromIntCode(this.mtyCode);
this.PublicationCode = code.ExtCode;
}
public tbl_MembershipType(string mtyCode)
{
tbl_MembershipType membershiptype = new tbl_MembershipType();
using (AHT_MainDataContext context = new AHT_MainDataContext(ConfigurationManager.ConnectionStrings["AHT_MainConnectionString"].ConnectionString))
{
membershiptype = (from a in context.tbl_MembershipTypes
where a.mtyCode == mtyCode
select a).SingleOrDefault();
}
if (membershiptype != null)
{
this.mtyCode = membershiptype.mtyCode;
this.mtyGUID = membershiptype.mtyGUID;
this.mtyName = membershiptype.mtyName;
}
}
public tbl_MembershipType(string mtyCode)
{
tbl_MembershipType membershiptype = new tbl_MembershipType();
using (AHT_MainDataContext context = new AHT_MainDataContext(ConfigurationManager.ConnectionStrings["AHT_MainConnectionString"].ConnectionString))
{
membershiptype = (from a in context.tbl_MembershipTypes
where a.mtyCode == mtyCode
select a).SingleOrDefault();
}
if (membershiptype != null)
{
this.mtyCode = membershiptype.mtyCode;
this.mtyGUID = membershiptype.mtyGUID;
this.mtyName = membershiptype.mtyName;
}
}
partial void Deletetbl_MembershipType(tbl_MembershipType instance);
partial void Updatetbl_MembershipType(tbl_MembershipType instance);
partial void Inserttbl_MembershipType(tbl_MembershipType instance);