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