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); } }
private void btnupdate_i6_Click(object sender, EventArgs e) { try { Buisness_Logic.repair rep = new Buisness_Logic.repair(); double cost_for_repair = string.IsNullOrWhiteSpace(txtI1_icost.Text) ? 0 : double.Parse(txtI1_icost.Text); rep.repID = int.Parse(txtI1_irepair.Text); rep.equipmentID = int.Parse(txtI1_icod.Text); rep.status = cmbRepairINV.SelectedItem.ToString(); rep.cost = cost_for_repair; rep.descriptioin = txtI1_idescription.Text; rep.start_date = txtI1_istart.Text; rep.finished_date = txti_repfdate.Text; rep.equipmentName = txtI1_imachine.Text; if (rep.updateRepItemDetails(rep)) { MessageBox.Show("Record update successfull.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Record update failed.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception sdfas) { throw; } }
private void btnsearch_i5_Click(object sender, EventArgs e) { try { Buisness_Logic.repair rep = new Buisness_Logic.repair(); bool x = rep.searchRepairItem((string.IsNullOrEmpty(txtI1_irepair.Text) ? 0 : int.Parse(txtI1_irepair.Text)), (string.IsNullOrEmpty(txtI1_icod.Text) ? 0 : int.Parse(txtI1_icod.Text)), rep); if (x) { MessageBox.Show("Record found.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); txtI1_imachine.Text = rep.equipmentName; txtI1_irepair.Text = rep.repID.ToString(); txtI1_icod.Text = rep.equipmentID.ToString(); txtI1_istart.Text = rep.start_date; txtI1_idescription.Text = rep.descriptioin; txtI1_icost.Text = rep.cost.ToString(); txti_repfdate.Text = rep.finished_date; cmbRepairINV.SelectedItem = rep.status; } else { MessageBox.Show("No record found.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception sfsdf) { throw; } }
private void btnRepairs_addfrom_Click(object sender, EventArgs e) { DialogResult conform = MessageBox.Show("Are you sure you want add this item to repair?", "Information", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (conform == DialogResult.Yes) { try { Buisness_Logic.repair rep = new Buisness_Logic.repair(); rep.equipmentID = int.Parse(txtEqui_code.Text); rep.equipmentName = txtEqui_name.Text; rep.start_date = DateTime.Now.ToShortDateString(); if (rep.addToRepair(rep)) { MessageBox.Show("Equipment is to be repaired.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Failed.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception repex) { 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 updateRepItemDetails(Buisness_Logic.repair rep) { DataLayer.dbConnect con = new DataLayer.dbConnect(); con.openConnection(); bool temp = false; try { string qr = "update tbl_repair set status=@status,cost=@cost,description=@des,start_date=@sd,finished_date=@fd where repairID=@rid"; SqlCommand cmd = new SqlCommand(qr, con.getConnection()); cmd.Parameters.AddWithValue("@status", rep.status); cmd.Parameters.AddWithValue("@cost", rep.cost); cmd.Parameters.AddWithValue("@des", rep.descriptioin); cmd.Parameters.AddWithValue("@sd", rep.start_date); cmd.Parameters.AddWithValue("@fd", rep.finished_date); cmd.Parameters.AddWithValue("@rid", rep.repID); cmd.ExecuteNonQuery(); temp = true; } catch (Exception fsd) { throw; } if (temp == true) { return(true); } else { return(false); } }