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