public static PhoneSetupCollection GetbyUser(string CreatedUser)
{
PhoneSetupCollection collection = new PhoneSetupCollection();
PhoneSetup obj;
using (var reader = SqlHelper.ExecuteReader("tblPhoneSetup_GetAll_byUser", new SqlParameter("@CreatedUser", CreatedUser)))
{
while (reader.Read())
{
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static PhoneSetupCollection GetAllItem()
{
PhoneSetupCollection collection = new PhoneSetupCollection();
using (var reader = SqlHelper.ExecuteReader("tblPhoneSetup_GetAll", null))
{
while (reader.Read())
{
PhoneSetup obj = new PhoneSetup();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static PhoneSetupCollection GetSimPort()
{
PhoneSetupCollection collection = new PhoneSetupCollection();
using (var reader = SqlHelper.ExecuteReader("ContactsBackup_GetComPort", null))
{
while (reader.Read())
{
PhoneSetup obj = new PhoneSetup();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}