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