public DataTable searchWorkouts_for_report(string name) { DataTable dtq = new DataTable(); 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", name); SqlDataAdapter da1 = new SqlDataAdapter(cmd1); // workout wrk = new workout(); da1.Fill(dtq); workoutSearch.closeConnection(); } catch (Exception exp) { throw; } return(dtq); }
public DataTable searchWorkouts_for_grid() { DataTable dtq = new DataTable(); try { DataLayer.dbConnect workoutSearch = new DataLayer.dbConnect(); workoutSearch.openConnection(); string query1 = "SELECT * FROM tbl_workout "; SqlCommand cmd1 = new SqlCommand(query1, workoutSearch.getConnection()); SqlDataAdapter da1 = new SqlDataAdapter(cmd1); // workout wrk = new workout(); da1.Fill(dtq); workoutSearch.closeConnection(); } catch (Exception exp) { throw; } return(dtq); }
public DataTable getExercises_from_workoutGrid(string wn) { DataTable dtq = new DataTable(); try { DataLayer.dbConnect workoutSearch = new DataLayer.dbConnect(); workoutSearch.openConnection(); string query1 = "SELECT * FROM tbl_workout_exercise where w_name=@wn "; SqlCommand cmd1 = new SqlCommand(query1, workoutSearch.getConnection()); cmd1.Parameters.AddWithValue("@wn", wn); SqlDataAdapter da1 = new SqlDataAdapter(cmd1); // workout wrk = new workout(); da1.Fill(dtq); workoutSearch.closeConnection(); } catch (Exception exp) { throw; } return(dtq); }
private void database_refresh() { DataLayer.dbConnect con = new DataLayer.dbConnect(); con.openConnection(); string q1 = "select * from tbl_exercise"; SqlCommand cmd = new SqlCommand(q1, con.getConnection()); DataTable dtq = new DataTable(); SqlDataAdapter da1 = new SqlDataAdapter(cmd); comboW5_name.Refresh(); da1.Fill(dtq); if (dtq.Rows.Count > 0) { for (int i = 0; i < dtq.Rows.Count; i++) { comboW5_name.Items.Add(dtq.Rows[i]["name"].ToString()); } } // for dataGridView dataGrid_exercise.DataSource = dtq; this.dataGrid_exercise.Columns[1].Visible = false; con.closeConnection(); }
public bool save_Product(product prod) { bool temp1 = false; try { // Initialize image DataLayer.dbConnect dbp = new DataLayer.dbConnect(); dbp.openConnection(); string query1 = "INSERT INTO tbl_product (name,make ,p_type, qty,buying_price,selling_price,photo) VALUES (@name, @make, @type, @qty,@bprice,@sprice, @photo)"; SqlCommand cmd = new SqlCommand(query1, dbp.getConnection()); cmd.Parameters.AddWithValue("@name", prod.name); cmd.Parameters.AddWithValue("@make", prod.make); cmd.Parameters.AddWithValue("@type", prod.productType); cmd.Parameters.AddWithValue("@qty", prod.qty); cmd.Parameters.AddWithValue("@bprice", prod.buying_price); cmd.Parameters.AddWithValue("@sprice", prod.selling_Price); cmd.Parameters.AddWithValue("@photo", prod.photo); cmd.ExecuteNonQuery(); string q2 = "SELECT productID from tbl_product where name=@name "; SqlCommand cmd2 = new SqlCommand(q2, dbp.getConnection()); cmd2.Parameters.AddWithValue("@name", prod.name); SqlDataReader dr = cmd2.ExecuteReader(); while (dr.Read()) { prod.productID = (int)dr["productID"]; } dr.Close(); dbp.closeConnection(); temp1 = true; } catch (Exception exprep) { MessageBox.Show(exprep.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); throw; } if (temp1 == true) { return(true); } else { return(false); } }
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 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 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 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 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 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 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); } }
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 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); } }
public bool UpdateHourly_service(hourly_services ms) { bool temp = false; try { DataLayer.dbConnect con = new DataLayer.dbConnect(); con.openConnection(); string q = "update tbl_services set service_type=@type,hourly_rate=@rate 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("@rate", ms.hourly_rate); cmd.ExecuteNonQuery(); temp = true; con.closeConnection(); } catch (Exception fd) { throw; } if (temp == true) { return(true); } else { return(false); } }
public bool save(gymMember mem) { DataLayer.dbConnect newdbcon = new DataLayer.dbConnect(); newdbcon.openConnection(); SqlTransaction trans = newdbcon.getConnection().BeginTransaction(); bool status = false, temp = true; try { string qt1 = "select * from tbl_member where name=@name and nic=@nic"; SqlCommand qt = new SqlCommand(qt1, newdbcon.getConnection()); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(qt); qt.Parameters.AddWithValue("@name", mem.name); qt.Parameters.AddWithValue("@nic", mem.nic); qt.Transaction = trans; da.Fill(dt); if (dt.Rows.Count > 0) { temp = false; } if (temp == true) { SqlCommand cmdt = null; // query 1 string query1 = "INSERT INTO tbl_member (name, dob, address,nic,gender, phone) VALUES (@name,@dob,@address,@nic,@gender,@phone)"; //initialize sqlCommand cmdt = new SqlCommand(query1, newdbcon.getConnection()); // add values to command using parameters cmdt.Parameters.AddWithValue("@name", mem.name); cmdt.Parameters.AddWithValue("@dob", mem.dob); cmdt.Parameters.AddWithValue("@address", mem.addresss); cmdt.Parameters.AddWithValue("@gender", mem.gender); cmdt.Parameters.AddWithValue("@phone", mem.phone); cmdt.Parameters.AddWithValue("@nic", mem.nic); cmdt.Transaction = trans; cmdt.ExecuteNonQuery(); string query2 = "SELECT regNo from tbl_member where name=@memName and nic=@nic"; SqlCommand cmdt1 = new SqlCommand(query2, newdbcon.getConnection()); cmdt1.Parameters.AddWithValue("@memName", mem.name); cmdt1.Parameters.AddWithValue("@nic", mem.nic); cmdt1.Transaction = trans; SqlDataReader dr = cmdt1.ExecuteReader(); while (dr.Read()) { mem.MemberID = (int)dr["regNo"]; } dr.Close(); string query3 = "INSERT INTO tbl_gymMember values (@regno,@email,@joinedDate,@bmi,@height,@weight,@payplan,@photo,@fatLevel)"; SqlCommand cmdt2 = new SqlCommand(query3, newdbcon.getConnection()); cmdt2.Parameters.AddWithValue("@regno", mem.MemberID); cmdt2.Parameters.AddWithValue("@email", mem.email); cmdt2.Parameters.AddWithValue("@joinedDate", mem.joinedDate); cmdt2.Parameters.AddWithValue("@bmi", mem.BMIratio); cmdt2.Parameters.AddWithValue("@height", mem.height); cmdt2.Parameters.AddWithValue("@weight", mem.weight); cmdt2.Parameters.AddWithValue("@payplan", mem.paymentPlan); cmdt2.Parameters.AddWithValue("@photo", mem.photo); cmdt2.Parameters.AddWithValue("@fatLevel", mem.fatLevel); cmdt2.Transaction = trans; cmdt2.ExecuteNonQuery(); trans.Commit(); newdbcon.closeConnection(); status = true; } else { MessageBox.Show("This member already exists.", "Infromation", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ep) { trans.Rollback(); MessageBox.Show(ep.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (status == true) { return(true); } else { return(false); } }
public gymMember search(int reNo, string name, string nic) { try { DataLayer.dbConnect dbmem_seach = new DataLayer.dbConnect(); dbmem_seach.openConnection(); bool temp = false; string query1 = "SELECT * FROM tbl_member WHERE regNo=@reg OR name=@name OR nic=@nic"; SqlCommand cmd1 = new SqlCommand(query1, dbmem_seach.getConnection()); cmd1.Parameters.AddWithValue("@reg", reNo); cmd1.Parameters.AddWithValue("@name", name); cmd1.Parameters.AddWithValue("@nic", nic); // SqlDataReader dr1 = cmd1.ExecuteReader(); DataTable dtq = new DataTable(); SqlDataAdapter da1 = new SqlDataAdapter(cmd1); gymMember gm = new gymMember(); da1.Fill(dtq); //while (dr1.Read()) //{ // gm.MemberID = (int)dr1["regNo"]; // gm.name = dr1["name"].ToString(); // gm.nic = dr1["nic"].ToString(); // gm.dob = dr1["dob"].ToString(); // gm.gender = dr1["gender"].ToString(); // gm.addresss = dr1["address"].ToString(); // gm.phone = (int)dr1["phone"]; //} if (dtq.Rows.Count > 0) { gm.MemberID = int.Parse(dtq.Rows[0]["regNo"].ToString()); gm.name = dtq.Rows[0]["name"].ToString(); gm.nic = dtq.Rows[0]["nic"].ToString(); gm.dob = dtq.Rows[0]["dob"].ToString(); gm.gender = dtq.Rows[0]["gender"].ToString(); gm.addresss = dtq.Rows[0]["address"].ToString(); gm.phone = dtq.Rows[0]["phone"].ToString(); temp = true; } // dr1.Close(); string query2 = "SELECT * FROM tbl_gymMember WHERE memberID=@id"; SqlCommand cmd2 = new SqlCommand(query2, dbmem_seach.getConnection()); SqlDataAdapter da2 = new SqlDataAdapter(cmd2); DataTable dt2 = new DataTable(); cmd2.Parameters.AddWithValue("@id", gm.MemberID); da2.Fill(dt2); bool temp1 = false; // SqlDataReader dr2 = cmd2.ExecuteReader(); //while (dr2.Read()) //{ // gm.email = dr2["email"].ToString(); // gm.paymentPlan = dr2["payment_plan"].ToString(); // gm.joinedDate = dr2["joined_date"].ToString(); // gm.height = (double)dr2["height"]; // gm.weight = (double)dr2["weight"]; // gm.BMIratio = (double)dr2["BMI"]; // gm.fatLevel = (double)dr2["fat_level"]; // gm.photo = (byte[])dr2["photo"]; if (dt2.Rows.Count > 0) { // gm.MemberID = int.Parse(dt2.Rows[0]["regNo"].ToString()); gm.email = dt2.Rows[0]["email"].ToString(); gm.paymentPlan = dt2.Rows[0]["payment_plan"].ToString(); gm.joinedDate = dt2.Rows[0]["joined_date"].ToString(); gm.height = double.Parse(dt2.Rows[0]["height"].ToString()); gm.weight = double.Parse(dt2.Rows[0]["weight"].ToString()); gm.BMIratio = double.Parse(dt2.Rows[0]["BMI"].ToString()); gm.fatLevel = double.Parse(dt2.Rows[0]["fat_level"].ToString()); gm.photo = (byte[])dt2.Rows[0]["photo"]; temp1 = true; } dbmem_seach.closeConnection(); //dr1.Close(); // dbmem_seach.closeConnection(); if (temp == true && temp1 == true) { MessageBox.Show("Record found", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("No record found.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(gm); } catch (Exception er) { throw; } //gm.joinedDate = (string)dr1["joined_date"]; }
public bool deleteAreobicMem(int regNo) { bool temp = false; DataLayer.dbConnect con = new DataLayer.dbConnect(); con.openConnection(); SqlTransaction trn = con.getConnection().BeginTransaction(); try { DataLayer.dbConnect conx = new DataLayer.dbConnect(); conx.openConnection(); //check gym member string q = "select * from tbl_gymMember where memberID=@regNo"; SqlCommand cmd = new SqlCommand(q, conx.getConnection()); cmd.Parameters.AddWithValue("@regNo", regNo); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); string qx = "delete tbl_areobic_member where memberID=@regNo"; da.Fill(dt); if (dt.Rows.Count > 0) { // this means the member is part of fitness center also not only a areobic member SqlCommand cmdx = new SqlCommand(qx, conx.getConnection()); cmdx.Parameters.AddWithValue("@regNo", regNo); cmdx.ExecuteNonQuery(); temp = true; conx.closeConnection(); } else { SqlCommand cmd2 = new SqlCommand(qx, con.getConnection()); cmd2.Parameters.AddWithValue("@regNo", regNo); cmd2.Transaction = trn; cmd2.ExecuteNonQuery(); string q1 = "delete tbl_member where regNo=@regNo"; SqlCommand cmd1 = new SqlCommand(q1, con.getConnection()); cmd1.Parameters.AddWithValue("@regNo", regNo); cmd1.Transaction = trn; cmd1.ExecuteNonQuery(); trn.Commit(); temp = true; } } catch (Exception fds) { trn.Rollback(); throw; } if (temp == true) { return(true); } else { return(false); } }
public bool addNonRepairabItems(nonRepairable_Item nri) { bool test = false; DataLayer.dbConnect dbinv = new DataLayer.dbConnect(); dbinv.openConnection(); SqlTransaction trn1 = dbinv.getConnection().BeginTransaction(); try { string q1 = "INSERT INTO tbl_inventory (name,make,model,price,photo) values (@name,@make,@model,@price,@photo) "; SqlCommand cmd1 = new SqlCommand(q1, dbinv.getConnection()); cmd1.Parameters.AddWithValue("@name", nri.name); cmd1.Parameters.AddWithValue("@make", nri.make); cmd1.Parameters.AddWithValue("@model", nri.model); cmd1.Parameters.AddWithValue("@price", nri.price); cmd1.Parameters.AddWithValue("@photo", nri.photo); cmd1.Transaction = trn1; cmd1.ExecuteNonQuery(); string q2 = "SELECT invID FROM tbl_inventory where name=@name"; SqlCommand cmd2 = new SqlCommand(q2, dbinv.getConnection()); cmd2.Parameters.AddWithValue("@name", nri.name); cmd2.Transaction = trn1; SqlDataAdapter da1 = new SqlDataAdapter(cmd2); DataTable dt1 = new DataTable(); da1.Fill(dt1); if (dt1.Rows.Count > 0) { nri.invID = int.Parse(dt1.Rows[0]["invID"].ToString()); } string q3 = "INSERT INTO tbl_non_repairable values (@invid, @qty, @weight)"; SqlCommand cmd3 = new SqlCommand(q3, dbinv.getConnection()); cmd3.Parameters.AddWithValue("@invid", nri.invID); cmd3.Parameters.AddWithValue("@qty", nri.qty); cmd3.Parameters.AddWithValue("@weight", nri.weight); cmd3.Transaction = trn1; cmd3.ExecuteNonQuery(); trn1.Commit(); dbinv.closeConnection(); test = true; } catch (Exception exinv) { trn1.Rollback(); MessageBox.Show(exinv.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); throw; } if (test == true) { return(true); } else { return(false); } }