public List<TypeOfLeave> LeaveFromGivenMasterLeaveType(int masterLeaveType)
{
DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
DBDataHelper helper = new DBDataHelper();
List<SqlParameter> lstLeaveDetail = new List<SqlParameter>();
string query = "select Id,Name from tblTypeOfLeave where MasterLeaveType=@masterleavetype";
lstLeaveDetail.Add(new SqlParameter("@masterleavetype", masterLeaveType));
DataTable dt = new DataTable();
DataSet ds;
int i = 0;
using (DBDataHelper objDDBDataHelper = new DBDataHelper())
{
ds = objDDBDataHelper.GetDataSet(query, SQLTextType.Query, lstLeaveDetail);
List<TypeOfLeave> lstLeaveType = new List<TypeOfLeave>();
foreach (DataRow rows in ds.Tables[0].Rows)
{
TypeOfLeave objLeaveType = new TypeOfLeave();
objLeaveType.Id = Convert.ToInt32(ds.Tables[0].Rows[i][0]);
objLeaveType.Name = (ds.Tables[0].Rows[i][1]).ToString();
lstLeaveType.Add(objLeaveType);
i++;
}
return lstLeaveType;
}
}
public List <TypeOfLeave> LeaveFromGivenMasterLeaveType(int masterLeaveType)
{
DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
DBDataHelper helper = new DBDataHelper();
List <SqlParameter> lstLeaveDetail = new List <SqlParameter>();
string query = "select Id,Name from tblTypeOfLeave where MasterLeaveType=@masterleavetype";
lstLeaveDetail.Add(new SqlParameter("@masterleavetype", masterLeaveType));
DataTable dt = new DataTable();
DataSet ds;
int i = 0;
using (DBDataHelper objDDBDataHelper = new DBDataHelper())
{
ds = objDDBDataHelper.GetDataSet(query, SQLTextType.Query, lstLeaveDetail);
List <TypeOfLeave> lstLeaveType = new List <TypeOfLeave>();
foreach (DataRow rows in ds.Tables[0].Rows)
{
TypeOfLeave objLeaveType = new TypeOfLeave();
objLeaveType.Id = Convert.ToInt32(ds.Tables[0].Rows[i][0]);
objLeaveType.Name = (ds.Tables[0].Rows[i][1]).ToString();
lstLeaveType.Add(objLeaveType);
i++;
}
return(lstLeaveType);
}
}
