public DataSet Bindlocation(BusinessObject.City objbocity) { SqlCommand cmd = new SqlCommand("select lid,locname from location where cityid='" + objbocity.cityid + "'", con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); return(ds); }
public int UpdateLoc(BusinessObject.DevolopementCenture objbodevc, BusinessObject.City objbocity) { con.Open(); SqlCommand cmd = new SqlCommand("update Devlcent set devcname='" + objbodevc.Devcname + "',cityid='" + objbocity.cityid + "'where devcid='" + objbodevc.Devcid + "'", con); int i = cmd.ExecuteNonQuery(); con.Close(); return(i); }
public int Deletecity(BusinessObject.City objbocity) { con.Open(); SqlCommand cmd = new SqlCommand("pro_deletecity", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@cityid", objbocity.cityid); 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 Updatecity(BusinessObject.City objbocity, BusinessObject.Country objbocountry, BusinessObject.state objbostate) { con.Open(); SqlCommand cmd = new SqlCommand("pro_updatecity", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@cityname", objbocity.cityname); cmd.Parameters.AddWithValue("@cityid", objbocity.cityid); 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 Bindlocation(BusinessObject.City objbocity) { DataSet ds = objdalemp.Bindlocation(objbocity); return(ds); }
public int UpdateLoc(BusinessObject.DevolopementCenture objbodevc, BusinessObject.City objbocity) { int i = objdaldevc.UpdateLoc(objbodevc, objbocity); return(i); }
public int UpdateLocation(BusinessObject.Location objboloc, BusinessObject.City objbocity) { int i = objdallocation.UpdateLocation(objboloc, objbocity); return(i); }
public int Updatecity(BusinessObject.City objbocity, BusinessObject.Country objbocountry, BusinessObject.state objbostate) { int i = objdalcity.Updatecity(objbocity, objbocountry, objbostate); return(i); }
public int Deletecity(BusinessObject.City objbocity) { int i = objdalcity.Deletecity(objbocity); return(i); }
public int AddCity(BusinessObject.City objbocity, BusinessObject.state objbostate, BusinessObject.Country objbocountry) { int i = objdalcity.AddCity(objbocity, objbostate, objbocountry); 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); }