public int image_update(staff_bal obj)
{
int j = 0;
try
{
if (con.State == ConnectionState.Closed)
con.Open();
SqlCommand cmd = new SqlCommand("Proc_image", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Image_id", SqlDbType.NVarChar).Value = obj.Staff_id;
cmd.Parameters.Add("@photo", SqlDbType.Image).Value = obj.Img;
j = cmd.ExecuteNonQuery();
// MessageBox.Show("Image Save Successfully!!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
return j;
}
catch (Exception ex)
{
return j;
}
finally
{
if (con.State == ConnectionState.Open)
con.Close();
}
}
private void bind_grid()
{
staff_bal obj=new staff_bal();
DataTable dt = new DataTable();
dt = obj.Staff_all();
GridView1.DataSource = dt;
GridView1.DataBind();
}
public int Staff_add(staff_bal obj_staffbal)
{
cmd = new SqlCommand("Proc_Staff_ADD", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@staff_id", obj_staffbal.Staff_id);
cmd.Parameters.AddWithValue("@first_name", obj_staffbal.First_name);
cmd.Parameters.AddWithValue("@middle_name", null);
cmd.Parameters.AddWithValue("@last_name", obj_staffbal.Last_name);
cmd.Parameters.AddWithValue("@gender", obj_staffbal.Gender);
cmd.Parameters.AddWithValue("@dob", obj_staffbal.Dob);
cmd.Parameters.AddWithValue("@dataofjoining", obj_staffbal.Date_of_join);
cmd.Parameters.AddWithValue("@mobile1", obj_staffbal.Mob1);
cmd.Parameters.AddWithValue("@mobile2", obj_staffbal.Mob2);
cmd.Parameters.AddWithValue("@qualification", obj_staffbal.Qualification);
cmd.Parameters.AddWithValue("@address", obj_staffbal.Address);
cmd.Parameters.AddWithValue("@pincode", obj_staffbal.Pin_code);
cmd.Parameters.AddWithValue("@Status", obj_staffbal.Status);
cmd.Parameters.AddWithValue("@salary", obj_staffbal.Salary);
cmd.Parameters.AddWithValue("@subject", obj_staffbal.Subject);
cmd.Parameters.AddWithValue("@type", obj_staffbal.Type);
cmd.Parameters.AddWithValue("@operation", "insert");
try
{
con.Open();
int i = cmd.ExecuteNonQuery();
return i;
}
catch (Exception ex)
{
string s = ex.Message.ToString();
// MessageBox.Show(s);
return 0;
}
finally
{
con.Close();
}
}
public DataTable Staff_search(staff_bal obj_staffbal)
{
cmd = new SqlCommand("Proc_Search_Staff", con);
cmd.Parameters.AddWithValue("@id", obj_staffbal.Staff_id);
cmd.CommandType = CommandType.StoredProcedure;
try
{
adp = new SqlDataAdapter(cmd);
dt = new DataTable();
adp.Fill(dt);
return dt;
}
catch (Exception ex)
{
string s = ex.Message.ToString();
// MessageBox.Show(s);
return dt;
}
finally
{
con.Close();
}
}
public DataTable Staff_All(staff_bal obj_staffbal)
{
try
{
adp = new SqlDataAdapter("select * from Staff_Details",con );
dt = new DataTable();
adp.Fill(dt);
return dt;
}
catch (Exception ex)
{
string s = ex.Message.ToString();
// MessageBox.Show(s);
return dt;
}
finally
{
con.Close();
}
}