public DataSet SearchSession(BusinessObject.HrPart objbohr) { SqlCommand cmd = new SqlCommand("select technology,sdate,country,state,city,location,devc,topic,timnig from session where sid='" + objbohr.sessionid + "'", con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet i = new DataSet(); da.Fill(i); 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 DeleteSession(BusinessObject.HrPart objbohr) { if (con.State == ConnectionState.Open) { con.Close(); } con.Open(); SqlCommand cmd = new SqlCommand("delete from session where sid='" + objbohr.sessionid + "'", con); int i = cmd.ExecuteNonQuery(); con.Close(); return(i); }
public DataSet SearchSession(BusinessObject.HrPart objbohr) { DataSet i = objdalhr.SearchSession(objbohr); 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 DeleteSession(BusinessObject.HrPart objbohr) { int i = objdalhr.DeleteSession(objbohr); return(i); }