public Worker_Info View_Worker(int wrkr_id)
{
con.Open();
SqlCommand cmd = new SqlCommand("view_worker", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p = new SqlParameter();
p = cmd.Parameters.Add("@worker_id", SqlDbType.Int);
p.Value = wrkr_id;
SqlDataReader read = cmd.ExecuteReader();
Worker_Info w_inf = new Worker_Info();
read.Read();
if (read.HasRows)
{
w_inf.Worker_Name = read["worker_name"].ToString();
w_inf.Worker_Photo = read["worker_photo"].ToString();
w_inf.Work_Category = read["work_category"].ToString();
w_inf.Adress = read["worker_adress"].ToString();
w_inf.Licence_No = read["license_no"].ToString();
}
else
{
w_inf.Worker_Name = "1000";// to represent empty DataBase.
}
read.Close();
con.Close();
return(w_inf);
}
public void Update_Worker(Worker_Info wrkr_id)
{
con.Open();
SqlCommand cmd = new SqlCommand("update_workers", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p = new SqlParameter();
p = cmd.Parameters.Add("@worker_id", SqlDbType.Int);
p.Value = wrkr_id.Worker_Id;
p = cmd.Parameters.Add("@worker_name", SqlDbType.VarChar);
p.Value = wrkr_id.Worker_Name;
p = cmd.Parameters.Add("@work_category", SqlDbType.VarChar);
p.Value = wrkr_id.Work_Category;
p = cmd.Parameters.Add("@worker_adress", SqlDbType.VarChar);
p.Value = wrkr_id.Adress;
p = cmd.Parameters.Add("@worker_photo", SqlDbType.VarChar);
p.Value = wrkr_id.Worker_Photo;
p = cmd.Parameters.Add("@license_no", SqlDbType.VarChar);
p.Value = wrkr_id.Licence_No;
cmd.ExecuteNonQuery();
con.Close();
}
protected void Btnsubmit_Click(object sender, EventArgs e)
{
string dest = "";
bool flag = true;
txttype.Visible = true;
Worker_Info w_info = new Worker_Info();
Worker_Sp w_sp = new Worker_Sp();
w_info.Worker_Name = txtname.Text;
w_info.Work_Category = txttype.SelectedValue;
w_info.Licence_No = txtid.Text;
w_info.Adress = txtaddress.Text;
string imagepath = "";
Boolean fileOK = false;
String path = Server.MapPath("~/Photos/workers/");
if (FileUpload1.HasFile)
{
String fileExtension = System.IO.Path.GetExtension(FileUpload1.FileName).ToLower();
String[] allowedExtensions =
{ ".gif", ".png", ".jpeg", ".jpg" };
for (int i = 0; i < allowedExtensions.Length; i++)
{
if (fileExtension == allowedExtensions[i])
{
fileOK = true;
}
}
}
if (fileOK)
{
try
{
imagepath = path + FileUpload1.FileName;
FileUpload1.PostedFile.SaveAs(imagepath);
FileInfo f = new FileInfo(imagepath);
dest = new Worker_Sp().GetMaxCode() + "." + f.Name.Split('.')[1];
if (flag == true)
{
f.CopyTo(path + dest);
w_info.Worker_Photo = dest;
w_sp.Add_Worker(w_info);
GridView1.DataBind();
MultiView1.SetActiveView(View1);
}
f = new FileInfo(imagepath);
f.Delete();
}
catch (Exception ex)
{
lbfile.Text = "File could not be uploaded!!.";
lbfile.Visible = true;
}
}
else
{
lbfile.Text = "Cannot accept files of this type!!.";
lbfile.Visible = true;
}
}
