/* * Op=1 Insert Data * Op=2 Update Data * Op=3 Delete Data * Op=4 Read All Data * Op=5 Read Machine Detail By ID * Op=6 Search Machine By Model No*/ //ID, SerialNo, ModelNo, Manufacturer, MachineType,Description,ThesisNumber,EngineNumber,Photo public DataSet MachineMaster(clsMachineMaster obj) { try { connect(); SqlParameter[] param = new SqlParameter[8]; param[0] = new SqlParameter("@ID", obj._ID); param[1] = new SqlParameter("@SerialNo", obj._SerialNo); param[2] = new SqlParameter("@ModelNo", obj._ModelNo); param[3] = new SqlParameter("@Manufacturer", obj._Manufacturer); param[4] = new SqlParameter("@MachineType", obj._MachineType); param[5] = new SqlParameter("@Description", obj._Description); param[6] = new SqlParameter("@Photo", obj._Photo); param[7] = new SqlParameter("@Op", obj._Op); DataSet ds = SqlHelper.ExecuteDataset(co, "procMachineMaster", param); return(ds); } catch { return(null); } finally { co.Close(); } }
void LoadMachines() { clsMachineMaster obj = new clsMachineMaster(); obj.Op = 4; DataTable dt = obj.MachineMaster(obj).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["Photo"] != "") { dt.Rows[i]["Photo"] = "~/" + dt.Rows[i]["Photo"]; } } grdMachine.DataSource = dt; grdMachine.DataBind(); if (grdMachine.Rows.Count > 0) { lblError.Text = ""; } else { lblError.Text = "No Records Found"; } }
protected void btnDelete_Click(object sender, EventArgs e) { clsMachineMaster obj = new clsMachineMaster(); obj.ID = Convert.ToInt32(hdEID.Value); obj.Op = 3; obj.MachineMaster(obj); msg.Text = "<script type='text/javascript'>alert('Deleted');</script>"; }
protected void txtMachine_TextChanged(object sender, EventArgs e) { clsMachineMaster obj = new clsMachineMaster(); obj.ModelNo = txtMachine.Text; obj.Op = 7; DataTable dt = obj.MachineMaster(obj).Tables[0]; grdMachine.DataSource = dt; grdMachine.DataBind(); grdMachine.Visible = true; }
void LoadMachines() { clsMachineMaster obj = new clsMachineMaster(); obj.Op = 4; DataTable dt = obj.MachineMaster(obj).Tables[0]; ddlMachine.DataSource = dt; ddlMachine.DataValueField = "ID"; ddlMachine.DataTextField = "ModelNo"; ddlMachine.DataBind(); ddlEMachine.DataSource = dt; ddlEMachine.DataValueField = "ID"; ddlEMachine.DataTextField = "ModelNo"; ddlEMachine.DataBind(); }
protected void btnUpdate_Click(object sender, EventArgs e) { clsMachineMaster obj = new clsMachineMaster(); obj.ID = Convert.ToInt32(hdEID.Value); obj.SerialNo = txtESerial.Text; obj.ModelNo = txtEModel.Text; obj.Manufacturer = ddlEManufacturer.SelectedItem.Text; obj.MachineType = Convert.ToInt32(ddlEMachineType.SelectedValue); obj.Description = txtEDescription.Text; obj.Photo = UpdateImage(); obj.Op = 2; obj.MachineMaster(obj); pnlUpdate.Visible = false; pnlExisting.Visible = true; LoadMachines(); msg.Text = "<script type='text/javascript'>alert('Updated');</script>"; }
protected void txtMachineName_TextChanged(object sender, EventArgs e) { clsMachineMaster obj = new clsMachineMaster(); obj.ModelNo = txtMachineName.Text; obj.Op = 7; DataTable dt = obj.MachineMaster(obj).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["Photo"] != "") { dt.Rows[i]["Photo"] = "~/" + dt.Rows[i]["Photo"]; } } grdMachine.DataSource = dt; grdMachine.DataBind(); }
protected void grdMachine_RowDeleting(object sender, GridViewDeleteEventArgs e) { HiddenField hdID = (HiddenField)grdMachine.Rows[e.RowIndex].FindControl("hdID"); clsMachineMaster obj = new clsMachineMaster(); obj.ID = Convert.ToInt32(hdID.Value); obj.Op = 5; DataTable dt = obj.MachineMaster(obj).Tables[0]; hdEID.Value = hdID.Value; txtESerial.Text = dt.Rows[0]["SerialNo"].ToString(); txtEModel.Text = dt.Rows[0]["ModelNo"].ToString(); txtEDescription.Text = dt.Rows[0]["Description"].ToString(); ddlEMachineType.SelectedValue = dt.Rows[0]["MachineType"].ToString(); ddlEManufacturer.SelectedItem.Text = dt.Rows[0]["Manufacturer"].ToString(); if (dt.Rows[0]["Photo"].ToString() != "") { imgEPhoto.ImageUrl = "~/" + dt.Rows[0]["Photo"].ToString(); } pnlUpdate.Visible = true; pnlExisting.Visible = false; }