Ejemplo n.º 1
0
        public DataSet Bindcity(BusinessObject.state objbostate)
        {
            SqlCommand     cmd = new SqlCommand("select cid,cname from city where sid='" + objbostate.stateid + "'", con);
            SqlDataAdapter da  = new SqlDataAdapter(cmd);
            DataSet        ds  = new DataSet();

            da.Fill(ds);
            return(ds);
        }
Ejemplo n.º 2
0
        public int Updatestate(BusinessObject.state objbostate)
        {
            con.Open();
            SqlCommand cmd = new SqlCommand("pro_updateState", con);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@sname", objbostate.statename);
            cmd.Parameters.AddWithValue("@sid", objbostate.stateid);
            int i = cmd.ExecuteNonQuery();

            return(i);
        }
Ejemplo n.º 3
0
        public int AddState(BusinessObject.state objbostate, BusinessObject.Country objbocounrty)
        {
            con.Open();
            SqlCommand cmd = new SqlCommand("pro_stateautoidadd ", con);

            cmd.CommandType = CommandType.StoredProcedure;
            // cmd.Parameters.AddWithValue("@sid", objbostate.stateid);
            cmd.Parameters.AddWithValue("@sname", objbostate.statename);
            cmd.Parameters.AddWithValue("@coid", objbocounrty.CountryId);
            int i = cmd.ExecuteNonQuery();

            return(i);
        }
Ejemplo n.º 4
0
        public int AddCity(BusinessObject.City objbocity, BusinessObject.state objbostate, BusinessObject.Country objbocountry)
        {
            con.Open();
            SqlCommand cmd = new SqlCommand("pro_addcity", con);

            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.AddWithValue("@cityname", objbocity.cityname);
            cmd.Parameters.AddWithValue("@sid", objbostate.stateid);
            cmd.Parameters.AddWithValue("@coid", objbocountry.CountryId);
            int i = cmd.ExecuteNonQuery();

            con.Close();
            return(i);
        }
Ejemplo n.º 5
0
        public int Updatestate(BusinessObject.state objbostate)
        {
            int i = objdalstate.Updatestate(objbostate);

            return(i);
        }
Ejemplo n.º 6
0
        public int Deletestate(BusinessObject.state objbostate)
        {
            int i = objdalstate.DeleteState(objbostate);

            return(i);
        }
Ejemplo n.º 7
0
        public int AddState(BusinessObject.state objbostate, BusinessObject.Country objbocountry)
        {
            int i = objdalstate.AddState(objbostate, objbocountry);

            return(i);
        }
Ejemplo n.º 8
0
        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);
        }
Ejemplo n.º 9
0
        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);
        }
Ejemplo n.º 10
0
        public DataSet Bindcity(BusinessObject.state objbostate)
        {
            DataSet ds = objdalemp.Bindcity(objbostate);

            return(ds);
        }
Ejemplo n.º 11
0
        public int Updatecity(BusinessObject.City objbocity, BusinessObject.Country objbocountry, BusinessObject.state objbostate)
        {
            int i = objdalcity.Updatecity(objbocity, objbocountry, objbostate);

            return(i);
        }
Ejemplo n.º 12
0
        public int AddCity(BusinessObject.City objbocity, BusinessObject.state objbostate, BusinessObject.Country objbocountry)
        {
            int i = objdalcity.AddCity(objbocity, objbostate, objbocountry);

            return(i);
        }
Ejemplo n.º 13
0
        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);
        }
Ejemplo n.º 14
0
        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);
        }
Ejemplo n.º 15
0
        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);
        }