public DataSet Binddevolpementcen(BusinessObject.Location objboloc)
{
SqlCommand cmd = new SqlCommand("select devid,devname from DevelopmentCenter where lid='" + objboloc.LocationId + "'", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
return(ds);
}
public int DeleteLoc(BusinessObject.Location objboloc)
{
con.Open();
SqlCommand cmd = new SqlCommand("pro_toDeleteLoc", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@locid", objboloc.LocationId);
int i = cmd.ExecuteNonQuery();
con.Close();
return(i);
}
public int AddLocation(BusinessObject.Location objboloc, BusinessObject.City objbocity)
{
con.Open();
SqlCommand cmd = new SqlCommand("pro_ADDlocation", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@locname", objboloc.LocationName);
cmd.Parameters.AddWithValue("@cityid", objbocity.cityid);
int i = cmd.ExecuteNonQuery();
con.Close();
return(i);
}
public int AddDevCenture(BusinessObject.DevolopementCenture objbodevc, BusinessObject.Location objboloc)
{
con.Open();
SqlCommand cmd = new SqlCommand("pro_AddindevCenture", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@devcname", objbodevc.Devcname);
cmd.Parameters.AddWithValue("@locid", objboloc.LocationId);
int i = cmd.ExecuteNonQuery();
con.Close();
return(i);
}
public int UpdateSession(BusinessObject.HrPart objbohr, BusinessObject.Technology objbotech, BusinessObject.Country objbocountry, BusinessObject.state objbostate, BusinessObject.City objbocity, BusinessObject.Location objboloc, BusinessObject.DevolopementCenture objbodevc)
{
int i = objdalhr.UpdateSession(objbohr, objbotech, objbocountry, objbostate, objbocity, objboloc, objbodevc);
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 DataSet binddevcen(BusinessObject.Location objboloc)
{
DataSet ds = objdalemp.Binddevolpementcen(objboloc);
return(ds);
}
public int AddDevCenture(BusinessObject.DevolopementCenture objbodevc, BusinessObject.Location objboloc)
{
int i = objdaldevc.AddDevCenture(objbodevc, objboloc);
return(i);
}
public int UpdateLocation(BusinessObject.Location objboloc, BusinessObject.City objbocity)
{
int i = objdallocation.UpdateLocation(objboloc, objbocity);
return(i);
}
public int DeleteLoc(BusinessObject.Location objboloc)
{
int i = objdallocation.DeleteLoc(objboloc);
return(i);
}
public int UpdateSession(BusinessObject.HrPart objbhr, BusinessObject.Technology objbotech, BusinessObject.Country objbocountry, BusinessObject.state objbostate, BusinessObject.City objbocity, BusinessObject.Location objboloc, BusinessObject.DevolopementCenture objbodevc)
{
con.Open();
SqlCommand cmd = new SqlCommand("Update session set technology='" + objbotech.techid + "', sdate='" + objbhr.sdate + "',country='" + objbocountry.CountryId + "',state='" + objbostate.stateid + "',city='" + objbocity.cityid + "',location='" + objboloc.LocationId + "',devc='" + objbodevc.Devcid + "',topic='" + objbhr.topic + "',timnig='" + objbhr.timing + "' where sesid='" + objbhr.sessionid + "'", con);
int i = cmd.ExecuteNonQuery();
con.Close();
return(i);
}
public int addsessiondetails(BusinessObject.HrPart objbhr, BusinessObject.Technology objbotech, BusinessObject.Country objbocountry, BusinessObject.state objbostate, BusinessObject.City objbocity, BusinessObject.Location objboloc, BusinessObject.DevolopementCenture objbodevc)
{
con.Open();
string q = "insert into addsessiondetails values('" + objbhr.sessionid + "','" + objbotech.techid + "','" + objbhr.sdate + "','" + objbocountry.CountryId + "','" + objbostate.stateid + "','" + objbocity.cityid + "','" + objboloc.LocationId + "','" + objbodevc.Devcid + "','" + objbhr.topic + "','" + objbhr.timing + "')";
SqlCommand cmd = new SqlCommand(q, 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);
}
