public Admin()
{
appObj = new Application1();
cusObj = new Customer();
devObj = new Developer();
permissionObj = new Permissions();
}
public CustomerDBLayer()
{
cusObj = new Customer();
appObj = new Application1();
obj.assign();
con = obj.con;
}
public void getApplicationData(String appName)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string query = "Select a.*,p.name as 'PName',d.capacity,d.OS from Device d, Application a left join Person p on a.developerID=p.id where a.name='" + appName + "' and a.deviceID=d.id";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader reader = cmd.ExecuteReader();
decimal c;
app = new Application1();
while (reader.Read())
{
app.setName(reader["name"].ToString());
app.setDescription(reader["description"].ToString());
app.setVersion(reader["version1"].ToString());
app.setCategory(reader["category"].ToString());
app.setRating(reader["rating"].ToString());
app.setdevName(reader["PName"].ToString());
app.setPrice(Convert.ToDecimal(reader["price"].ToString()));
app.dev.setOS(reader["OS"].ToString());
c = Convert.ToDecimal(reader["capacity"].ToString()) / 1024;
app.dev.setCapacity((decimal)System.Math.Round(c, 2));
}
reader.Close();
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public Customer()
{
device = new Device();
app = new Application1();
}
public Developer()
{
app = new Application1();
}
public ApplicationDBLayer()
{
app = new Application1();
obj.assign();
con = obj.con;
}