public bool updateOtherMembers(AreobicMember arem)
{
bool temp = false;
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
SqlTransaction trn = con.getConnection().BeginTransaction();
try
{
//qery one
string q1 = "update tbl_member set name=@name, dob=@dob,address=@address,nic=@nic,gender=@gender,phone=@phone where regNo=@regNo";
SqlCommand cmd1 = new SqlCommand(q1, con.getConnection());
cmd1.Parameters.AddWithValue("@regNo", arem.MemberID);
cmd1.Parameters.AddWithValue("@name", arem.name);
cmd1.Parameters.AddWithValue("@dob", arem.dob);
cmd1.Parameters.AddWithValue("@address", arem.addresss);
cmd1.Parameters.AddWithValue("@nic", arem.nic);
cmd1.Parameters.AddWithValue("@gender", arem.gender);
cmd1.Parameters.AddWithValue("@phone", arem.phone);
cmd1.Transaction = trn;
cmd1.ExecuteNonQuery();
//qery two
string q2 = "update tbl_areobic_member set service_type=@st where memberID=@regNo";
SqlCommand cmd2 = new SqlCommand(q2, con.getConnection());
cmd2.Parameters.AddWithValue("@regNo", arem.MemberID);
cmd2.Parameters.AddWithValue("@st", arem.service_type);
cmd2.Transaction = trn;
cmd2.ExecuteNonQuery();
trn.Commit();
con.closeConnection();
temp = true;
}
catch (Exception dd)
{
trn.Rollback();
throw;
}
if (temp == true)
{
return(true);
}
else
{
return(false);
}
}
public bool searchEMP(Buisness_Logic.employee emp)
{
try
{
DataLayer.dbConnect dbemp_seach = new DataLayer.dbConnect();
dbemp_seach.openConnection();
bool temp = false;
string query1 = "SELECT * FROM tbl_employee WHERE empID=@reg OR name=@name OR nic=@nic";
SqlCommand cmd1 = new SqlCommand(query1, dbemp_seach.getConnection());
cmd1.Parameters.AddWithValue("@reg", emp.empID);
cmd1.Parameters.AddWithValue("@name", emp.name);
cmd1.Parameters.AddWithValue("@nic", emp.nic);
DataTable dtq = new DataTable();
SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
da1.Fill(dtq);
if (dtq.Rows.Count > 0)
{
emp.empID = int.Parse(dtq.Rows[0]["empID"].ToString());
emp.name = dtq.Rows[0]["name"].ToString();
emp.nic = dtq.Rows[0]["nic"].ToString();
emp.dob = dtq.Rows[0]["dob"].ToString();
emp.gender = dtq.Rows[0]["gender"].ToString();
emp.address = dtq.Rows[0]["address"].ToString();
emp.phone = dtq.Rows[0]["phone"].ToString();
emp.email = dtq.Rows[0]["email"].ToString();
emp.position = dtq.Rows[0]["position"].ToString();
emp.profile = dtq.Rows[0]["profile"].ToString();
emp.photo = (byte[])dtq.Rows[0]["photo"];
emp.joinedDate = dtq.Rows[0]["joinedDate"].ToString();
temp = true;
}
if (temp == true)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ert)
{
throw;
}
}
public bool searchRepairItem(int repID, int equiID, Buisness_Logic.repair rep)
{
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
bool temp = false;
try
{
string q = "select * from tbl_repair where repairID=@rid or repairalble_itemID=@mid ";
SqlCommand cmd = new SqlCommand(q, con.getConnection());
cmd.Parameters.AddWithValue("@rid", repID);
cmd.Parameters.AddWithValue("@mid", equiID);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
rep.repID = (int)dt.Rows[0]["repairID"];
rep.equipmentID = (int)dt.Rows[0]["repairalble_itemID"];
rep.status = dt.Rows[0]["status"].ToString();
rep.descriptioin = dt.Rows[0]["description"].ToString();
if (!DBNull.Value.Equals(dt.Rows[0]["cost"]))
{
rep.cost = double.Parse(dt.Rows[0]["cost"].ToString());
}
else
{
}
rep.start_date = dt.Rows[0]["start_date"].ToString();
rep.finished_date = dt.Rows[0]["finished_date"].ToString();
rep.equipmentName = dt.Rows[0]["equi_name"].ToString();
temp = true;
}
}
catch (Exception fsdfs)
{
throw;
}
if (temp == true)
{
return(true);
}
else
{
return(false);
}
}
public bool updateWeightLiftingItems(Buisness_Logic.nonRepairable_Item prd)
{
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
bool temp = false;
SqlTransaction trn = con.getConnection().BeginTransaction();
try
{
string qry1 = "update tbl_inventory set name=@name,make=@make,model=@model,price=@price,photo=@photo where invID=@id";
SqlCommand cmd = new SqlCommand(qry1, con.getConnection());
cmd.Parameters.AddWithValue("@name", prd.name);
cmd.Parameters.AddWithValue("@make", prd.make);
cmd.Parameters.AddWithValue("@model", prd.model);
cmd.Parameters.AddWithValue("@price", prd.price);
cmd.Parameters.AddWithValue("@photo", prd.photo);
cmd.Parameters.AddWithValue("@id", prd.invID);
cmd.Transaction = trn;
cmd.ExecuteNonQuery();
string qry2 = "update tbl_non_repairable set qty=@qty,weight=@weight where invetoryID=@invid";
SqlCommand cmd2 = new SqlCommand(qry2, con.getConnection());
cmd2.Parameters.AddWithValue("@weight", prd.weight);
cmd2.Parameters.AddWithValue("@qty", prd.qty);
cmd2.Parameters.AddWithValue("@invid", prd.invID);
cmd2.Transaction = trn;
cmd2.ExecuteNonQuery();
trn.Commit();
temp = true;
con.closeConnection();
}
catch (Exception dsa)
{
trn.Rollback();
throw;
}
if (temp == true)
{
return(true);
}
else
{
return(false);
}
}
public bool searchWL_Items(int id, string pname, Buisness_Logic.nonRepairable_Item prd)
{
// Buisness_Logic.product prd = new Buisness_Logic.product();
bool temp = false;
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
try
{
string qr = "select * from view_nonRepItems where invID=@id or name=@name";
SqlCommand cmd = new SqlCommand(qr, con.getConnection());
cmd.Parameters.AddWithValue("@id", id);
cmd.Parameters.AddWithValue("@name", pname);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
prd.invID = (int)dt.Rows[0]["invID"];
prd.name = dt.Rows[0]["name"].ToString();
prd.make = dt.Rows[0]["make"].ToString();
prd.qty = (int)dt.Rows[0]["qty"];
prd.price = (double)dt.Rows[0]["price"];
prd.weight = (double)dt.Rows[0]["weight"];
prd.model = dt.Rows[0]["model"].ToString();
prd.photo = (byte[])dt.Rows[0]["photo"];
temp = true;
}
}
catch (Exception pt)
{
throw;
}
if (temp == true)
{
return(true);
}
else
{
return(false);
}
}
public bool searchProduct(int id, string pname, Buisness_Logic.product prd)
{
// Buisness_Logic.product prd = new Buisness_Logic.product();
bool temp = false;
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
try
{
string qr = "select * from tbl_product where productID=@id or name=@name";
SqlCommand cmd = new SqlCommand(qr, con.getConnection());
cmd.Parameters.AddWithValue("@id", id);
cmd.Parameters.AddWithValue("@name", pname);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
prd.productID = (int)dt.Rows[0]["productID"];
prd.name = dt.Rows[0]["name"].ToString();
prd.make = dt.Rows[0]["make"].ToString();
prd.qty = (int)dt.Rows[0]["qty"];
prd.buying_price = (double)dt.Rows[0]["buying_price"];
prd.selling_Price = (double)dt.Rows[0]["selling_price"];
prd.productType = dt.Rows[0]["p_type"].ToString();
prd.photo = (byte[])dt.Rows[0]["photo"];
temp = true;
}
}
catch (Exception pt)
{
throw;
}
if (temp == true)
{
return(true);
}
else
{
return(false);
}
}
public bool update_employee(employee g)
{
bool tup = false;
try
{
DataLayer.dbConnect dbu = new DataLayer.dbConnect();
dbu.openConnection();
SqlCommand cmdu = null;
string qup = "UPDATE tbl_employee set name=@name, dob=@dob, nic=@nic, address=@address , gender=@gender,email=@email, phone=@phone , position=@position ,profile=@profile,joinedDate=@jdate,photo=@photo where empID=@reg ";
cmdu = new SqlCommand(qup, dbu.getConnection());
cmdu.Parameters.AddWithValue("@name", g.name);
cmdu.Parameters.AddWithValue("@dob", g.dob);
cmdu.Parameters.AddWithValue("@address", g.address);
cmdu.Parameters.AddWithValue("@nic", g.nic);
cmdu.Parameters.AddWithValue("@gender", g.gender);
cmdu.Parameters.AddWithValue("@phone", g.phone);
cmdu.Parameters.AddWithValue("@reg", g.empID);
cmdu.Parameters.AddWithValue("@email", g.email);
cmdu.Parameters.AddWithValue("@position", g.position);
cmdu.Parameters.AddWithValue("@photo", g.photo);
cmdu.Parameters.AddWithValue("@profile", g.profile);
cmdu.Parameters.AddWithValue("@jdate", g.joinedDate);
cmdu.ExecuteNonQuery();
tup = true;
}
catch (Exception epu)
{
// trnup.Rollback();
MessageBox.Show(epu.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
throw;
}
if (tup == true)
{
return(true);
}
else
{
return(false);
}
}
public bool searchAerobicMemOnly(int memID, string name, string nic, AreobicMember arm)
{
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
bool temp = false;
try
{
string q1 = "select * from veiw_areobicMember where memberID=@regNo or nic=@nic or name=@name";
SqlCommand cmd1 = new SqlCommand(q1, con.getConnection());
cmd1.Parameters.AddWithValue("@regNo", memID);
cmd1.Parameters.AddWithValue("@nic", nic);
cmd1.Parameters.AddWithValue("@name", name);
SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
DataTable dt1 = new DataTable();
da1.Fill(dt1);
if (dt1.Rows.Count > 0)
{
arm.MemberID = int.Parse(dt1.Rows[0]["memberID"].ToString());
arm.name = dt1.Rows[0]["name"].ToString();
arm.nic = dt1.Rows[0]["nic"].ToString();
arm.dob = dt1.Rows[0]["dob"].ToString();
arm.gender = dt1.Rows[0]["gender"].ToString();
arm.addresss = dt1.Rows[0]["address"].ToString();
arm.phone = dt1.Rows[0]["phone"].ToString();
arm.service_type = dt1.Rows[0]["service_type"].ToString();
temp = true;
}
}
catch (Exception df)
{
throw;
}
if (temp == true)
{
return(true);
}
else
{
return(false);
}
}
private void dataGrid_generation_gym()
{
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
string q = "select * from gym_income";
SqlCommand cmd = new SqlCommand(q, con.getConnection());
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridFin1.DataSource = dt;
}
private void dataGrid_generation_expense()
{
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
string q = "select * from sales_finance";
SqlCommand cmd = new SqlCommand(q, con.getConnection());
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
datagrid_expe.DataSource = dt;
}
public bool searchWorkouts(Buisness_Logic.workout wrk)
{
bool temp = false;
try
{
DataLayer.dbConnect workoutSearch = new DataLayer.dbConnect();
workoutSearch.openConnection();
string query1 = "SELECT * FROM tbl_workout WHERE w_name=@workout";
SqlCommand cmd1 = new SqlCommand(query1, workoutSearch.getConnection());
cmd1.Parameters.AddWithValue("@workout", wrk.workout_name);
DataTable dtq = new DataTable();
SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
// workout wrk = new workout();
da1.Fill(dtq);
if (dtq.Rows.Count > 0)
{
wrk.id = int.Parse(dtq.Rows[0]["w_id"].ToString());
wrk.workout_name = dtq.Rows[0]["w_name"].ToString();
wrk.type = dtq.Rows[0]["type"].ToString();
//wrk.BMI_rate = double.Parse(dtq.Rows[0]["BMI_rate"].ToString());
//wrk.fat_level = double.Parse(dtq.Rows[0]["fat_level"].ToString());
wrk.repeats = int.Parse(dtq.Rows[0]["repeats"].ToString());
wrk.interval_days = dtq.Rows[0]["interval_days"].ToString();
temp = true;
}
workoutSearch.closeConnection();
}
catch (Exception exp)
{
throw;
}
if (temp == true)
{
return(true);
}
else
{
return(false);
}
}
public bool getIncome(int year, int month, Finance ff)
{
double amount;
DataTable dt = new DataTable();
try
{
string str = string.Concat(year, month, "01");
DateTime date1;
DateTime.TryParseExact(str, "yyyyMMdd", CultureInfo.InvariantCulture, DateTimeStyles.None, out date1);
var firstDayOfMonth = new DateTime(date1.Year, date1.Month, 1);
var lastDayOfMonth = firstDayOfMonth.AddMonths(1).AddDays(-1);
//if (DateTime.Now.ToShortDateString() >)
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
string qurey = "Select SUM(amount) from tbl_fee where paid_date between @fdate and @tdate";
SqlCommand cmd = new SqlCommand(qurey, con.getConnection());
cmd.Parameters.AddWithValue("@fdate", firstDayOfMonth.ToShortDateString());
cmd.Parameters.AddWithValue("@tdate", lastDayOfMonth.ToShortDateString());
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
}
catch (Exception ex1)
{
throw;
}
if (dt.Rows[0][0] != null && !string.IsNullOrEmpty(dt.Rows[0][0].ToString()))
{
ff.amount = (double)dt.Rows[0][0];
return(true);
}
else
{
ff.amount = 0.00;
return(false);
}
}
public bool deleteMemeber(gymMember gm)
{
bool tempdel = false;
DataLayer.dbConnect cond = new DataLayer.dbConnect();
cond.openConnection();
SqlTransaction trnd = cond.getConnection().BeginTransaction();
try
{
string qd = "DELETE tbl_gymMember WHERE memberID=@mem ";
SqlCommand cmdel = new SqlCommand(qd, cond.getConnection());
cmdel.Parameters.AddWithValue("@mem", gm.MemberID);
cmdel.Transaction = trnd;
cmdel.ExecuteNonQuery();
string qd1 = "DELETE tbl_member WHERE regNo=@mem ";
SqlCommand cmdel1 = new SqlCommand(qd1, cond.getConnection());
cmdel1.Parameters.AddWithValue("@mem", gm.MemberID);
cmdel1.Transaction = trnd;
cmdel1.ExecuteNonQuery();
trnd.Commit();
cond.closeConnection();
tempdel = true;
}
catch (Exception edel)
{
trnd.Rollback();
throw;
}
if (tempdel == true)
{
return(true);
}
else
{
return(false);
}
}
public bool deleteWLI(int id)
{
bool temp = false;
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
SqlTransaction trn = con.getConnection().BeginTransaction();
try
{
string qd = "delete tbl_non_repairable where invetoryID=@id";
SqlCommand cmd1 = new SqlCommand(qd, con.getConnection());
cmd1.Parameters.AddWithValue("@id", id);
cmd1.Transaction = trn;
cmd1.ExecuteNonQuery();
string q2 = "delete tbl_inventory where invID=@id";
SqlCommand cmd2 = new SqlCommand(q2, con.getConnection());
cmd2.Parameters.AddWithValue("@id", id);
cmd2.Transaction = trn;
cmd2.ExecuteNonQuery();
trn.Commit();
con.closeConnection();
temp = true;
}
catch (Exception ui)
{
trn.Rollback();
throw;
}
if (temp == true)
{
return(true);
}
else
{
return(false);
}
}
public bool addWorkouts(Buisness_Logic.workout wo)
{
bool temp = false;
try
{
DataLayer.dbConnect con1 = new DataLayer.dbConnect();
con1.openConnection();
string q1 = "INSERT INTO tbl_workout values (@name,@type,@bmi_f,@fat_f,@interval,@bmi_t,@fat_t)";
//(w_name,type, BMI_rate,fat_level,repeats,interval_days)
SqlCommand cmd1 = new SqlCommand(q1, con1.getConnection());
cmd1.Parameters.AddWithValue("@name", wo.workout_name);
cmd1.Parameters.AddWithValue("@type", wo.type);
//from
cmd1.Parameters.AddWithValue("@bmi_f", wo.BMI_rate_from);
cmd1.Parameters.AddWithValue("@fat_f", wo.fat_level_from);
//to
cmd1.Parameters.AddWithValue("@bmi_t", wo.BMI_rate_to);
cmd1.Parameters.AddWithValue("@fat_t", wo.fat_level_to);
cmd1.Parameters.AddWithValue("@interval", wo.interval_days);
cmd1.ExecuteNonQuery();
temp = true;
}
catch (Exception exr)
{
throw;
}
if (temp == true)
{
return(true);
}
else
{
return(false);
}
}
public bool getIncome_thisMonth(Finance ff)
{
double amount;
DataTable dt = new DataTable();
try
{
DateTime date1 = DateTime.Today;
var firstDayOfMonth = new DateTime(date1.Year, date1.Month, 1);
var lastDayOfMonth = firstDayOfMonth.AddMonths(1).AddDays(-1);
//if (DateTime.Now.ToShortDateString() >)
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
string qurey = "Select sum(amount) from tbl_fee where paid_date between @fdate and @tdate";
SqlCommand cmd = new SqlCommand(qurey, con.getConnection());
cmd.Parameters.AddWithValue("@fdate", firstDayOfMonth.ToShortDateString());
cmd.Parameters.AddWithValue("@tdate", lastDayOfMonth.ToShortDateString());
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
}
catch (Exception ex1)
{
throw;
}
if (dt.Rows[0][0] != null && !string.IsNullOrEmpty(dt.Rows[0][0].ToString()))
{
ff.amount = (double)dt.Rows[0][0];
return(true);
}
else
{
ff.amount = 0.00;
return(false);
}
}
public bool updateWorkouts(Buisness_Logic.workout wo1)
{
bool temp = false;
try
{
DataLayer.dbConnect mydb = new DataLayer.dbConnect();
mydb.openConnection();
SqlCommand cmd = null;
string qry = "UPDATE tbl_workout SET type=@type, BMI_rate_from=@BMIf, fat_level_from=@fatf, interval_days=@interval,BMI_rate_to=@bmito,fat_level_to=@fatto WHERE w_name=@wname";
cmd = new SqlCommand(qry, mydb.getConnection());
cmd.Parameters.AddWithValue("@type", wo1.type);
cmd.Parameters.AddWithValue("@BMIf", wo1.BMI_rate_from);
cmd.Parameters.AddWithValue("@fatf", wo1.fat_level_from);
cmd.Parameters.AddWithValue("@repeat", wo1.repeats);
cmd.Parameters.AddWithValue("@interval", wo1.interval_days);
cmd.Parameters.AddWithValue("@bmito", wo1.BMI_rate_to);
cmd.Parameters.AddWithValue("@fatto", wo1.fat_level_to);
cmd.Parameters.AddWithValue("@wname", wo1.workout_name);
cmd.ExecuteNonQuery();
temp = true;
}
catch (Exception exr)
{
throw;
}
if (temp == true)
{
return(true);
}
else
{
return(false);
}
}
public bool do_log()
{
bool temp = false;
try
{
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
string q = " select * from tbl_userLogin where username=@uname and password=@pwd";
SqlCommand cmd = new SqlCommand(q, con.getConnection());
cmd.Parameters.AddWithValue("@uname", username);
cmd.Parameters.AddWithValue("@pwd", pwd);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
if (dt.Rows.Count == 1)
{
user_type = (bool)dt.Rows[0]["type"];
temp = true;
}
}
catch (Exception dfs)
{
throw;
}
if (temp == true)
{
return(true);
}
else
{
return(false);
}
}
public bool addEmployee(Buisness_Logic.employee emp)
{
bool temp1 = false;
try
{
DataLayer.dbConnect con1 = new DataLayer.dbConnect();
con1.openConnection();
string q1 = "insert into tbl_employee (name,dob,nic,address,gender,email,phone,position,profile,joinedDate,photo) values (@name,@dob,@nic,@address,@gender,@email,@phone,@position,@profile,@jdate,@photo)";
SqlCommand cmd1 = new SqlCommand(q1, con1.getConnection());
cmd1.Parameters.AddWithValue("@name", emp.name);
cmd1.Parameters.AddWithValue("@dob", emp.dob);
cmd1.Parameters.AddWithValue("@nic", emp.nic);
cmd1.Parameters.AddWithValue("@address", emp.address);
cmd1.Parameters.AddWithValue("@gender", emp.gender);
cmd1.Parameters.AddWithValue("@email", emp.email);
cmd1.Parameters.AddWithValue("@phone", emp.phone);
cmd1.Parameters.AddWithValue("@position", emp.position);
cmd1.Parameters.AddWithValue("@profile", emp.profile);
cmd1.Parameters.AddWithValue("@photo", emp.photo);
cmd1.Parameters.AddWithValue("@jdate", emp.joinedDate);
cmd1.ExecuteNonQuery();
temp1 = true;
}
catch (Exception ew)
{
throw;
}
if (temp1 == true)
{
return(true);
}
else
{
return(false);
}
}
public bool updateMonthly_service(monthly_services ms)
{
bool temp = false;
try
{
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
string q = "update tbl_services set service_type=@type,monthly_charge=@mrate,day=@day,start_time=@stime,end_time=@etime,cordinator=@cordi where service_name=@name";
SqlCommand cmd = new SqlCommand(q, con.getConnection());
cmd.Parameters.AddWithValue("@name", ms.service_name);
cmd.Parameters.AddWithValue("@type", ms.service_type);
cmd.Parameters.AddWithValue("@mrate", ms.monthly_charge);
cmd.Parameters.AddWithValue("@day", ms.day);
cmd.Parameters.AddWithValue("@stime", ms.start_time);
cmd.Parameters.AddWithValue("@etime", ms.end_time);
cmd.Parameters.AddWithValue("@cordi", ms.cordinator);
cmd.ExecuteNonQuery();
temp = true;
con.closeConnection();
}
catch (Exception fd)
{
throw;
}
if (temp == true)
{
return(true);
}
else
{
return(false);
}
}
public bool update_Equipments(Buisness_Logic.repairablerable_Items prd)
{
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
bool temp = false;
try
{
string qry1 = "update tbl_inventory set name=@name,make=@make,model=@model,price=@price,photo=@photo where invID=@id";
SqlCommand cmd = new SqlCommand(qry1, con.getConnection());
cmd.Parameters.AddWithValue("@name", prd.name);
cmd.Parameters.AddWithValue("@make", prd.make);
cmd.Parameters.AddWithValue("@model", prd.model);
cmd.Parameters.AddWithValue("@price", prd.price);
cmd.Parameters.AddWithValue("@photo", prd.photo);
cmd.Parameters.AddWithValue("@id", prd.invID);
cmd.ExecuteNonQuery();
temp = true;
con.closeConnection();
}
catch (Exception dsa)
{
throw;
}
if (temp == true)
{
return(true);
}
else
{
return(false);
}
}
public bool updateProduct(Buisness_Logic.product prd)
{
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
bool temp = false;
try
{
string qry = "update tbl_product set name=@name,make=@make,p_type=@type,qty=@qty,buying_price=@bp,selling_price=@sp,photo=@photo where productID=@pid";
SqlCommand cmd = new SqlCommand(qry, con.getConnection());
cmd.Parameters.AddWithValue("@name", prd.name);
cmd.Parameters.AddWithValue("@make", prd.make);
cmd.Parameters.AddWithValue("@type", prd.productType);
cmd.Parameters.AddWithValue("@qty", prd.qty);
cmd.Parameters.AddWithValue("@bp", prd.buying_price);
cmd.Parameters.AddWithValue("@sp", prd.selling_Price);
cmd.Parameters.AddWithValue("@photo", prd.photo);
cmd.Parameters.AddWithValue("@pid", prd.productID);
cmd.ExecuteNonQuery();
temp = true;
}
catch (Exception dsa)
{
throw;
}
if (temp == true)
{
return(true);
}
else
{
return(false);
}
}
//update workout exercise list
public bool updateWorkouts_ex_list(Buisness_Logic.workout wo1)
{
bool temp = false;
try
{
DataLayer.dbConnect mydb = new DataLayer.dbConnect();
mydb.openConnection();
SqlCommand cmd = null;
string qry = "UPDATE tbl_workout_exercise SET repeats=@r where ex_name=@ex and w_name=@wname";
cmd = new SqlCommand(qry, mydb.getConnection());
cmd.Parameters.AddWithValue("@r", wo1.repeats);
cmd.Parameters.AddWithValue("@ex", wo1.exName);
cmd.Parameters.AddWithValue("@wname", wo1.workout_name);
cmd.ExecuteNonQuery();
temp = true;
}
catch (Exception exr)
{
throw;
}
if (temp == true)
{
return(true);
}
else
{
return(false);
}
}
public bool addEndTime(Buisness_Logic.empAttendence eat)
{
bool temp3 = false;
try
{
DataLayer.dbConnect con3 = new DataLayer.dbConnect();
con3.openConnection();
string q3 = "UPDATE tbl_emp_attendence SET end_time=@et, hours_worked=@hw ,extra_hours=@eh where theDay=@day and empid=@eid";
SqlCommand cmd3 = new SqlCommand(q3, con3.getConnection());
cmd3.Parameters.AddWithValue("@day", eat.theDay);
cmd3.Parameters.AddWithValue("@eid", eat.empID);
cmd3.Parameters.AddWithValue("@et", eat.endTime);
cmd3.Parameters.AddWithValue("@hw", eat.hoursWorked);
cmd3.Parameters.AddWithValue("@eh", eat.extraHours);
cmd3.ExecuteNonQuery();
temp3 = true;
}
catch (Exception euid)
{
throw;
}
if (temp3 == true)
{
return(true);
}
else
{
return(false);
}
}
public bool deleteEmployee(int emp)
{
bool tempdel = false;
DataLayer.dbConnect cond = new DataLayer.dbConnect();
cond.openConnection();
try
{
string qd = "DELETE tbl_employee WHERE empID=@mem ";
SqlCommand cmdel = new SqlCommand(qd, cond.getConnection());
cmdel.Parameters.AddWithValue("@mem", emp);
cmdel.ExecuteNonQuery();
cond.closeConnection();
tempdel = true;
}
catch (Exception edel)
{
throw;
}
if (tempdel == true)
{
return(true);
}
else
{
return(false);
}
}
// add exercises to given workout
public bool addExercises_to_workout(Buisness_Logic.workout wo)
{
bool temp = false;
try
{
DataLayer.dbConnect con1 = new DataLayer.dbConnect();
con1.openConnection();
string q1 = "INSERT INTO tbl_workout_exercise values (@name,@ex_name,@rep)";
SqlCommand cmd1 = new SqlCommand(q1, con1.getConnection());
cmd1.Parameters.AddWithValue("@name", wo.workout_name);
cmd1.Parameters.AddWithValue("@ex_name", wo.exName);
cmd1.Parameters.AddWithValue("@rep", wo.repeats);
cmd1.ExecuteNonQuery();
temp = true;
}
catch (Exception fs)
{
throw;
}
if (temp == true)
{
return(true);
}
else
{
return(false);
}
}
//user accounts
public DataTable search_users()
{
try
{
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
string q = "select * from tbl_userLogin";
SqlCommand cmd = new SqlCommand(q, con.getConnection());
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
catch (Exception fd)
{
throw;
}
}
public bool addExercise()
{
try
{
DataLayer.dbConnect myDb = new DataLayer.dbConnect();
myDb.openConnection();
string qry = ("INSERT INTO tbl_exercise VALUES (@a,@b,@type,@equi,@add)");
SqlCommand cmd = new SqlCommand(qry, myDb.getConnection());
cmd.Parameters.AddWithValue("@a", name);
cmd.Parameters.AddWithValue("@b", description);
cmd.Parameters.AddWithValue("@type", type);
cmd.Parameters.AddWithValue("@equi", equipment);
cmd.Parameters.AddWithValue("@add", additional_equipment);
cmd.ExecuteNonQuery();
myDb.closeConnection();
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
throw;
}
}
// public fee calcFee_aerobic()
public DataTable search_aerobic_fee_for_data_grid()
{
DataTable dt = new DataTable();
try
{
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
string q = "select * from view_aerobic_mem_Fee";
SqlCommand cmd = new SqlCommand(q, con.getConnection());
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
}
catch (Exception ffg)
{
throw;
}
return(dt);
}
public bool add_users()
{
bool temp = false;
try
{
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
string q = "insert into tbl_userLogin values (@uname,@pwd,@emp,@type)";
SqlCommand cmd = new SqlCommand(q, con.getConnection());
cmd.Parameters.AddWithValue("@uname", username);
cmd.Parameters.AddWithValue("@pwd", pwd);
cmd.Parameters.AddWithValue("@type", user_type);
cmd.Parameters.AddWithValue("@emp", emp.empID);
cmd.ExecuteNonQuery();
con.closeConnection();
temp = true;
}
catch (Exception fsd)
{
throw;
}
if (temp == true)
{
return(true);
}
else
{
return(false);
}
}
