void Load_() { var d = string.Empty; var index = 0; var allDetails = new User_details_view().getAllRecords(); foreach (var person in allDetails) { index++; var age = (Math.Floor((DateTime.Now - DateTime.Parse(person.Dob)).TotalSeconds / 31556952)).ToString(); d += Table(index.ToString(), enc.EncryptString(person.Id, SV.LoginKey), person.Name, IfEmpty(person.Contact), age, person.User_type, IfEmpty(person.Speciality)); } UserLiteral.Text = d; }
private void LoadAppointment(string appId) { Session["appid"] = appId; var apps = new Project_Dll.Appointment(appId); //var patientDetails = new User_details_view().Load_record_with(User_details_view_support.Column.Id, User_details_view_support.LogicalOperator.EQUAL_TO, apps.Patient_id); var patientDetails = new User_details_view().getAllRecords().Where(u => u.Id == apps.Patient_id).FirstOrDefault(); //var doctor = new Doctor_view().Load_record_with(Doctor_view_support.Column.Id, Doctor_view_support.LogicalOperator.EQUAL_TO, apps.Doctor_id); var doctor = new Doctor_view().getAllRecords().Where(d => d.Id == apps.Doctor_id).FirstOrDefault(); var date = DateTime.Parse(apps.Schedule_date + " " + (apps.Set_time + ":00")); AppointmentLiteral.Text = $"{date.Year}/{date.Month}/{date.Day}/{date.Hour}/A{appId}/D{doctor.Id}"; name.InnerText = patientDetails.Name; desc.InnerText = apps.Descritpion; address.InnerText = patientDetails.Address; dTime.InnerText = $"{date.ToLongDateString()} { apps.Set_time}"; }