public ActionResult Create(allahmed inter)
{
User u = Getcurrentuser();
Domain.Entities.Intervention App = new Domain.Entities.Intervention()
{
Description = inter.myintervention.Description,
idU = u.Id
};
MyService.Add(App);
MyService.Commit();
return(RedirectToAction("DoctorProfile", "Calender"));
}
public ActionResult DoctorProfile()
{
Models.Entities.User u = Getcurrentuser();
SqlConnection conn = new SqlConnection("Data Source=(LocalDb)\\MSSQLLocalDB;Initial Catalog=EpionneDb;Persist Security Info=True;User ID=;Password="******"Data Source = ; AttachDbFilename =| DataDirectory |\aspnet - Epione.Presentation - 20181027124435.mdf; Initial Catalog = Epione; Integrated Security = True providerName=System.Data.SqlClient");
conn.Open();
SqlCommand command = new SqlCommand("Select * from [Users] where id=@zip", conn);
//SqlCommand command = new SqlCommand("Select id from [Users] where name=@zip", conn);
command.Parameters.AddWithValue("@zip", u.Id);
Doctor D = new Models.Entities.Doctor();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
int Id = Int32.Parse(String.Format("{0}", reader["Id"]));
string name = String.Format("{0}", reader["firstName"]);
string Adress = String.Format("{0}", reader["Address"]);
string Email = String.Format("{0}", reader["Email"]);
string Lname = String.Format("{0}", reader["lastName"]);
string imagePath = String.Format("{0}", reader["imagePath"]);
D = new Doctor {
Id = Id, firstName = name, Address = Adress, Email = Email, lastName = Lname, imagePath = imagePath
};
}
reader.NextResult();
}
conn.Close();
conn.Open();
List <Intervention> Linter = new List <Intervention>();
SqlCommand command2 = new SqlCommand("Select * from [Interventions] where idU=@zip", conn);
//SqlCommand command = new SqlCommand("Select id from [Users] where name=@zip", conn);
command2.Parameters.AddWithValue("@zip", u.Id);
using (SqlDataReader reader = command2.ExecuteReader())
{
while (reader.Read())
{
int Id = Int32.Parse(String.Format("{0}", reader["interventionId"]));
string name = String.Format("{0}", reader["Description"]);
Intervention Int = new Intervention {
Description = name, interventionId = Id
};
Linter.Add(Int);
}
reader.NextResult();
}
conn.Close();
allahmed ahmed = new allahmed {
mydoctor = D, interventionList = Linter
};
return(View(ahmed));
}
