public async Task <hospital> createhospital(hospital hospital1)
{
HttpClient client = new HttpClient();
client.BaseAddress = new Uri("http://slamtk1.somee.com/api/odata/HospitalsGet");
var json = JsonConvert.SerializeObject(hospital1);
var content = new StringContent(json, Encoding.UTF8, "application/json");
HttpRequestMessage h = new HttpRequestMessage();
h.Content = content;
h.Method = HttpMethod.Post;
h.RequestUri = client.BaseAddress;
HttpResponseMessage response = await client.SendAsync(h);
if (response.IsSuccessStatusCode)
{
var response1 = await response.Content.ReadAsStringAsync();
var result = JsonConvert.DeserializeObject <hospital>(response1);
return(result);
}
else
{
hospital hs2 = new hospital()
{
ID = 0,
};
return(hs2);
}
}
public ActionResult Create([Bind(Include = "hos_id,hos_name,hos_eng_name,hos_address,hos_phone,hos_display,c_id,d_id")] hospital hospital, int?cityId)
{
//var c = db.hospital.Count();
//string id;
//id = New_Hos_id(c);
if (ModelState.IsValid)
{
//hospital = new hospital() { hos_id = id };
db.hospital.Add(hospital);
db.SaveChanges();
if (cityId == null)
{
return(RedirectToAction("Index"));
}
return(RedirectToAction("Index", new { cityId = cityId }));
}
//var c = db.hospital.Count();
//string id;
//id = New_Hos_id(c);
//ViewBag.hos_id = id;
ViewBag.cityname = new SelectList(db.city.Where(m => m.c_id == cityId), "c_id", "city_name");
ViewBag.d_id = new SelectList(db.district.Where(m => m.c_id == cityId), "d_id", "district_name");
return(View(hospital));
}
public ActionResult Create([Bind(Include = "hospitalId,name,dateCreated,dateUpdated,editedBy")] hospital hospital)
{
user account = db.users.Find(UserAccount.GetUserID());
if (account.role.title == "Database Adminstrator" || account.role.title == "Instructor")
{
if (ModelState.IsValid)
{
hospital.date_added = DateTime.Now;
hospital.date_edited = DateTime.Now;
hospital.edited_by = 1;
db.hospitals.Add(hospital);
db.SaveChanges();
logger.Info("User " + account.firstName + " " + account.lastName + " created hospital: " + hospital.name);
return(RedirectToAction("Index"));
}
return(View(hospital));
}
else
{
logger.Info("User " + account.firstName + " " + account.lastName + " tried to create hospital: " + hospital.name);
return(RedirectToAction("tempError", "Home"));
}
}
public static hospital FindHospitalByName(string hospitalName)
{
hospital result = null;
try
{
if (hospitalList == null || hospitalList.Count() == 0)
{
if (LoadHospitalList() == false)
{
ncLog.Error("FindHospitalByName::Unable to load Hospital");
return(result);
}
}
result = hospitalList.Where(x => x.recurso_nombre == hospitalName).FirstOrDefault();
if (result == null)
{
result = new hospital();
result.recurso_nombre = hospitalName;
}
}
catch (Exception exp)
{
ncLog.Exception("FindHospitalByName::" + exp.Message);
}
return(result);
}
public ActionResult DeleteConfirmed(int id)
{
hospital hospital = db.hospitals.Find(id);
db.hospitals.Remove(hospital);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "id,hospitalName")] hospital hospital)
{
if (ModelState.IsValid)
{
db.Entry(hospital).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(hospital));
}
public bool UpdateHospital(int hospitalId, hospital hospital)
{
var hospitalToUpdate = _hospitals.FirstOrDefault(h => h.Id == hospitalId);
if (hospitalToUpdate == null)
{
return(false);
}
_hospitals[_hospitals.IndexOf(hospitalToUpdate)] = hospital;
return(true);
}
public ActionResult Create([Bind(Include = "id,hospitalName")] hospital hospital)
{
if (ModelState.IsValid)
{
db.hospitals.Add(hospital);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(hospital));
}
public ActionResult HospitalQuestions(int HospitalID)
{
using (MedicalEntities db = new MedicalEntities())
{
hospital thisHospital = db.hospitals.Where(x => x.id == HospitalID).FirstOrDefault();
if (thisHospital == null || thisHospital.id == 0)
{
return(RedirectToAction("hospital"));
}
return(View(thisHospital));
}
}
public static string GetHospitalName(int HospitalID)
{
using (MedicalEntities db = new MedicalEntities())
{
hospital thisHospital = db.hospitals.Where(x => x.id == HospitalID).FirstOrDefault();
if (thisHospital == null || thisHospital.id == 0)
{
return("");
}
return(thisHospital.name);
}
}
public ActionResult Edit([Bind(Include = "hos_id,hos_name,hos_eng_name,hos_address,hos_phone,hos_display,c_id,d_id")] hospital hospital, int cityname)
{
if (ModelState.IsValid)
{
db.Entry(hospital).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", new { cityname = cityname }));
}
ViewBag.c_id = new SelectList(db.city, "c_id", "city_name", hospital.c_id);
ViewBag.d_id = new SelectList(db.district, "d_id", "district_name", hospital.d_id);
return(View(hospital));
}
private async void AddClicked(object sender, EventArgs e)
{
hospital info = await vm1.AddHospital(vm1.Name, vm1.City);
if (info.ID != 0)
{
await Navigation.PushAsync(new RateHospitalPage());
}
else
{
messageLabel.Text = "الرجاء التأكد من أسم المستخدم وكلمة المرور";
}
}
// GET: hospital/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
hospital hospital = db.hospitals.Find(id);
if (hospital == null)
{
return(HttpNotFound());
}
return(View(hospital));
}
public JsonResult UpdateHospital_List(string lines)
{
try
{
var ListOfHospitals = JsonConvert.DeserializeObject <List <HospitalInput> >(lines);
using (MedicalEntities db = new MedicalEntities())
{
foreach (HospitalInput HospitalValues in ListOfHospitals)
{
if (!(db.hospitals.Any(t => t.id == HospitalValues.id)))
{
//add new hospital
hospital NewHospital = new hospital();
NewHospital.name = HospitalValues.name;
NewHospital.active = HospitalValues.active;
NewHospital.created_on = DateTime.Now;
db.hospitals.Add(NewHospital);
}
else
{
hospital existingHospital = db.hospitals.Where(t => t.id == HospitalValues.id).FirstOrDefault();
bool SomethingChanged = false;
if (existingHospital.name != HospitalValues.name || existingHospital.active != HospitalValues.active)
{
SomethingChanged = true;
}
existingHospital.name = HospitalValues.name;
existingHospital.active = HospitalValues.active;
if (SomethingChanged)
{
db.Entry(existingHospital).State = System.Data.Entity.EntityState.Modified;
}
}
}
db.SaveChanges();
}
return(Json(new { }));
}
catch (Exception e)
{
log.Error(e);
log.Error(lines);
throw e;
}
}
public async Task <hospital> AddHospital(string Name, string City)
{
DataService service = new DataService();
hospital hs = new Model.hospital();
hs.Name = Name;
hs.City = City;
hospital hos = await service.createhospital(hs);
if (hos.ID != 0)
{
Application.Current.Properties["hosid"] = hos.ID;
Application.Current.Properties["hosname"] = hos.Name;
Application.Current.Properties["hoscity"] = hos.City;
}
return(hos);
}
// GET: Hospitals/Edit/5
public ActionResult Edit(string id, int cityname)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
hospital hospital = db.hospital.Find(id);
if (hospital == null)
{
return(HttpNotFound());
}
ViewBag.citynameID = cityname;
ViewBag.c_id = new SelectList(db.city, "c_id", "city_name", hospital.c_id);
ViewBag.d_id = new SelectList(db.district, "d_id", "district_name", hospital.d_id);
return(View(hospital));
}
public ActionResult DeleteConfirmed(int id)
{
hospital hospital = db.hospitals.Find(id);
user account = db.users.Find(UserAccount.GetUserID());
if (account.role.title == "Database Adminstrator" || account.role.title == "Instructor")
{
db.hospitals.Remove(hospital);
db.SaveChanges();
logger.Info("User " + account.firstName + " " + account.lastName + " deleted hospital: " + hospital.name);
return(RedirectToAction("Index"));
}
else
{
logger.Info("User " + account.firstName + " " + account.lastName + " tried to delete hospital: " + hospital.name);
return(RedirectToAction("tempError", "Home"));
}
}
public ActionResult Edit([Bind(Include = "hospitalId,name,dateCreated,dateUpdated,editedBy")] hospital hospital)
{
user account = db.users.Find(UserAccount.GetUserID());
if (account.role.title == "Database Adminstrator" || account.role.title == "Instructor")
{
if (ModelState.IsValid)
{
db.Entry(hospital).State = EntityState.Modified;
db.SaveChanges();
logger.Info("User " + account.firstName + " " + account.lastName + " edited hospital: " + hospital.name);
return(RedirectToAction("Index"));
}
return(View(hospital));
}
else
{
logger.Info("User " + account.firstName + " " + account.lastName + " tried to edit hospital: " + hospital.name);
return(RedirectToAction("tempError", "Home"));
}
}
// GET: hospitals/Details/5
public ActionResult Details(int?id)
{
user account = db.users.Find(UserAccount.GetUserID());
if (account.role.title != "Data Entry")
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
hospital hospital = db.hospitals.Find(id);
if (hospital == null)
{
return(HttpNotFound());
}
return(View(hospital));
}
else
{
return(RedirectToAction("tempError", "Home"));
}
}
// GET: hospitals/Edit/5
public ActionResult Edit(int?id)
{
user account = db.users.Find(UserAccount.GetUserID());
if (account.role.title == "Database Adminstrator" || account.role.title == "Instructor")
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
hospital hospital = db.hospitals.Find(id);
if (hospital == null)
{
return(HttpNotFound());
}
return(View(hospital));
}
else
{
return(RedirectToAction("tempError", "Home"));
}
}
public ActionResult Pay(int?aid)
{
Random r = new Random();
int key1 = r.Next(0, 999999999);
int key2 = r.Next(0, 999999999);
ViewBag.payNumber = key1.ToString() + key2.ToString();
ViewBag.id = aid;
string uname = Session["user"].ToString();
var userinfo = db.user.FirstOrDefault(o => o.name == uname);
var app = db.appointment.Find(aid);
doctor doc = db.doctor.Find(app.doctor_id);
department dep = db.department.Find(doc.department_id);
hospital hos = db.hospital.Find(dep.hospital_id);
ViewBag.user_name = userinfo.real_name;
ViewBag.doctor_name = doc.name;
ViewBag.hospital_name = hos.name;
ViewBag.time = app.time;
ViewBag.price = app.price;
return(View());
}
private void btLoadHospitales_Click(object sender, EventArgs e)
{
try
{
using (OpenFileDialog openFileDialog = new OpenFileDialog())
{
openFileDialog.Filter = "Excel files (*.xls)|*.xls|All files (*.*)|*.*";
openFileDialog.FilterIndex = 2;
openFileDialog.RestoreDirectory = true;
if (openFileDialog.ShowDialog() == DialogResult.OK)
{
//Get the path of specified file
string filePath = openFileDialog.FileName;
txtHospitales.Text = filePath;
ncLog.Message("ExcelPath:" + filePath);
Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook wb = app.Workbooks.Open(filePath, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing);
Worksheet sheet = (Worksheet)wb.Sheets["HOSPITALES"];
Range excelRange = sheet.UsedRange;
int nRows = excelRange.Rows.Count;
ncLog.Message("Nº Rows:" + nRows);
foreach (Microsoft.Office.Interop.Excel.Range row in excelRange.Rows)
{
int rowNumber = row.Row;
if (rowNumber != 1) //Headers
{
string[] arrayAG = Util.GetRange("A" + rowNumber + ":G" + rowNumber + "", sheet);
hospital newHospital = new hospital(arrayAG);
if (!newHospital.IsOk())
{
ncLog.Error("LoadHospitales::Unable to create USVB object row number:" + rowNumber);
continue;
}
if (IctusDBManager.NewHospital(newHospital))
{
ncLog.Message("LoadHospitales::Inserted row number:" + rowNumber);
}
else
{
ncLog.Message("LoadHospitales::Unable to insert row number:" + rowNumber);
}
}
}
}
}
}
catch (Exception exp)
{
ncLog.Exception("LoadHospitales::" + exp.Message);
}
}
void Awake()
{
hospitals = this;
this.gameObject.SetActive(false);
}
public void AddHospital(hospital hospital)
{
_hospitals.Add(hospital);
}
