public int Updatedeg(BusinessObject.Designation objbodeg)
{
con.Open();
SqlCommand cmd = new SqlCommand("update Designation set degname='" + objbodeg.degname + "' where degid='" + objbodeg.degid + "'", con);
int i = cmd.ExecuteNonQuery();
con.Close();
return(i);
}
public int DeleteDeg(BusinessObject.Designation objbodeg)
{
con.Open();
SqlCommand cmd = new SqlCommand("delete from Designation where degid='" + objbodeg.degid + "'", con);
int i = cmd.ExecuteNonQuery();
con.Close();
return(i);
}
public int ADDDesignation(BusinessObject.Designation objbodeg, BusinessObject.Department objbodept)
{
con.Open();
SqlCommand cmd = new SqlCommand("insert into Designation values('" + objbodeg.degid + "','" + objbodeg.degname + "','" + objbodept.Deptid + "')", con);
int i = cmd.ExecuteNonQuery();
con.Close();
return(i);
}
public int AddempDetails(BusinessObject.Employee objboemp, BusinessObject.Department objbodept,
BusinessObject.Designation objbodeg, BusinessObject.Technology objbotech, BusinessObject.Country objbocountry, BusinessObject.state objbostate, BusinessObject.City objbocity, BusinessObject.Location objboloc, BusinessObject.DevolopementCenture objbodevcen)
{
con.Open();
string query = "insert into empregester values('" + objboemp.empno + "','" + objboemp.empname + "','" + objboemp.gender + "','" + objboemp.salary + "','" + objbodept.Deptid + "','" + objbodeg.degid + "','" + objbotech.techid + "','" + objbocountry.CountryId + "','" + objbostate.stateid + "','" + objbocity.cityid + "','" + objboloc.LocationId + "','" + objbodevcen.Devcid + "') ";
SqlCommand cmd = new SqlCommand(query, con);
int i = cmd.ExecuteNonQuery();
return(i);
}
public int AddempDetails(BusinessObject.Employee objboemp, BusinessObject.Department objbodept, BusinessObject.Designation objbodeg, BusinessObject.Technology objbotech, BusinessObject.Country objbocountry, BusinessObject.state objbostate, BusinessObject.City objbocity, BusinessObject.Location objboloc, BusinessObject.DevolopementCenture objbodevcen)
{
int i = objdalemp.AddempDetails(objboemp, objbodept, objbodeg, objbotech, objbocountry, objbostate, objbocity, objboloc, objbodevcen);
return(i);
}
public int Updatedeg(BusinessObject.Designation objbodeg)
{
int i = objdaldeg.Updatedeg(objbodeg);
return(i);
}
public int DeleteDeg(BusinessObject.Designation objbodeg)
{
int i = objdaldeg.DeleteDeg(objbodeg);
return(i);
}
public int ADDDesignation(BusinessObject.Designation objbodeg, BusinessObject.Department objbodept)
{
int i = objdaldeg.ADDDesignation(objbodeg, objbodept);
return(i);
}