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