Example #1
0
        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);
        }
Example #2
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);
        }
Example #3
0
        public int InsertDept(BusinessObject.Department objbodept)
        {
            con.Open();
            SqlCommand cmd = new SqlCommand("pro_Departmentadd", con);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@deptname", objbodept.DeptName);
            int i = cmd.ExecuteNonQuery();

            return(i);
        }
Example #4
0
        public int  DeleteDept(BusinessObject.Department objbodept)
        {
            con.Open();
            SqlCommand cmd = new SqlCommand("pro_deleteDept", con);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@deptid", objbodept.Deptid);
            int i = cmd.ExecuteNonQuery();

            con.Close();
            return(i);
        }
Example #5
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);
        }
Example #6
0
        public int ADDDesignation(BusinessObject.Designation objbodeg, BusinessObject.Department objbodept)
        {
            int i = objdaldeg.ADDDesignation(objbodeg, objbodept);

            return(i);
        }
Example #7
0
        public int UpdateDepartment(BusinessObject.Department objbodept)
        {
            int i = objdaldept.UpdateDepartment(objbodept);

            return(i);
        }
Example #8
0
        public int InsertDept(BusinessObject.Department objbodept)
        {
            int i = objdaldept.InsertDept(objbodept);

            return(i);
        }