private void Button_Click(object sender, EventArgs e)
{
Button selectedbuton = (Button)sender;
HospitalDetail doctor = (HospitalDetail)cBxSelectDoctor.SelectedValue;
Appointment apointment = new Appointment();
DialogResult = MessageBox.Show("Kaydı onaylıyor musunuz?", "Randevu", MessageBoxButtons.YesNo);
if (DialogResult.Yes == DialogResult)
{
apointment.PatientID = _userID;
apointment.DoctorID = doctor.DoctorID;
apointment.AppointmenDate = dTPAppointmentDate.Value.Date;
apointment.AppointTime = DateTime.Parse(selectedbuton.Text.ToString());
bool save = apoBLL.Insert(apointment);
if (save)
{
MessageBox.Show("Belirtilen Tarih Ve Klinikte Randevunuz Başarıyla Alınmıştır.");
TimeFill();
}
else
{
MessageBox.Show("Randevunuz alınamadı!");
}
}
}
private void dtGridViewSelectedDoctorDate_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
HospitalDetail detail = new HospitalDetail
{
HospitalId = Convert.ToInt32(cmbHospital.SelectedValue),
PolyclinicId = Convert.ToInt32(cmbPolyclinic.SelectedValue),
DepartmentId = Convert.ToInt32(cmbClinicLocation.SelectedValue),
DoctorId = Convert.ToInt32(cmbChooseDoctor.SelectedValue),
};
int hospitalDetailId = hospitalDetailManagement.SearchHospitalDetails(detail);
Appointment appointment = new Appointment
{
HospitalDetailId = hospitalDetailId,
PatientId = UserID,
DoctorWorkingHourId = Convert.ToInt32(dtGridViewSelectedDoctorDate.CurrentRow.Cells[0].Value),
DateOfAppointment = DateTime.Now
};
appointmentManagement.AddAppointment(appointment);
DoctorWorkingHour workingHour = new DoctorWorkingHour
{
DoctorWorkingHourId = Convert.ToInt32(dtGridViewSelectedDoctorDate.CurrentRow.Cells[0].Value),
Status = false
};
hourManagement.UpdateWorkingHour(workingHour);
}
private void AppointmentSave_Load(object sender, EventArgs e)
{
DateControl();
HospitalDetail hostd = new HospitalDetail();
cBxSelectCity.DataSource = hostbll.GetCityAll();
}
public ActionResult setDetailPost(HospitalDetail model)
{
string json = "";
string result = "";
using (WebClient client = new WebClient())
{
var collection = new NameValueCollection();
collection.Add("name", model.name);
collection.Add("ostan", model.ostan);
collection.Add("phone", model.phone);
collection.Add("sharestan", model.sharestan);
collection.Add("mohandes", model.mohandes);
collection.Add("mahaleazmoon", model.mahaleazmoon);
collection.Add("address", model.address);
byte[] response =
client.UploadValues("http://www.supectco.com/webs/GDP/Admin/setHospitalDetail.php?", collection);
result = System.Text.Encoding.UTF8.GetString(response);
}
if (json.Contains("success"))
{
return(Content("success"));
}
else
{
return(Content("error"));
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
HospitalDetail h = new HospitalDetail();
h.HospitalName = txtHospitalName.Text;
h.HospitalAddress = txtAddress.Text;
h.HospitalAdminName = txtHospitalAdminName.Text;
h.HospitalContact = txtHospitalContact.Text;
h.IsActive = 1;
h.AdminContact = txtAdminContact.Text;
h.AdminEmail = txtAdminEmail.Text;
h.CreatedBy = "Ritesh";
h.ModifiedBy = "Ritesh";
if (hdnOperation.Value == "Update")
{
h.PK_HospitalId = Convert.ToInt32(hdnId.Value);
}
ApplicationAdminBAO bao = new ApplicationAdminBAO();
bao.SaveHospital(h);
lblMessage.Text = "Saved Successfully";
ClearForm();
FillGridView();
pnlAddForm.Visible = true;
pnlGrid.Visible = false;
}
private void cBxSelectTown_SelectedIndexChanged(object sender, EventArgs e)
{
HospitalDetail hostcity = (HospitalDetail)cBxSelectCity.SelectedValue;
HospitalDetail hostd = (HospitalDetail)cBxSelectTown.SelectedValue;
cBxSelectHospital.DataSource = hospitalBLL.GetHospitalAll(hostcity.CityID, hostd.TownID);
}
public int SaveHospital(HospitalDetail p)
{
string query = "usp_SaveHospitalDetails";
List <SqlParameter> parameters = new List <SqlParameter>();
SqlParameter PkId = new SqlParameter("@PkId", p.PK_HospitalId);
SqlParameter name = new SqlParameter("@Hospital", p.HospitalName);
SqlParameter add = new SqlParameter("@HospitalAddress", p.HospitalAddress);
SqlParameter admin = new SqlParameter("@HospitalAdminName", p.HospitalAdminName);
SqlParameter cont = new SqlParameter("@HospitalContact", p.HospitalContact);
SqlParameter email = new SqlParameter("@AdminEmail", p.AdminEmail);
SqlParameter admincon = new SqlParameter("@AdminContact", p.AdminContact);
SqlParameter crea = new SqlParameter("@CreatedBy", p.CreatedBy);
SqlParameter mod = new SqlParameter("@ModifiedBy", p.ModifiedBy);
SqlParameter isact = new SqlParameter("@IsActive", p.IsActive);
parameters.Add(PkId);
parameters.Add(name);
parameters.Add(add);
parameters.Add(admin);
parameters.Add(admincon);
parameters.Add(cont);
parameters.Add(email);
parameters.Add(crea);
parameters.Add(mod);
parameters.Add(isact);
int result = ExecuteNonQueryUsingSP(query, parameters);
return(result);
}
public void UpdateHospitalDetail(HospitalDetail hd)
{
HospitalDetail updatedHospitalDetail = database.HospitalDetails.FirstOrDefault(x => x.DetailId == hd.DetailId);
database.Entry(updatedHospitalDetail).CurrentValues.SetValues(updatedHospitalDetail);
database.Entry(updatedHospitalDetail).State = EntityState.Modified;
}
private void cBxSelectHospital_SelectedIndexChanged(object sender, EventArgs e)
{
HospitalDetail hostcity = (HospitalDetail)cBxSelectCity.SelectedValue;
HospitalDetail hosttown = (HospitalDetail)cBxSelectTown.SelectedValue;
HospitalDetail hosthospital = (HospitalDetail)cBxSelectHospital.SelectedValue;
cBxSelectClinic.DataSource = hospitalBLL.GetClinicAll(hostcity.CityID, hosttown.TownID, hosthospital.HospitalID);
}
public AppointmentSave()
{
InitializeComponent();
command = new SqlCommand();
hospitalBLL = new HospitalDetailBLL();
hospitalDetails = new HospitalDetail();
buttonList = new List <Button>();
apoBLL = new AppointmentBLL();
}
public bool AddHospitalDetail(HospitalDetail hd)
{
try
{
database.HospitalDetails.Add(hd);
database.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public HospitalDetail HospitalDetailDTO(DataRow r)
{
HospitalDetail d = new HospitalDetail();
d.AdminContact = r["AdminContact"].ToString();
d.AdminEmail = r["AdminEmail"].ToString();
d.HospitalAddress = r["HospitalAddress"].ToString();
d.HospitalAdminName = r["HospitalAdminName"].ToString();
d.HospitalContact = r["HospitalContact"].ToString();
d.HospitalName = r["HospitalName"].ToString();
d.IsActive = Convert.ToInt32(r["IsActive"].ToString());
d.Password = r["Password"].ToString();
d.PK_HospitalId = Convert.ToInt32(r["PK_HospitalId"].ToString());
return(d);
}
public HospitalDetail GetHospitalDetailsByAdminEmail(string email)
{
DataTable dt;
List <SqlParameter> parameters = new List <SqlParameter>();
SqlParameter key = new SqlParameter("@AdminEmail", email);
parameters.Add(key);
DataSet ds = GetDataSetFromDBWithSP("usp_GetHospitalDetails", parameters);
dt = ds.Tables[0];
List <HospitalDetail> details = new List <HospitalDetail>();
foreach (DataRow row in dt.Rows)
{
HospitalDetail obj = HospitalDetailDTO(row);
details.Add(obj);
}
return(details.Count > 0 ? details[0] : null);
}
private void ListAdd()
{
lstVAppointmentList.Items.Clear();
lstVAppointmentList.BackColor = Color.White;
HospitalDetail hostdetail = new HospitalDetail();
hostdetail.CityName = cBxSelectCity.SelectedValue.ToString();
hostdetail.TownName = cBxSelectTown.SelectedValue.ToString();
hostdetail.HospitalName = cBxSelectHospital.SelectedValue.ToString();
hostdetail.ClinicBranch = cBxSelectClinic.SelectedValue.ToString();
hostdetail.FullName = cBxSelectDoctor.SelectedValue.ToString();
ListViewItem listitem = new ListViewItem();
listitem.Tag = hostdetail;
listitem.Text = hostdetail.FullName;
listitem.SubItems.Add(dTPAppointmentDate.Value.ToShortDateString());
listitem.SubItems.Add(hostdetail.HospitalName.ToString());
listitem.SubItems.Add(hostdetail.ClinicBranch.ToString());
lstVAppointmentList.Items.Add(listitem);
}
public void RemoveHospitalDetail(HospitalDetail hd)
{
if (hd.DetailId <= 0)
{
MessageBox.Show("Kayıt Silebilmek İçin Bir Kayıt Seçilmelidir..");
}
else
{
var selectedHospitalDetail = database.HospitalDetails.FirstOrDefault(x => x.DetailId == hd.DetailId);
if (selectedHospitalDetail == null)
{
MessageBox.Show("Silinebilecek bir kayıt bulunmadı...");
}
else
{
DialogResult dialogResult = MessageBox.Show($"{hd.DetailId} Numaralı Kaydı Silmek İstediğinizden Emin Misiniz ?", "Hastane Detayı Silme İşlemi", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (dialogResult == DialogResult.OK)
{
database.HospitalDetails.Remove(selectedHospitalDetail);
database.SaveChanges();
}
}
}
}
protected void btnogin_Click(object sender, EventArgs e)
{
if (ddlUserType.SelectedValue == "Doctor")
{
//txtUserName.Text
//txtPassword.Text
DoctorBAO obj = new DoctorBAO();
DoctorDetail Doctor = obj.GetDoctorDetailByEmail(txtUserName.Text);
if (Doctor != null)
{
if (Doctor.Password == txtPassword.Text)
{
UserLogin user = new UserLogin();
user.UserName = Doctor.Email;
user.FullName = Doctor.DoctorName;
user.Id = Doctor.PK_Doctor;
user.Password = Doctor.Password;
user.TypeOfUser = UserType.DoctorUser;
Session["UserObject"] = user;
Session["UserName"] = user.UserName;
Session["HospitalId"] = Doctor.FK_HospitalId;
Response.Redirect("~/Doctor/DoctorHome.aspx");
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message", "alert('Invalid User name password')", true);
}
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message", "alert('Invalid User name password')", true);
}
}
else if (ddlUserType.SelectedValue == "Reception")
{
ReceptionBAO obj = new ReceptionBAO();
ReceptionDetail reception = obj.GetReceptionByEmail(txtUserName.Text);
if (reception != null)
{
if (reception.Password == txtPassword.Text)
{
UserLogin user = new UserLogin();
user.UserName = reception.Email;
user.FullName = reception.FullName;
user.Id = reception.PK_Reception;
user.Password = reception.Password;
user.TypeOfUser = UserType.ReceptionUser;
Session["UserObject"] = user;
Session["UserName"] = user.UserName;
Session["HospitalId"] = reception.FK_HospitalId;
Response.Redirect("~/Reception/ReceptionHome.aspx");
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message", "alert('Invalid User name password')", true);
}
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message", "alert('Invalid User name password')", true);
}
}
else if (ddlUserType.SelectedValue == "HospitalAdmin")
{
//Need to implement Login check from DB for Hospital Admin
ApplicationAdminBAO obj = new ApplicationAdminBAO();
HospitalDetail h = obj.GetHospitalDetailsByAdminEmail(txtUserName.Text);
if (h != null)
{
if (h.Password == txtPassword.Text)
{
UserLogin user = new UserLogin();
user.UserName = h.AdminEmail;
user.FullName = h.HospitalAdminName;
user.Id = h.PK_HospitalId;
user.Password = h.Password;
user.TypeOfUser = UserType.HospitalAdmin;
Session["HospitalId"] = h.PK_HospitalId;
Session["UserObject"] = user;
Session["UserName"] = user.UserName;
Response.Redirect("~/HospitalAdminPages/HospitalHome.aspx");
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message", "alert('Invalid User name password')", true);
}
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message", "alert('Invalid User name password')", true);
}
}
}
protected void Application_Start(Object sender, EventArgs e)
{
EnvironmentConfiguration envirConfig = Detect.GetMachineConfiguration();
PMRVariable.PMRLicenseFileName = envirConfig.KeyValues.Get("PMRLicenseFile");
PMRVariable.PMRErrorFileName = envirConfig.KeyValues.Get("PMRErrorFile");
PMRVariable.Continent = envirConfig.KeyValues.Get("Continent");
string serverName = envirConfig.KeyValues.Get("ServerName");
string userID = envirConfig.KeyValues.Get("UserID");
string password = envirConfig.KeyValues.Get("Password");
string dbName = envirConfig.KeyValues.Get("DataBase");
// PMRVariable.PMRDBConnection = "Server=" + serverName + ";Database=" + dbName + ";Integrated Security=True;";
PMRVariable.PMRDBConnection = "Server=" + serverName + ";Database=" + dbName + ";UId=" + userID + ";pwd="+ password + ";";
//Get this data from data base later
HospitalDetail hospital = new HospitalDetail();
DataSet dsHospital = hospital.GetHospitalDetail();
if (dsHospital.Tables[0].Rows.Count > 0)
{
PMRVariable.HospitalID = dsHospital.Tables[0].Rows[0]["HospitalID"].ToString();
PMRVariable.HospitalName = dsHospital.Tables[0].Rows[0]["HospitalName"].ToString();
}
PMRVariable.DefaultCountry = envirConfig.KeyValues.Get("DefaultCountry");
PMRVariable.BuildPMRParamTable();
PMRVariable.ExternalEmailType = envirConfig.KeyValues.Get("ExternalEmailType");
PMRVariable.MailServer = envirConfig.KeyValues.Get("MailServer");
PMRVariable.EmailFrom = envirConfig.KeyValues.Get("EmailFrom");
PMRVariable.ReportTemplatePath = envirConfig.KeyValues.Get("ReportTemplatePath");
PMRVariable.ReportOutputPath = envirConfig.KeyValues.Get("ReportOutputPath");
PMRVariable.LogFileName = envirConfig.KeyValues.Get("LogFileName");
PMRVariable.PMRUrl = envirConfig.KeyValues.Get("PMRUrl");
PMRVariable.WebDomain = envirConfig.KeyValues.Get("WebDomain");
PMRVariable.SMTPHost = envirConfig.KeyValues.Get("SMTPHost");
PMRVariable.Version = envirConfig.KeyValues.Get("Version");
PMRLicense license = LicenseFactory.ReadLicense(true);
Application.Add("PMRLicense", license);
}
public void TimeFill()
{
groupAppointment.Controls.Clear();
HospitalDetail clinic = (HospitalDetail)cBxSelectClinic.SelectedValue;
HospitalDetail doctor = (HospitalDetail)cBxSelectDoctor.SelectedValue;
buttonList = new List <Button>();
int timeRange = clinic.ClinicRangeTime;
string startTime = clinic.ClinicStartTime.ToShortTimeString();
string endTime = clinic.ClinicEndTime.ToShortTimeString();
bool flag = true;
for (int i = 0; i < 4; i++)
{
for (int j = 0; j < 3; j++)
{
Button button = new Button();
button.Width = 50;
button.Height = 25;
button.Top = (i + 1) * 25;
button.Left = (j + 1) * 55;
button.BackColor = Color.Green;
button.Text = Convert.ToDateTime(startTime).ToShortTimeString();
startTime = Convert.ToDateTime(startTime).AddMinutes(timeRange).ToString();
groupAppointment.Controls.Add(button);
buttonList.Add(button);
button.Click += Button_Click;
}
}
startTime = "13:00";
for (int k = 4; k < 9; k++)
{
for (int l = 0; l < 3; l++)
{
Button button1 = new Button();
button1.Width = 50;
button1.Height = 25;
button1.Top = (k + 1) * 25;
button1.Left = (l + 1) * 55;
button1.BackColor = Color.Green;
button1.Text = Convert.ToDateTime(startTime).ToShortTimeString();
startTime = Convert.ToDateTime(startTime).AddMinutes(timeRange).ToString();
groupAppointment.Controls.Add(button1);
buttonList.Add(button1);
button1.Click += Button_Click;
if (button1.Text == "17:00")
{
flag = false;
break;
}
}
if (flag == false)
{
break;
}
}
List <String> listReserve = new List <String>();
//listReserve.AddRange(apoBLL.GetDoctorTimeAll(dTPAppointmentDate.Value.Date, doctor.DoctorID));
listReserve.AddRange(apoBLL.GetDoctorTimeAll(doctor.DoctorID, dTPAppointmentDate.Value));
for (int i = 0; i < buttonList.Count; i++)
{
for (int j = 0; j < listReserve.Count; j++)
{
if (buttonList[i].Text == Convert.ToDateTime(listReserve[j]).ToShortTimeString())
{
buttonList[i].Enabled = false;
buttonList[i].BackColor = Color.Transparent;
}
}
}
}
public ActionResult PDFReport()
{
string HospitalList = "";
using (var client = new WebClient())
{
HospitalList = client.DownloadString("http://www.supectco.com/webs/GDP/Admin/getHospitalDetail.php?");
}
HospitalRoot log4 = JsonConvert.DeserializeObject <HospitalRoot>(HospitalList);
HospitalDetail detail = log4.hospitalDetail.Where(x => x.active == "true").FirstOrDefault();
string selectdid = detail.ID;
List <SelectListItem> HospitalItems = new List <SelectListItem>();
if (log4.hospitalDetail != null)
{
HospitalItems = log4.hospitalDetail.Select(c => new SelectListItem
{
Value = c.ID,
Text = c.name,
Selected = false,
}).ToList();
HospitalItems.Where(x => x.Value == selectdid).SingleOrDefault().Selected = true;
}
string PositionList = "";
using (var client = new WebClient())
{
PositionList = client.DownloadString("http://www.supectco.com/webs/GDP/Admin/getPosition.php?");
}
RootObjectFilter log3 = JsonConvert.DeserializeObject <RootObjectFilter>(PositionList);
List <SelectListItem> PositionItems = new List <SelectListItem>();
if (log3.filtersModel != null)
{
PositionItems = log3.filtersModel.Select(c => new SelectListItem
{
Value = c.title,
Text = c.title,
}).ToList();
}
string json = "";
using (var client = new WebClient())
{
json = client.DownloadString("http://www.supectco.com/webs/GDP/Admin/getDevices.php?");
}
RootObjectFilter log2 = JsonConvert.DeserializeObject <RootObjectFilter>(json);
List <SelectListItem> DeviceItems = new List <SelectListItem>();
if (log2.filtersModel != null)
{
DeviceItems = log2.filtersModel.Select(c => new SelectListItem
{
Value = c.ID,
Text = c.title
}).ToList();
}
PDFModel model = new PDFModel();
model.hospitalName = selectdid;
string srt = getListOfPDF(model);
PDFModelForReportList log = JsonConvert.DeserializeObject <PDFModelForReportList>(srt);
PDFReportVM VM = new PDFReportVM();
VM.list = log.PDFmodelForReport;
VM.DeviceItems = DeviceItems;
VM.PositionItems = PositionItems;
VM.HospitalItems = HospitalItems;
return(View(VM));
}
public int SearchHospitalDetails(HospitalDetail d)
{
var result = database.HospitalDetails.SingleOrDefault(h => h.HospitalId == d.HospitalId && h.PolyclinicId == d.PolyclinicId && h.DepartmentId == d.DepartmentId && h.DoctorId == d.DoctorId);
return(result.DetailId);
}
