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); } }