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