internal DataTable DL_GetQtyDetails(PL_QryEmp plobj)
{
try
{
con = Connection.SetConnection();
cmd = new SqlCommand("SpQueryEmp", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", plobj.Ind);
cmd.Parameters.AddWithValue("@FirstName", plobj.FirstName);
cmd.Parameters.AddWithValue("@FHName", plobj.FHName);
cmd.Parameters.AddWithValue("@EmpNo", plobj.EmpNo);
cmd.Parameters.AddWithValue("@DeptCd1", plobj.DeptCd);
cmd.Parameters.AddWithValue("@SrNo", plobj.SrNo);
cmd.Parameters.AddWithValue("@Dob", plobj.Dob);
cmd.Parameters.AddWithValue("@Designation", plobj.DesignationCD);
cmd.Parameters.AddWithValue("@SubSrNo", plobj.SubSrNo);
cmd.Parameters.AddWithValue("@CityCode", plobj.CityCode);
cmd.Parameters.AddWithValue("@Month", plobj.month);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return(dt);
}
catch { return(dt); }
finally
{
con.Close();
con.Dispose();
}
}
public DataTable Get_QtyDetails(PL_QryEmp plobj)
{
DL_QryEmp objdl = new DL_QryEmp();
DataTable dt = new DataTable();
if (plobj.Ind == 0)
{
return(dt);
}
else
{
dt = objdl.DL_GetQtyDetails(plobj);
return(dt);
}
}