public void AddMember(string[] args)
{
objConnect = new DatabaseConnection();
objConnect.Sql = "INSERT INTO dbo.Members (Name,ID,Age,Weight,Sex,Address,Phone_NO) VALUES ('" + args[0] + "','" + args[1] + "','" + args[2] + "','" + args[3] + "','" + args[4] + "','" + args[5] + "','" + args[6] + "')";
int x = objConnect.ExecuteSqlCommand();
m_contoller.CheckChanges(x);
}
public List<string> GetDistributionList()
{
objConnect = new DatabaseConnection();
objConnect.Sql = "SELECT Name FROM Distribution_lists";
ds = objConnect.GetConnection;
List<string> list = new List<string>();
for (int i = 0 ; i < ds.Tables[0].Rows.Count; i++)
{
list.Add(ds.Tables[0].Rows[i].ItemArray.GetValue(0).ToString());
}
return list;
}
public void CheckClass(string class_name)
{
string[] args = m_contoller.getArgs();
Console.WriteLine(args[0] + " " + args[1]);
objConnect = new DatabaseConnection();
objConnect.Sql = String.Format("SELECT M.Name, M.ID FROM Members_class MC, Members M WHERE MC.Class_name = '{0}' and MC.Time = '{1}' and MC.Date = '{2}' and MC.Member_ID = M.ID", class_name, args[0], args[1]);
ds = objConnect.GetConnection;
string class_desc = "";
objConnect.Sql = String.Format("SELECT Description FROM Classes WHERE Name = '{0}'", class_name);
DataSet ds_class_desc = objConnect.GetConnection;
if (ds_class_desc.Tables[0].Rows.Count != 0)
{
class_desc = ds_class_desc.Tables[0].Rows[0].ItemArray.GetValue(0).ToString();
}
string trainer = "";
objConnect.Sql = String.Format("SELECT E.Name FROM Trainer_Class TC, Employees E WHERE TC.Class_Name = '{0}' and TC.Trainer_ID = E.ID", class_name);
DataSet ds_class_trainer = objConnect.GetConnection;
if (ds_class_trainer.Tables[0].Rows.Count != 0)
{
trainer = ds_class_trainer.Tables[0].Rows[0].ItemArray.GetValue(0).ToString();
}
m_contoller.table(ds, String.Format("Participants List for {0}:\n", class_name), class_desc, trainer);
}