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);
}
}
private void gdgfdgaetg_Click(object sender, EventArgs e)
{
if (validate_sales())
{
try
{
int year = int.Parse(txtsalesyear.Text);
string month = cmbFin2_month.SelectedItem.ToString();
double incm = double.Parse(txtFin2_income.Text);
double rev = double.Parse(txtFin2_revenue.Text);
double expen = double.Parse(txtFin2_expense.Text);
string q = "insert into sales_finance values(@y,@m,@a,@e,@r)";
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
SqlCommand cmd = new SqlCommand(q, con.getConnection());
cmd.Parameters.AddWithValue("@y", year);
cmd.Parameters.AddWithValue("@m", month);
cmd.Parameters.AddWithValue("@a", incm);
cmd.Parameters.AddWithValue("@e", expen);
cmd.Parameters.AddWithValue("@r", rev);
cmd.ExecuteNonQuery();
MessageBox.Show("Succesfull", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception fdf)
{
throw;
}
}
}
private void btnFitness_savetodb_Click(object sender, EventArgs e)
{
if (validatefitness_Year())
{
try
{
int year = int.Parse(txtFin_fitYear.Text);
string month = cmbFin1_month.SelectedItem.ToString();
double amount = double.Parse(txtFin1_income.Text);
string q = "insert into gym_income values(@y,@m,@a)";
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
SqlCommand cmd = new SqlCommand(q, con.getConnection());
cmd.Parameters.AddWithValue("@y", year);
cmd.Parameters.AddWithValue("@m", month);
cmd.Parameters.AddWithValue("@a", amount);
cmd.ExecuteNonQuery();
MessageBox.Show("Succesfull", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception fdf)
{
throw;
}
}
}
public DataTable editGymMembers()
{
try
{
DataLayer.dbConnect condg = new DataLayer.dbConnect();
condg.openConnection();
string qdg1 = "select m.regNo as 'MemberID' , m.name as 'Name' , m.dob as 'DOB' , m.address as 'Address' ,"
+ " m.nic as 'NIC' , m.gender as 'Gender' , m.phone as 'Phone' , g.email as 'E-mail', "
+ "g.joined_date as 'Joined Date' , g.BMI , g.height as 'Height' , g.weight as 'Weight' , "
+ " g.payment_plan as 'Payment Plan' , g.fat_level as 'Fat Level', g.photo as 'p' FROM tbl_member m ,tbl_gymMember g "
+ "WHERE m.regNo=g.memberID";
SqlCommand cmddg1 = new SqlCommand(qdg1, condg.getConnection());
SqlDataAdapter dadg1 = new SqlDataAdapter(cmddg1);
DataTable dtdg1 = new DataTable();
dadg1.Fill(dtdg1);
return(dtdg1);
}
catch (Exception el)
{
throw;
}
}
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 DataTable search_aerobic_fee(int memberID, string nic)
{
DataTable dt = new DataTable();
try
{
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
string q = "select * from view_aerobic_mem_Fee where memberID=@mid or nic=@nic";
SqlCommand cmd = new SqlCommand(q, con.getConnection());
cmd.Parameters.AddWithValue("@mid", memberID);
cmd.Parameters.AddWithValue("@nic", nic);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
}
catch (Exception ffg)
{
throw;
}
return(dt);
}
private void btnFin3_check_Click(object sender, EventArgs e)
{
if (validate_os())
{
try
{
int year = int.Parse(txtos_year.Text);
string month = cmbFin3Month.SelectedItem.ToString();
double incm = double.Parse(txtFin3_income.Text);
string type = cmbFin3_serviceType.SelectedItem.ToString();
string q = "insert into other_sevieces_income values(@y,@m,@a,@p)";
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
SqlCommand cmd = new SqlCommand(q, con.getConnection());
cmd.Parameters.AddWithValue("@y", year);
cmd.Parameters.AddWithValue("@m", month);
cmd.Parameters.AddWithValue("@a", incm);
cmd.Parameters.AddWithValue("@p", incm);
cmd.ExecuteNonQuery();
MessageBox.Show("Succesfull", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception fdf)
{
throw;
}
}
}
public bool deleteProduct(int id)
{
bool temp = false;
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
try
{
string qd = "delete tbl_product where productID=@id";
SqlCommand cmd = new SqlCommand(qd, con.getConnection());
cmd.Parameters.AddWithValue("@id", id);
cmd.ExecuteNonQuery();
temp = true;
}
catch (Exception ui)
{
throw;
}
if (temp == true)
{
return(true);
}
else
{
return(false);
}
}
public DataTable searchEqui_Items()
{
// Buisness_Logic.product prd = new Buisness_Logic.product();
bool temp = false;
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
DataTable dt = new DataTable();
try
{
string qr = "select * from view_repairItemsSet";
SqlCommand cmd = new SqlCommand(qr, con.getConnection());
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
}
catch (Exception pt)
{
throw;
}
return(dt);
}
public DataTable searchEMP_for_datagrid()
{
DataTable dtq = new DataTable();
try
{
DataLayer.dbConnect dbemp_seach = new DataLayer.dbConnect();
dbemp_seach.openConnection();
string query1 = "SELECT * FROM tbl_employee ";
SqlCommand cmd1 = new SqlCommand(query1, dbemp_seach.getConnection());
SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
da1.Fill(dtq);
}
catch (Exception ert)
{
throw;
}
return(dtq);
}
public DataTable getPaymentPendingList()
{
try
{
DataLayer.dbConnect conrep1 = new DataLayer.dbConnect();
conrep1.openConnection();
string qrep1 = "SELECT * FROM vw_paymentPending";
SqlCommand cmdrep1 = new SqlCommand(qrep1, conrep1.getConnection());
SqlDataAdapter darep1 = new SqlDataAdapter(cmdrep1);
DataTable dtrep1 = new DataTable();
darep1.Fill(dtrep1);
return(dtrep1);
}
catch (Exception erep)
{
throw;
}
}
public bool addOtherMembers_Exist(Buisness_Logic.AreobicMember am)
{
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
bool temp1 = false;
try
{
string q2 = "INSERT INTO tbl_areobic_member VALUES (@memid, @stype)";
SqlCommand cmd2 = new SqlCommand(q2, con.getConnection());
cmd2.Parameters.AddWithValue("@memid", am.MemberID);
cmd2.Parameters.AddWithValue("@stype", am.service_type);
cmd2.ExecuteNonQuery();
temp1 = true;
}
catch (Exception exareo1)
{
throw;
}
if (temp1 == true)
{
return(true);
}
else
{
return(false);
}
}
private void btnFin5_Add_Click(object sender, EventArgs e)
{
if (validate_expenxe())
{
try
{
string date = dateTimePickerMem.Value.ToString();
string name = cmbFin5_expenseType.SelectedItem.ToString();
double amount = double.Parse(txtFin5_amount.Text);
string q = "insert into tbl_expences (name,date,amount) values(@n,@d,@a)";
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
SqlCommand cmd = new SqlCommand(q, con.getConnection());
cmd.Parameters.AddWithValue("@d", date);
cmd.Parameters.AddWithValue("@a", amount);
cmd.Parameters.AddWithValue("@n", name);
cmd.ExecuteNonQuery();
MessageBox.Show("Succesfull", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception fdf)
{
throw;
}
}
}
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 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);
}
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 bool addToRepair(Buisness_Logic.repair rep)
{
bool temp = false;
try
{
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
string q = "Insert into tbl_repair (start_date,repairalble_itemID,equi_name) values (@sdate,@id,@name)";
SqlCommand cmd = new SqlCommand(q, con.getConnection());
cmd.Parameters.AddWithValue("@sdate", rep.start_date);
cmd.Parameters.AddWithValue("@id", rep.equipmentID);
cmd.Parameters.AddWithValue("@name", rep.equipmentName);
cmd.ExecuteNonQuery();
temp = true;
}
catch (Exception dfsd)
{
throw;
}
if (temp == true)
{
return(true);
}
else
{
return(false);
}
}
public bool addFee(fee f, gymMember g)
{
try
{
paymentCalculation(f, g);
DataLayer.dbConnect dbfee = new DataLayer.dbConnect();
dbfee.openConnection();
string qf1 = "insert into tbl_fee (amount,service,valde_date,paid_date,paid_time,memberID) values(@amount,@service,@valid_date,@paid_date,@paidTime,@memerID)";
SqlCommand cmd1 = new SqlCommand(qf1, dbfee.getConnection());
cmd1.Parameters.AddWithValue("@amount", f.newAmount);
cmd1.Parameters.AddWithValue("@service", f.service);
cmd1.Parameters.AddWithValue("@valid_date", f.PaymentvalidDate);
cmd1.Parameters.AddWithValue("@paid_date", f.paidDate);
cmd1.Parameters.AddWithValue("@memerID", f.memberID);
cmd1.Parameters.AddWithValue("@paidTime", f.paidTime);
cmd1.ExecuteNonQuery();
return(true);
}
catch (Exception ext)
{
MessageBox.Show(ext.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
throw;
}
}
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 calculate_salaryl(int month, int year, int empid, salary sq)
{
bool t1 = false;
try
{
double total_hours, total_extraHours;
double rate_h, rate_extra;
double s1, s2, salary;
DataLayer.dbConnect con = new DataLayer.dbConnect();
con.openConnection();
string q = "select sum(hours_worked) as 'h' , sum(extra_hours) as 'e' from tbl_emp_attendence where datepart(yy,theDay)=@y and DATEPART(mm,theDay)=@m";
SqlCommand cmd = new SqlCommand(q, con.getConnection());
cmd.Parameters.AddWithValue("@y", year);
cmd.Parameters.AddWithValue("@m", year);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
rate_extra = 200.00;
rate_h = 150.00;
if (dt.Rows.Count == 1)
{
total_hours = (double)dt.Rows[0]["h"];
total_extraHours = (double)dt.Rows[0]["e"];
s1 = total_hours * rate_h;
s2 = total_extraHours * rate_extra;
salary = s1 + s2;
t1 = true;
sq.ot = s2;
sq.originalsala = s2;
sq.tot_hours = total_hours;
sq.extr_hours = total_extraHours;
}
}
catch (Exception gfg)
{
throw;
}
if (t1 == 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 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 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 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);
}
}
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);
}
}
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;
}