public static BasicEntity MenuList(Model.MenuList data, Output.MenuList obj) { var retVal = new BasicEntity(); retVal.AddParameter("@page", data.Page); retVal.AddParameter("@page_size", data.PageSize); retVal.AddParameter("@first_name", data.FirstName); retVal.AddParameter("@last_name", data.LastName); retVal.AddParameter("@email", data.Email); retVal.AddParameter("@department_id", data.DepartmentID); retVal.AddParameter("@jobtitle_id", data.JobTitleID); data.SqlDetail = retVal.SQLCommandBuilder("spMenuList"); using (SqlDataReader reader = retVal.ExecReader()) { while (reader.Read()) { obj.ResultCode = (reader.IsDBNull(0)) ? 0 : reader.GetInt32(0); obj.ErrorMessage = (reader.IsDBNull(1)) ? string.Empty : reader.GetString(1); retVal.ResultCode = obj.ResultCode; } if (retVal.ResultCode == 1) { reader.NextResult(); while (reader.Read()) { obj.Content.TotalRows = (reader.IsDBNull(0)) ? 0 : reader.GetInt32(0); } reader.NextResult(); while (reader.Read()) { var item = new Output.MenuListData(); item.ID = (reader.IsDBNull(0)) ? 0 : reader.GetInt64(0); item.FirstName = (reader.IsDBNull(1)) ? string.Empty : reader.GetString(1); item.LastName = (reader.IsDBNull(2)) ? string.Empty : reader.GetString(2); item.Email = (reader.IsDBNull(3)) ? string.Empty : reader.GetString(3); item.DepartmentName = (reader.IsDBNull(4)) ? string.Empty : reader.GetString(4); item.JobTitleName = (reader.IsDBNull(5)) ? string.Empty : reader.GetString(5); item.HireDate = (reader.IsDBNull(6)) ? DateTime.MinValue : reader.GetDateTime(6); item.Gender = (reader.IsDBNull(7)) ? string.Empty : reader.GetString(7); item.PlaceOfBirth = (reader.IsDBNull(8)) ? string.Empty : reader.GetString(8); item.DateOfBirth = (reader.IsDBNull(9)) ? DateTime.MinValue : reader.GetDateTime(9); item.Address = (reader.IsDBNull(10)) ? string.Empty : reader.GetString(10); item.Phone = (reader.IsDBNull(11)) ? string.Empty : reader.GetString(11); item.NIK = (reader.IsDBNull(12)) ? string.Empty : reader.GetString(12); item.DepartmentID = (reader.IsDBNull(13)) ? 0 : reader.GetInt32(13); item.JobTitleID = (reader.IsDBNull(14)) ? 0 : reader.GetInt32(14); obj.Content.Data.Add(item); } } reader.Close(); } retVal.Close(); return(retVal); }