protected void btnSave_Click(object sender, EventArgs e)
{
DoctorsOrder doctorsOrder = new DoctorsOrder();
doctorsOrder.ClinicalFindings = txtClinicalFindings.Text;
doctorsOrder.Orders = txtOrder.Text;
doctorsOrder.ResidentID = Int32.Parse(Request.QueryString["ResidentID"]);
doctorsOrder.OrderDate = DateTime.Parse(txtOrderDate.Text);
doctorsOrder.AddeBy = getLogin().LoginID;
doctorsOrder.AddedDate = DateTime.Now;
doctorsOrder.UpdatedBy = getLogin().LoginID;
doctorsOrder.UpdatedDate = DateTime.Now;
doctorsOrder.ExtraField1 = txtPhysician.Text;
doctorsOrder.ExtraField2 = txtMRno.Text;
doctorsOrder.ExtraField3 = getStaffNotified();
doctorsOrder.ExtraField4 = "";
doctorsOrder.ExtraField5 = "";
if (ddlExistingRecord.SelectedIndex == 0)
{
int resutl = DoctorsOrderManager.InsertDoctorsOrder(doctorsOrder);
}
else
{
doctorsOrder.DoctorsOrderID = int.Parse(ddlExistingRecord.SelectedValue);
DoctorsOrderManager.UpdateDoctorsOrder(doctorsOrder);
}
loadGrid();
}
public bool UpdateDoctorsOrder(DoctorsOrder doctorsOrder)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_UpdateDoctorsOrder", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@DoctorsOrderID", SqlDbType.Int).Value = doctorsOrder.DoctorsOrderID;
cmd.Parameters.Add("@ClinicalFindings", SqlDbType.NText).Value = doctorsOrder.ClinicalFindings;
cmd.Parameters.Add("@Orders", SqlDbType.NText).Value = doctorsOrder.Orders;
cmd.Parameters.Add("@ResidentID", SqlDbType.Int).Value = doctorsOrder.ResidentID;
cmd.Parameters.Add("@OrderDate", SqlDbType.DateTime).Value = doctorsOrder.OrderDate;
cmd.Parameters.Add("@AddeBy", SqlDbType.Int).Value = doctorsOrder.AddeBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = doctorsOrder.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = doctorsOrder.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = doctorsOrder.UpdatedDate;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = doctorsOrder.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = doctorsOrder.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = doctorsOrder.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = doctorsOrder.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = doctorsOrder.ExtraField5;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
DoctorsOrder doctorsOrder = new DoctorsOrder();
doctorsOrder = DoctorsOrderManager.GetDoctorsOrderByID(Int32.Parse(Request.QueryString["doctorsOrderID"]));
DoctorsOrder tempDoctorsOrder = new DoctorsOrder();
tempDoctorsOrder.DoctorsOrderID = doctorsOrder.DoctorsOrderID;
tempDoctorsOrder.ClinicalFindings = txtClinicalFindings.Text;
tempDoctorsOrder.Orders = txtOrders.Text;
tempDoctorsOrder.ResidentID = Int32.Parse(ddlResident.SelectedValue);
tempDoctorsOrder.OrderDate = txtOrderDate.Text;
tempDoctorsOrder.AddeBy = Int32.Parse(txtAddeBy.Text);
tempDoctorsOrder.AddedDate = DateTime.Now;
tempDoctorsOrder.UpdatedBy = Int32.Parse(txtUpdatedBy.Text);
tempDoctorsOrder.UpdatedDate = txtUpdatedDate.Text;
tempDoctorsOrder.ExtraField1 = txtExtraField1.Text;
tempDoctorsOrder.ExtraField2 = txtExtraField2.Text;
tempDoctorsOrder.ExtraField3 = txtExtraField3.Text;
tempDoctorsOrder.ExtraField4 = txtExtraField4.Text;
tempDoctorsOrder.ExtraField5 = txtExtraField5.Text;
bool result = DoctorsOrderManager.UpdateDoctorsOrder(tempDoctorsOrder);
Response.Redirect("AdminDoctorsOrderDisplay.aspx");
}
public static DoctorsOrder GetDoctorsOrderByID(int id)
{
DoctorsOrder doctorsOrder = new DoctorsOrder();
SqlDoctorsOrderProvider sqlDoctorsOrderProvider = new SqlDoctorsOrderProvider();
doctorsOrder = sqlDoctorsOrderProvider.GetDoctorsOrderByID(id);
return doctorsOrder;
}
public DoctorsOrder GetDoctorsOrderFromReader(IDataReader reader)
{
try
{
DoctorsOrder doctorsOrder = new DoctorsOrder
(
(int)reader["DoctorsOrderID"],
reader["ClinicalFindings"].ToString(),
reader["Orders"].ToString(),
(int)reader["ResidentID"],
(DateTime)reader["OrderDate"],
(int)reader["AddeBy"],
(DateTime)reader["AddedDate"],
(int)reader["UpdatedBy"],
(DateTime)reader["UpdatedDate"],
reader["ExtraField1"].ToString(),
reader["ExtraField2"].ToString(),
reader["ExtraField3"].ToString(),
reader["ExtraField4"].ToString(),
reader["ExtraField5"].ToString()
);
return(doctorsOrder);
}
catch (Exception ex)
{
return(null);
}
}
public static DoctorsOrder GetDoctorsOrderByID(int id)
{
DoctorsOrder doctorsOrder = new DoctorsOrder();
SqlDoctorsOrderProvider sqlDoctorsOrderProvider = new SqlDoctorsOrderProvider();
doctorsOrder = sqlDoctorsOrderProvider.GetDoctorsOrderByID(id);
return(doctorsOrder);
}
private void loadSelectData(int doctorsOrderID)
{
DoctorsOrder doctorsOrder = DoctorsOrderManager.GetDoctorsOrderByID(doctorsOrderID);
txtClinicalFindings.Text = doctorsOrder.ClinicalFindings;
txtOrder.Text = doctorsOrder.Orders;
txtOrderDate.Text = doctorsOrder.OrderDate.ToString("MM/dd/yyyy hh:mm tt");
txtPhysician.Text = doctorsOrder.ExtraField1;
txtMRno.Text = doctorsOrder.ExtraField2;
LoadStaffNotified(doctorsOrder.ExtraField3);
}
public String getText(DateOfOrder date, DoctorsOrder order, StringBuilder stringBuilder)
{
foreach (MedicineForOrdering medicine in MedicineService.GetAll())
{
if (isOrderInRequiredPeriod(medicine, date, order))
{
stringBuilder.Append("\n Medicine name: " + medicine.Name + "\n Ordered quantity: " + medicine.Quantity + " (Date: " + order.DateEnd.Date.ToString() + ")\n");
}
}
return(stringBuilder.ToString());
}
private void loadSelectData()
{
DoctorsOrder doctorsOrder = DoctorsOrderManager.GetDoctorsOrderByID(int.Parse(ddlExistingRecord.SelectedValue));
txtClinicalFindings.Text = doctorsOrder.ClinicalFindings;
txtOrder.Text = doctorsOrder.Orders;
txtOrderDate.Text = doctorsOrder.OrderDate.ToString("MM/dd/yyyy hh:mm tt");
txtPhysician.Text = doctorsOrder.ExtraField1;
txtMRno.Text = doctorsOrder.ExtraField2;
LoadStaffNotified(doctorsOrder.ExtraField3);
}
public static IDoctorOrderRepositoy Create_stub_repository_doctor_orders()
{
var stubRepository = new Mock <IDoctorOrderRepositoy>();
DoctorsOrder order1 = new DoctorsOrder(2, false, new DateTime(2020, 3, 12), new DateTime(2020, 9, 9), true, true);
DoctorsOrder order2 = new DoctorsOrder(3, true, new DateTime(2020, 8, 12), new DateTime(2020, 10, 9), true, true);
var orders = new List <DoctorsOrder>();
orders.Add(order1);
orders.Add(order2);
stubRepository.Setup(m => m.GetAll()).Returns(orders);
return(stubRepository.Object);
}
private void showDoctorsOrderData()
{
DoctorsOrder doctorsOrder = new DoctorsOrder();
doctorsOrder = DoctorsOrderManager.GetDoctorsOrderByID(Int32.Parse(Request.QueryString["doctorsOrderID"]));
txtClinicalFindings.Text = doctorsOrder.ClinicalFindings;
txtOrders.Text = doctorsOrder.Orders;
ddlResident.SelectedValue = doctorsOrder.ResidentID.ToString();
txtOrderDate.Text = doctorsOrder.OrderDate;
txtAddeBy.Text = doctorsOrder.AddeBy.ToString();
txtUpdatedBy.Text = doctorsOrder.UpdatedBy.ToString();
txtUpdatedDate.Text = doctorsOrder.UpdatedDate;
txtExtraField1.Text = doctorsOrder.ExtraField1;
txtExtraField2.Text = doctorsOrder.ExtraField2;
txtExtraField3.Text = doctorsOrder.ExtraField3;
txtExtraField4.Text = doctorsOrder.ExtraField4;
txtExtraField5.Text = doctorsOrder.ExtraField5;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
DoctorsOrder doctorsOrder = new DoctorsOrder();
doctorsOrder.ClinicalFindings = txtClinicalFindings.Text;
doctorsOrder.Orders = txtOrders.Text;
doctorsOrder.ResidentID = Int32.Parse(ddlResident.SelectedValue);
doctorsOrder.OrderDate = txtOrderDate.Text;
doctorsOrder.AddeBy = Int32.Parse(txtAddeBy.Text);
doctorsOrder.AddedDate = DateTime.Now;
doctorsOrder.UpdatedBy = Int32.Parse(txtUpdatedBy.Text);
doctorsOrder.UpdatedDate = txtUpdatedDate.Text;
doctorsOrder.ExtraField1 = txtExtraField1.Text;
doctorsOrder.ExtraField2 = txtExtraField2.Text;
doctorsOrder.ExtraField3 = txtExtraField3.Text;
doctorsOrder.ExtraField4 = txtExtraField4.Text;
doctorsOrder.ExtraField5 = txtExtraField5.Text;
int resutl = DoctorsOrderManager.InsertDoctorsOrder(doctorsOrder);
Response.Redirect("AdminDoctorsOrderDisplay.aspx");
}
public DoctorsOrder Add(DoctorsOrder order)
{
dbContext.DoctorsOrders.Add(order);
dbContext.SaveChanges();
return(order);
}
public DoctorsOrder GetDoctorsOrderFromReader(IDataReader reader)
{
try
{
DoctorsOrder doctorsOrder = new DoctorsOrder
(
(int)reader["DoctorsOrderID"],
reader["ClinicalFindings"].ToString(),
reader["Orders"].ToString(),
(int)reader["ResidentID"],
(DateTime)reader["OrderDate"],
(int)reader["AddeBy"],
(DateTime)reader["AddedDate"],
(int)reader["UpdatedBy"],
(DateTime)reader["UpdatedDate"],
reader["ExtraField1"].ToString(),
reader["ExtraField2"].ToString(),
reader["ExtraField3"].ToString(),
reader["ExtraField4"].ToString(),
reader["ExtraField5"].ToString()
);
return doctorsOrder;
}
catch(Exception ex)
{
return null;
}
}
public DoctorsOrderDto DoctorsOrderToDoctorsOrderDTO(DoctorsOrder order)
{
return(new DoctorsOrderDto(order.IsUrgent, order.DateStart, order.DateEnd, order.IsOrdered, order.IsFinished));
}
public static bool UpdateDoctorsOrder(DoctorsOrder doctorsOrder)
{
SqlDoctorsOrderProvider sqlDoctorsOrderProvider = new SqlDoctorsOrderProvider();
return sqlDoctorsOrderProvider.UpdateDoctorsOrder(doctorsOrder);
}
public bool UpdateDoctorsOrder(DoctorsOrder doctorsOrder)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_UpdateDoctorsOrder", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@DoctorsOrderID", SqlDbType.Int).Value = doctorsOrder.DoctorsOrderID;
cmd.Parameters.Add("@ClinicalFindings", SqlDbType.NText).Value = doctorsOrder.ClinicalFindings;
cmd.Parameters.Add("@Orders", SqlDbType.NText).Value = doctorsOrder.Orders;
cmd.Parameters.Add("@ResidentID", SqlDbType.Int).Value = doctorsOrder.ResidentID;
cmd.Parameters.Add("@OrderDate", SqlDbType.DateTime).Value = doctorsOrder.OrderDate;
cmd.Parameters.Add("@AddeBy", SqlDbType.Int).Value = doctorsOrder.AddeBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = doctorsOrder.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = doctorsOrder.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = doctorsOrder.UpdatedDate;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = doctorsOrder.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = doctorsOrder.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = doctorsOrder.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = doctorsOrder.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = doctorsOrder.ExtraField5;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public static int InsertDoctorsOrder(DoctorsOrder doctorsOrder)
{
SqlDoctorsOrderProvider sqlDoctorsOrderProvider = new SqlDoctorsOrderProvider();
return sqlDoctorsOrderProvider.InsertDoctorsOrder(doctorsOrder);
}
public static int InsertDoctorsOrder(DoctorsOrder doctorsOrder)
{
SqlDoctorsOrderProvider sqlDoctorsOrderProvider = new SqlDoctorsOrderProvider();
return(sqlDoctorsOrderProvider.InsertDoctorsOrder(doctorsOrder));
}
public static bool UpdateDoctorsOrder(DoctorsOrder doctorsOrder)
{
SqlDoctorsOrderProvider sqlDoctorsOrderProvider = new SqlDoctorsOrderProvider();
return(sqlDoctorsOrderProvider.UpdateDoctorsOrder(doctorsOrder));
}
private int getQuantity(DateOfOrder date, int totalQuatity, DoctorsOrder order)
{
return(MedicineService.GetAll().Where(medicine => isOrderInRequiredPeriod(medicine, date, order)).Sum(medicine => medicine.Quantity));
}
private bool isOrderInRequiredPeriod(MedicineForOrdering medicine, DateOfOrder date, DoctorsOrder order)
{
if (HelperFunctions.IsIdEqual(medicine.OrderId, order.id) && HelperFunctions.CompareDates(order.DateEnd, HelperFunctions.ConvertStringToDate(date.StartDate)) == 1 && HelperFunctions.CompareDates(order.DateEnd, HelperFunctions.ConvertStringToDate(date.EndDate)) == -1 && order.IsFinished)
{
return(true);
}
return(false);
}
