/// <summary>
/// poliklinik kaydı siler
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public GenericResponse <bool> DeletePolyclinic(Polyclinic data)
{
var returnObject = new GenericResponse <Boolean>();
ConnectDB();
var cmd = new SqlCommand(Common.polikliniksil, conSOHATS);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("PoliklinikAdi", data.PoliklinikAdi);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
Common.WriteLog("error", e.Message);
returnObject.Success = false;
returnObject.ErrorMessage = e.Message;
throw;
}
returnObject.Success = true;
endConnectDB();
return(returnObject);
}
public List <Polyclinic> GetPolyclinicList(int departmentId)
{
ConnectionTools.DatabaseOpen(sqlConnection);
SqlCommand sqlCommand = new SqlCommand("SP_GetPolyclinics", sqlConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@DepartmentId", departmentId);
List <Polyclinic> polyclinics = new List <Polyclinic>();
polyclinics.Add(null);
ConnectionTools.DatabaseOpen(sqlConnection);
SqlDataReader dr = sqlCommand.ExecuteReader();
Polyclinic polyclinic = new Polyclinic();
if (dr.HasRows)
{
while (dr.Read())
{
polyclinic.PolyclinicId = Convert.ToInt32(dr["PolyclinicId"].ToString());
polyclinic.PolyclinicName = dr["PolyclinicName"].ToString();
polyclinic.DepartmentId = Convert.ToInt32(dr["DepartmanId"].ToString());
polyclinics.Add(polyclinic);
}
}
sqlConnection.Close();
return(polyclinics);
}
/// <summary>
/// load form
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void AddPolyclinic_Load(object sender, EventArgs e)
{
polyList = new List <Polyclinic>();
selectedData = new Polyclinic();
GetPolyclinicList();
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Name")] Polyclinic polyclinic)
{
if (id != polyclinic.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(polyclinic);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PolyclinicExists(polyclinic.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(polyclinic));
}
public void UpdatePolyclinic(Polyclinic p)
{
Polyclinic updatedPloyclinic = database.Polyclinics.FirstOrDefault(x => x.PolyclinicId == p.PolyclinicId);
database.Entry(updatedPloyclinic).CurrentValues.SetValues(updatedPloyclinic);
database.Entry(updatedPloyclinic).State = EntityState.Modified;
}
public void RemovePolyclinic(Polyclinic p)
{
if (p.PolyclinicId <= 0)
{
MessageBox.Show("Kayıt Silebilmek İçin Bir Kayıt Seçilmelidir..");
}
else
{
var selectedPolyclinic = database.Polyclinics.FirstOrDefault(x => x.PolyclinicId == p.PolyclinicId);
if (selectedPolyclinic == null)
{
MessageBox.Show("Silinebilecek bir kayıt bulunmadı...");
}
else
{
DialogResult dialogResult = MessageBox.Show($"{p.PolyclinicId} Numaralı Kaydı Silmek İstediğinizden Emin Misiniz ?", "Poliklinik Silme İşlemi", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (dialogResult == DialogResult.OK)
{
database.Polyclinics.Remove(selectedPolyclinic);
database.SaveChanges();
}
}
}
}
/// <summary>
/// poliklinik kayıtları getirir
/// </summary>
/// <returns></returns>
public GenericResponse <List <Polyclinic> > SelectPolyclinic()
{
var returnObject = new GenericResponse <List <Polyclinic> >();
ConnectDB();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = Common.CreateProcedureText(Common.polyclinicTable, null, null);
sqlCommand.Connection = conSOHATS;
SqlDataReader dr = sqlCommand.ExecuteReader();
List <Polyclinic> data = new List <Polyclinic>();
Polyclinic pol = new Polyclinic();
while (dr.Read())
{
pol = new Polyclinic();
pol.PoliklinikAdi = dr[0].ToString();
pol.Durum = dr[1].ToString();
pol.Aciklama = dr[2].ToString();
data.Add(pol);
}
endConnectDB();
returnObject.Value = data;
returnObject.Success = true;
return(returnObject);
}
/// <summary>
/// manuel isim girildiğinde
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmb_policlinic_TextChanged(object sender, EventArgs e)
{
if (selectedData != null)
{
selectedData = new Polyclinic();
}
SetButtonToSave();
}
public bool AddPolyclinic(Polyclinic polyclinic)
{
if (polyclinic.PolyclinicName.Length > 100)
{
return(false);
}
return(polyclinicManagement.AddPolyclinic(polyclinic));
}
/// <summary>
/// seçili poliklinik değiştiğinde çalışır.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmb_policlinic_SelectedIndexChanged(object sender, EventArgs e)
{
ComboBox cmb = (ComboBox)sender;
if (polyList.Contains((cmb.SelectedItem as Polyclinic)))
{
selectedData = (Polyclinic)cmb.SelectedItem;
SetButtonToUpdate();
}
}
public async Task <IActionResult> Create([Bind("Id,Name")] Polyclinic polyclinic)
{
if (ModelState.IsValid)
{
_context.Add(polyclinic);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(polyclinic));
}
/// <summary>
/// создание
/// </summary>
/// <returns>пустой объект с заданными начальными параметрами</returns>
public ActionResult Create()
{
var view = new Polyclinic
{
IsActive = true
};
var model = Mapper.Map <Polyclinic, PolyclinicModel>(view);
return(View(model));
}
public bool AddPolyclinic(Polyclinic p)
{
try
{
database.Polyclinics.Add(p);
database.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public async Task <IHttpActionResult> Get(int id)
{
try
{
Polyclinic polyclinic = await this.PolyclinicService.GetPolyclinicAsync(id);
return(this.Ok(polyclinic));
}
catch (Exception e)
{
return(new HttpActionResult(this, HttpStatusCode.BadRequest, e.Message));
}
}
private void btnInsert_Click(object sender, EventArgs e)
{
string polyclinicName = cbxPoliclinic.Text;
string doctorName = cbxDoctor.Text;
if (cbxPoliclinic.SelectedIndex != -1 && cbxDoctor.SelectedIndex != -1 && cbxAction.SelectedIndex != -1 && txtPrice.Text != "")
{
Polyclinic policlinic = PolyclinicManager.Get(polyclinicName);
Doctor doctor = DoctorManager.Get(doctorName);
PatientManager.AddAction(patient, policlinic, doctor, nupOrder.Value, cbxAction.Text, nupQuantity.Value, txtPrice.Text);
MessageBox.Show("Action successfully added!", "Success!", MessageBoxButtons.OK, MessageBoxIcon.Information);
refreshActions();
}
}
public async Task <IHttpActionResult> Post([FromBody] Polyclinic polyclinic)
{
try
{
if (polyclinic == null)
{
throw new ArgumentNullException($"{nameof(polyclinic)} must be not null");
}
int id = await this.PolyclinicService.InsertOrUpdatePolyclinicAsync(polyclinic);
return(this.Ok(id));
}
catch (Exception e)
{
return(new HttpActionResult(this, HttpStatusCode.BadRequest, e.Message));
}
}
private void button1_Click(object sender, EventArgs e)
{
string polyclinicName = cbxPolyclinics.Text;
if (polyclinicName != "")
{
if (PolyclinicManager.Check(polyclinicName)) // Poliklinik var mı diye kontrol et
{
// Varsa, düzenleme formu
changeVisible(true); // formu görünür yap
poly = PolyclinicManager.Get(polyclinicName); // Veritabanından o polikliniği getir
txtDesc.Text = poly.description;
chkStatus.Checked = poly.status;
}
else
{
// Yoksa, oluşturma formu
txtDesc.Text = ""; // Formu eski hale getir
chkStatus.Checked = true; // Formu eski hale getir
changeVisible(true); // formu görünür yap
PolyclinicManager.Create(cbxPolyclinics.Text);
// Combobox'ı yenile
cbxPolyclinics.Items.Clear();
foreach (Polyclinic polyclinic in PolyclinicManager.All())
{
cbxPolyclinics.Items.Add(polyclinic.name);
}
// Düzenlenen poliklinik olarak yeni eklenen polikliniği seç
poly = PolyclinicManager.Get(polyclinicName);
refreshPolyclinics(); // Combobox'ı güncelle
}
}
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.Entity <ApplicationUserRole>(userRole =>
{
userRole.HasKey(ur => new { ur.UserId, ur.RoleId });
userRole.HasOne(ur => ur.Role)
.WithMany(r => r.UserRoles)
.HasForeignKey(ur => ur.RoleId)
.IsRequired();
userRole.HasOne(ur => ur.User)
.WithMany(r => r.UserRoles)
.HasForeignKey(ur => ur.UserId)
.IsRequired();
});
modelBuilder.Entity <ApplicationUser>(b =>
{
// Each User can have many entries in the UserRole join table
b.HasMany(e => e.UserRoles)
.WithOne(e => e.User)
.HasForeignKey(ur => ur.UserId)
.IsRequired();
});
modelBuilder.Entity <ApplicationRole>(b =>
{
// Each Role can have many entries in the UserRole join table
b.HasMany(e => e.UserRoles)
.WithOne(e => e.Role)
.HasForeignKey(ur => ur.RoleId)
.IsRequired();
});
var r1 = new ApplicationRole {
Id = 1, Name = "Admin", NormalizedName = "ADMIN"
};
var r2 = new ApplicationRole {
Id = 2, Name = "Doctor", NormalizedName = "DOCTOR"
};
var r3 = new ApplicationRole {
Id = 3, Name = "Secretary", NormalizedName = "SECRETARY"
};
var r4 = new ApplicationRole {
Id = 4, Name = "Patient", NormalizedName = "PATIENT"
};
modelBuilder.Entity <ApplicationRole>().HasData(r1, r2, r3, r4);
var user = new ApplicationUser();
var hasher = new PasswordHasher <ApplicationUser>();
var u1 = new ApplicationUser {
Id = 1, FirstName = "Admin", LastName = "Admin", FullName = "Admin Admin", BirthDate = new DateTime(1955, 1, 1), UserName = "******", SecurityStamp = Guid.NewGuid().ToString(), NormalizedEmail = "*****@*****.**", Email = "*****@*****.**", EmailConfirmed = true, NormalizedUserName = "******", PasswordHash = hasher.HashPassword(user, "a.A123"), PhoneNumber = "5325321234"
};
var u2 = new ApplicationUser {
Id = 2, FirstName = "Rıfat", LastName = "Yaşar", FullName = "Rıfat Yaşar", BirthDate = new DateTime(1955, 1, 1), UserName = "******", SecurityStamp = Guid.NewGuid().ToString(), NormalizedEmail = "*****@*****.**", Email = "*****@*****.**", EmailConfirmed = true, NormalizedUserName = "******", PasswordHash = hasher.HashPassword(user, "a.A123"), PhoneNumber = "5325321234"
};
var u3 = new ApplicationUser {
Id = 3, FirstName = "Ayşe", LastName = "Gül", FullName = "Ayşe Gül", BirthDate = new DateTime(1955, 1, 1), UserName = "******", SecurityStamp = Guid.NewGuid().ToString(), NormalizedEmail = "*****@*****.**", Email = "*****@*****.**", EmailConfirmed = true, NormalizedUserName = "******", PasswordHash = hasher.HashPassword(user, "a.A123"), PhoneNumber = "5325321234"
};
var u4 = new ApplicationUser {
Id = 4, FirstName = "Osman", LastName = "Oduncu", FullName = "Osman Oduncu", BirthDate = new DateTime(1955, 1, 1), UserName = "******", SecurityStamp = Guid.NewGuid().ToString(), NormalizedEmail = "*****@*****.**", Email = "*****@*****.**", EmailConfirmed = true, NormalizedUserName = "******", PasswordHash = hasher.HashPassword(user, "a.A123"), PhoneNumber = "5325321234"
};
modelBuilder.Entity <ApplicationUser>().HasData(u1, u2, u3, u4);
modelBuilder.Entity <ApplicationUserRole>().HasData(
new ApplicationUserRole {
UserId = u1.Id, RoleId = r1.Id
},
new ApplicationUserRole {
UserId = u2.Id, RoleId = r2.Id
},
new ApplicationUserRole {
UserId = u3.Id, RoleId = r3.Id
},
new ApplicationUserRole {
UserId = u4.Id, RoleId = r4.Id
}
);
modelBuilder.Entity <Medication>().HasData(
new Medication {
Id = 1, Name = "AZOSİLİN 30 TB"
},
new Medication {
Id = 2, Name = "BACTRİM 200/40 MG 100 ML SÜSPANSİYON"
},
new Medication {
Id = 3, Name = "DUOCİD ORAL SÜSPANSİYON 250MG/5ML 100ML"
},
new Medication {
Id = 4, Name = "DEPOSİLİN 1.2 IU FLK"
},
new Medication {
Id = 5, Name = "MACROL 250 MG 100 ML SUSPANSIYON"
},
new Medication {
Id = 6, Name = "NİDAZOL 500 MG FİLM TABLET"
},
new Medication {
Id = 7, Name = "SUPRAX SUSPANSIYON 50 ML."
},
new Medication {
Id = 8, Name = "SUPRAX 400 MG"
}
);
Polyclinic p1 = new Polyclinic {
Id = 1, Name = "Ağız ve Diş Sağlığı Servisi"
};
Polyclinic p2 = new Polyclinic {
Id = 2, Name = "Anestezi ve Reanimasyon Servisi"
};
Polyclinic p3 = new Polyclinic {
Id = 3, Name = "Beslenme ve Diyet Bölümü"
};
Polyclinic p4 = new Polyclinic {
Id = 4, Name = "Cilt Hastalıkları Servisi"
};
Polyclinic p5 = new Polyclinic {
Id = 5, Name = "Çocuk Servisi"
};
Polyclinic p6 = new Polyclinic {
Id = 6, Name = "Dahiliye Servisi"
};
Polyclinic p7 = new Polyclinic {
Id = 7, Name = "Fizik Tedavi Servisi"
};
Polyclinic p8 = new Polyclinic {
Id = 8, Name = "Genel Cerrahi Servisi"
};
Polyclinic p9 = new Polyclinic {
Id = 9, Name = "Göğüs Hastalıkları Servisi"
};
Polyclinic p10 = new Polyclinic {
Id = 10, Name = "Göz Servisi"
};
Polyclinic p11 = new Polyclinic {
Id = 11, Name = "Kadın Hastalıkları ve Doğum Servisi"
};
Polyclinic p12 = new Polyclinic {
Id = 12, Name = "Kardiyoloji Servisi"
};
Polyclinic p13 = new Polyclinic {
Id = 13, Name = "Kulak Burun Boğaz Servisi"
};
Polyclinic p14 = new Polyclinic {
Id = 14, Name = "Nöroloji Servisi"
};
Polyclinic p15 = new Polyclinic {
Id = 15, Name = "Nöroşirüji Servisi"
};
Polyclinic p16 = new Polyclinic {
Id = 16, Name = "Ortopedi ve Travmatoloji Servisi"
};
Polyclinic p17 = new Polyclinic {
Id = 17, Name = "Patoloji Servisi"
};
Polyclinic p18 = new Polyclinic {
Id = 18, Name = "Psikoloji Servisi"
};
Polyclinic p19 = new Polyclinic {
Id = 19, Name = "Radyoloji Servisi"
};
Polyclinic p20 = new Polyclinic {
Id = 20, Name = "Üroloji Servisi"
};
modelBuilder.Entity <Polyclinic>().HasData(p1, p2, p3, p4, p5, p6, p7, p8, p9, p10, p11, p12, p13, p14, p15, p16, p17, p18, p19, p20);
modelBuilder.Entity <Doctor>().HasData(
new Doctor {
Id = 1, PolyclinicId = p9.Id, UserId = u2.Id
}
);
modelBuilder.Entity <Secretary>().HasData(
new Secretary {
Id = 1, UserId = u3.Id
}
);
modelBuilder.Entity <Patient>().HasData(
new Patient {
Id = 1, UserId = u4.Id
}
);
modelBuilder.Entity <Diseas>().HasData(
new Diseas {
Id = 1, Name = "COVID-19"
},
new Diseas {
Id = 2, Name = "Hipertansiyon"
},
new Diseas {
Id = 3, Name = "Hiperlipidemi "
},
new Diseas {
Id = 4, Name = "Akut Romatizmal Ateş"
},
new Diseas {
Id = 5, Name = "Multiple Skleroz"
},
new Diseas {
Id = 6, Name = "Üst Solunum Yolu Enfeksiyonu"
},
new Diseas {
Id = 7, Name = "Alt Solunum Yolu Enfeksiyonu"
},
new Diseas {
Id = 8, Name = "Akut Gastroenterit"
},
new Diseas {
Id = 9, Name = "Yumuşak Doku Enfeksiyonu "
}
);
}
public async Task <int> InsertOrUpdatePolyclinicAsync(Polyclinic polyclinic)
{
return(await this.PolyclinicRepository.InsertOrUpdatePolyclinicAsync(polyclinic));
}
public async Task <int> InsertOrUpdatePolyclinicAsync(Polyclinic polyclinic)
{
throw new System.NotImplementedException();
}
