public static dal GetInstance()
{
if (objdal == null)
{
objdal = new dal();
}
return(objdal);
}
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);
}
}
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);
}
}