public static mPin Load(string id)
{
mPin ret = null;
ClassQuery cq = new ClassQuery("Org.Reddragonit.FreeSwitchConfig.Site.BaseComponents.Data",
"SELECT pn.ID,pn.OwningSet.Name,pn.OwningSet.Context.Name,pn.Extension.Number,pn.Extension.Domain.Name,pn.PinNumber FROM Pin pn " +
"WHERE pn.OwningSet.Name = @setName AND pn.OwningSet.Context.Name = @contextName AND pn.ID = @id");
cq.Execute(new IDbDataParameter[] {
cq.CreateParameter("@setName", id.Substring(0, id.IndexOf("@"))),
cq.CreateParameter("@contextName", id.Substring(id.IndexOf("@") + 1, id.IndexOf(":") - id.IndexOf("@"))),
cq.CreateParameter("@id", id.Substring(id.IndexOf(":") + 1))
});
if (cq.Read())
{
ret = new mPin(cq);
}
cq.Close();
return(ret);
}
public static mPin Load(string id)
{
mPin ret = null;
ClassQuery cq = new ClassQuery("Org.Reddragonit.FreeSwitchConfig.Site.BaseComponents.Data",
"SELECT pn.ID,pn.OwningSet.Name,pn.OwningSet.Context.Name,pn.Extension.Number,pn.Extension.Domain.Name,pn.PinNumber FROM Pin pn " +
"WHERE pn.OwningSet.Name = @setName AND pn.OwningSet.Context.Name = @contextName AND pn.ID = @id");
cq.Execute(new IDbDataParameter[]{
cq.CreateParameter("@setName",id.Substring(0,id.IndexOf("@"))),
cq.CreateParameter("@contextName",id.Substring(id.IndexOf("@")+1,id.IndexOf(":")-id.IndexOf("@"))),
cq.CreateParameter("@id",id.Substring(id.IndexOf(":")+1))
});
if (cq.Read())
ret = new mPin(cq);
cq.Close();
return ret;
}
