예제 #1
0
 public static dal GetInstance()
 {
     if (objdal == null)
     {
         objdal = new dal();
     }
     return(objdal);
 }
예제 #2
0
        public DataSet GetEmpDatabyID()
        {
            str = "EXEC Employee_REG @Type='3',@ID='" + EmpID + "'";
            dal d = dal.GetInstance();

            ds = d.GetDataSet(str);
            if (ds != null)
            {
                return(ds);
            }
            else
            {
                return(null);
            }
        }
예제 #3
0
        public DataSet UpdateEmpData()
        {
            str = "EXEC Employee_REG @Type='4',@ID='" + EmpID + "',@Name='" + name
                  + "',@Address='" + Address + "',@City='" + City
                  + "',@DateofBirth='" + DateofBirth + "',@Age='" + Age
                  + "',@PhoneNumber='" + PhoneNumber + "',@Department='" + Department
                  + "',@Manager='" + Manager + "',@DateofJoining='" + DateofJoining
                  + "',@DateofLeaving='" + DateofLeaving + "'";
            dal d = dal.GetInstance();

            ds = d.GetDataSet(str);
            if (ds != null)
            {
                return(ds);
            }
            else
            {
                return(null);
            }
        }