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