protected void ShowOrder_RowCommand(object sender, GridViewCommandEventArgs e)
{
int rowNumber = Convert.ToInt32(e.CommandArgument);
int orderId = Convert.ToInt32(ShowOrder.Rows[rowNumber].Cells[0].Text);
Pharmcy.PharmcyWS webser = new Pharmcy.PharmcyWS();
if (e.CommandName == "SeeDetails")
{
DataSet ds = webser.GetDetailsAboutOrder(orderId);
ShowDetails.Visible = true;
ShowDetails.DataSource = ds;
ShowDetails.DataBind();
for (int i = 0; i < ShowOrder.Rows.Count; i++)
{
ShowOrder.Rows[i].Font.Bold = false;
}
ShowOrder.Rows[rowNumber].Font.Bold = true;
}
if (e.CommandName == "DeleteOrder")
{
DateTime orderDate = Convert.ToDateTime(ShowOrder.Rows[rowNumber].Cells[2].ToString());
if (orderDate.AddDays(2) < DateTime.Now)
{
webser.DeleteOrder(orderId);
SortDDL_SelectedIndexChanged(sender, e);
}
else
{
Response.Write("<script>alert('לא ניתן לבטל את ההזמנה')</script>");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Doctor d = (Doctor)Session["doctor"];
HelloLabel.Text = d.CDoctorName;
Pharmcy.PharmcyWS webser = new Pharmcy.PharmcyWS();
DataSet ds = webser.GetMedinceNameAndId();
List <ListItem> LI = GetAllData.getListItemsForDDL(ds, "Medicine");
foreach (ListItem l in LI)
{
MedicineNameDDL.Items.Add(l);
}
MedicineNameDDL.DataBind();
UserService us = new UserService();
ds = us.GetUserNameAndId();
LI = GetAllData.getListItemsForDDL(ds, "User");
foreach (ListItem l in LI)
{
UserNameDDL.Items.Add(l);
}
UserNameDDL.DataBind();
}
}
protected void ShowShoppingbag_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "DeleteMedicineFromShoppingBag")
{
ShoppingBag sb = (ShoppingBag)Session["myShoppingBag"];
int rowNumber = Convert.ToInt32(e.CommandArgument);
MedicineInBag MIB = new MedicineInBag();
Pharmcy.PharmcyWS webser = new Pharmcy.PharmcyWS();
MIB.CMedicineId = ShowShoppingbag.Rows[rowNumber].Cells[0].Text;
MIB.CMedicineNeedPrescription = webser.GetMedicineNeedPres(Convert.ToInt32(MIB.CMedicineId));
if (MIB.CMedicineNeedPrescription)
{
List <DataSet> presList = (List <DataSet>)Session["presList"];
foreach (DataSet d in presList)
{
if (d.Tables[0].Rows[0]["PrescriptionMedicineId"].ToString() == MIB.CMedicineId)
{
presList.Remove(d);
Session["presList"] = presList;
break;
}
}
}
sb.DeleteMedicineFromList(MIB);
Session["myShoppingBag"] = sb;
Response.Write("<script>alert('המוצר נמחק בהצלחה')</script>");
showShoppingBag(sb);
}
}
protected void ShowOrder_RowCommand(object sender, GridViewCommandEventArgs e)
{
int rowNumber = Convert.ToInt32(e.CommandArgument);
int orderId = Convert.ToInt32(ShowOrder.Rows[rowNumber].Cells[0].Text);
Pharmcy.PharmcyWS webser = new Pharmcy.PharmcyWS();
if (e.CommandName == "SendOrder")
{
webser.UpdateOrderSupplied(orderId);
//show all the orders
SortButton_Click(sender, e);
}
if (e.CommandName == "DeleteOrder")
{
webser.DeleteOrder(orderId);
//show all the orders
SortButton_Click(sender, e);
}
if (e.CommandName == "SeeDetails")
{
if (ShowDetails.Visible == false)
{
DataSet ds = webser.GetDetailsAboutOrder(orderId);
ShowDetails.Visible = true;
ShowDetails.DataSource = ds;
ShowDetails.DataBind();
for (int i = 0; i < ShowOrder.Rows.Count; i++)
{
ShowOrder.Rows[i].Font.Bold = false;
}
ShowOrder.Rows[rowNumber].Font.Bold = true;
}
}
}
protected void SendPrescription_Click(object sender, EventArgs e)
{
UserIdO.Text = "";
MedicineNameO.Text = "";
MedicineCountO.Text = "";
Doctor d = (Doctor)Session["doctor"];
bool isValid = true;
if (MedicineNameDDL.SelectedIndex == 0)
{
isValid = false;
MedicineNameO.Text = "לא בחרת תרופה";
}
if (UserNameDDL.SelectedIndex == 0)
{
isValid = false;
UserIdO.Text = "לא בחרת לקוח";
}
if (MedicineCountTB.Text != "" && Validation.IsHouseNumberValid(MedicineCountTB.Text))
{
if (Convert.ToInt32(MedicineCountTB.Text) <= 0)
{
isValid = false;
MedicineCountO.Text = "כמות לא תקינה";
}
}
else
{
isValid = false;
MedicineCountO.Text = "כמות לא תקינה";
}
if (isValid)
{
int count = Convert.ToInt32(MedicineCountTB.Text);
Pharmcy.PharmcyWS webser = new Pharmcy.PharmcyWS();
Prescription newp = new Prescription();
PrescriptioService ps = new PrescriptioService();
newp.CPrescriptionMedicineId = Convert.ToInt32(MedicineNameDDL.SelectedValue);
DataSet ds = ps.IsPresAlreadyExist(newp.CPrescriptionMedicineId);
if (ds.Tables[0].Rows.Count != 0)
{
int currentCount = Convert.ToInt32(ds.Tables[0].Rows[0]["PrescriptionMedicineCount"].ToString());
ps.UpdatePresMedCount(newp.CPrescriptionMedicineId, (currentCount + count));
ResetData_Click(sender, e);
Response.Write("<script>alert('המרשם נשלח בהצלחה')</script>");
return;
}
newp.CPrescriptionUserId = UserNameDDL.SelectedValue;
newp.CPrescriptionDoctorId = d.CDoctorId;
newp.CPrescriptionDate = DateTime.Now;
newp.CPrescriptionMedicineCount = count;
newp.CPrescriptionMedicineName = MedicineNameDDL.SelectedItem.Text;
newp.CPrescriptionMedicineCatagory = webser.GetMedicineCatagory(newp.CPrescriptionMedicineId);
ps.InsertPrescriptionToDataBase(newp);
ResetData_Click(sender, e);
//say the prescription send succesfully
Response.Write("<script>alert('המרשם נשלח בהצלחה')</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
//put the exit button in the menu
//
//EXIT BUTTON
//the exit button will delete the user shopping bag(set the value to be null)
//and doesnt change the current stock of the medicine.
//
//do a method that rrecives object, the session value of myShoppingbag will be an object
//and a shopping bag variable.
if (!Page.IsPostBack)
{
if (Session["myShoppingBag"] == null)
{
//create shopping list
Session["myShoppingBag"] = new ShoppingBag();
}
else
{
myShoppingBag = (ShoppingBag)Session["myShoppingBag"];
}
if (Session["presList"] == null)
{
Session["presList"] = new List <DataSet>();
}
else
{
presList = (List <DataSet>)Session["presList"];
}
//put the catagorys and the producers in the DDL
Pharmcy.PharmcyWS webser = new Pharmcy.PharmcyWS();
DataSet pro = webser.GetProducer(), cat = webser.GetCatagory();
List <ListItem> proList = GetAllData.getListItemsForDDL(pro, "MedicineProducer");
List <ListItem> catList = GetAllData.getListItemsForDDL(cat, "MedicineCatagory");
foreach (ListItem l in proList)
{
ProducerDDL.Items.Add(l);
}
foreach (ListItem l in catList)
{
DropDownListMedicineCatagory.Items.Add(l);
}
}
CheckoutButton.Visible = true;
SeeShoppingBag.Visible = true;
User u = (User)Session["user"];
if (u == null)
{
CheckoutButton.Visible = false;
SeeShoppingBag.Visible = false;
}
}
protected void ShowPrescriptionGrid_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "UsePrescription")
{
int rowNumber = Convert.ToInt32(e.CommandArgument);
int presId = Convert.ToInt32(ShowPrescriptionGrid.Rows[rowNumber].Cells[0].Text);
int medId = Convert.ToInt32(ShowPrescriptionGrid.Rows[rowNumber].Cells[3].Text);
int medCount = Convert.ToInt32(ShowPrescriptionGrid.Rows[rowNumber].Cells[5].Text);
Pharmcy.PharmcyWS webser = new Pharmcy.PharmcyWS();
int medStock = webser.GetMedicineStock(medId);
if (medCount > medStock)
{
Response.Write("<script>alert('אין מספיק תרופות במלאי')</script>");
return;
}
webser.UpdateMedCount(medStock - medCount, medId);
PrescriptioService ps = new PrescriptioService();
//get the total price of the prescription
int medPrice = webser.GetMedicinePrice(medId);
int totalPrice = medPrice * medCount;
ps.DeletePrescription(presId);
Response.Write("<script>alert('המרשם מומש בהצלחה, עלות ההזמנה היא: " + totalPrice + " שקלים')</script>");
SortPrescription_SelectedIndexChanged(sender, e);
//need to put this unfinished code in the page of PAYMENT
//get a redirect to the page of PAYMENT
//put in the basket the prescription items and wait for premition to check out
//there is no PAYMENT WEBSITE in this PROJECT
//or just do a POP UP that says the prescription has been used and the deatails of the order
//like in the APPOINTMENT PAGE for the USER
//delete the prescription from database
}
if (e.CommandName == "ShowMedicinePrice")
{
int rowNumber = Convert.ToInt32(e.CommandArgument);
int medId = Convert.ToInt32(ShowPrescriptionGrid.Rows[rowNumber].Cells[3].Text);
string medName = ShowPrescriptionGrid.Rows[rowNumber].Cells[4].Text;
Pharmcy.PharmcyWS webser = new Pharmcy.PharmcyWS();
int medPrice = webser.GetMedicinePrice(medId);
Response.Write("<script>alert('מחיר חבילת " + medName + " הוא " + medPrice + " שקלים')</script>");
}
}
protected void SortDDL_SelectedIndexChanged(object sender, EventArgs e)
{
int x = SortDDL.SelectedIndex;
string order = "";
switch (x)
{
case 1:
{
order = " ORDER BY OrderTotalMoney DESC";
break;
}
case 3:
{
order = " ORDER BY OrderIsSupplied";
break;
}
case 2:
{
order = " ORDER BY OrderDate";
break;
}
}
Pharmcy.PharmcyWS webser = new Pharmcy.PharmcyWS();
DataSet ds = webser.GetUserOrders((string)Session["userId"], order);
if (ds.Tables[0].Rows.Count != 0)
{
ShowOrder.Visible = true;
ShowDetails.Visible = false;
CloseOrders.Visible = true;
ShowOrder.DataSource = ds;
ShowOrder.DataBind();
}
else
{
CloseOrders_Click(sender, e);
Response.Write("<script>alert('לא נמצאו הזמנות')</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Manager m = (Manager)Session["manager"];
HelloLabel.Text = m.CManagerName;
Pharmcy.PharmcyWS webser = new Pharmcy.PharmcyWS();
DataSet ds = webser.GetAllOrders("");
if (ds.Tables[0].Rows.Count != 0)
{
CloseOrders.Visible = true;
ShowOrder.Visible = true;
ShowOrder.DataSource = ds;
ShowOrder.DataBind();
}
else
{
Response.Write("<script>alert('לא נמצאו הזמנות')</script>");
}
}
}
protected void SortButton_Click(object sender, EventArgs e)
{
table1.Visible = false;
DataSet ds;
string whereclout = "";
string str = "qwertyuiopasdfghjkl;zxcvbnm|,./'[]{}\\`!@#$%^&*()_-+=*.<>QWERTYUIOPASDFGHJKLZXCVBNM";
if (MoneyFrom.Text != "" || MoneyTo.Text != "")
{
for (int i = 0; i < str.Length; i++)
{
if (MoneyFrom.Text.IndexOf(str[i]) != -1)
{
Response.Write("<script>alert('טווח מחירים לא תקין')</script>");
return;
}
if (MoneyTo.Text.IndexOf(str[i]) != -1)
{
Response.Write("<script>alert('טווח מחירים לא תקין')</script>");
return;
}
}
}
//init
SearchReasultGrid.Visible = true;
CloseMedicineGrid.Visible = true;
//end init
//creating the sort SQL line
int pro = ProducerDDL.SelectedIndex + 1;
int cat = DropDownListMedicineCatagory.SelectedIndex + 1;
if (pro > 1)
{
if (whereclout != "")
{
whereclout = whereclout + " and ";
}
else
{
whereclout = " where ";
}
whereclout = whereclout + "MedicineProducer=" + pro;
}
if (cat > 1)
{
if (whereclout != "")
{
whereclout = whereclout + " and ";
}
else
{
whereclout = " where ";
}
whereclout = whereclout + "MedicineCatagory=" + cat;
}
if (MoneyFrom.Text != "")
{
if (whereclout != "")
{
whereclout = whereclout + " and ";
}
else
{
whereclout = " where ";
}
whereclout = whereclout + "MedicinePrice> " + Convert.ToInt32(MoneyFrom.Text);
}
if (MoneyTo.Text != "")
{
if (whereclout != "")
{
whereclout = whereclout + " and ";
}
else
{
whereclout = " where ";
}
whereclout = whereclout + "MedicinePrice< " + Convert.ToInt32(MoneyTo.Text);
}
string man = ManualSearch.Text;
if (man != "")
{
if (whereclout != "")
{
whereclout = whereclout + " and ";
}
else
{
whereclout = " where ";
}
whereclout = whereclout + "(MedicineName LIKE '%" + man + "%')";
}
if (WithPresRB.Checked == true)
{
if (whereclout != "")
{
whereclout = whereclout + " and ";
}
else
{
whereclout = " where ";
}
whereclout = whereclout + "MedicineNeedPrescription=true";
}
if (WithoutPresRB.Checked == true)
{
if (whereclout != "")
{
whereclout = whereclout + " and ";
}
else
{
whereclout = " where ";
}
whereclout = whereclout + "MedicineNeedPrescription=false";
}
if (whereclout != "")
{
whereclout = whereclout + " and ";
}
else
{
whereclout = " where ";
}
whereclout = whereclout + "MedicineProducer=MedicineProducerId and MedicineCatagoryId=MedicineCatagory";
Pharmcy.PharmcyWS web = new Pharmcy.PharmcyWS();
ds = web.SortMedicine(whereclout);
if (ds.Tables[0].Rows.Count == 0)
{
CloseMedicineGrid.Visible = false;
Response.Write("<script>alert('לא נמצאו תרופות')</script>");
CloseMedicineGrid_Click(sender, e);
return;
}
SearchReasultGrid.DataSource = ds;
SearchReasultGrid.DataBind();
table1.Visible = true;
}
protected void CheckoutButton_Click(object sender, EventArgs e)
{
User temp = (User)Session["user"];
if (temp == null)
{
Response.Write("<script>alert('על מנת לרכוש מוצרים עליך להיות לקוח רשום')</script>");
Response.Write("<script>window.open('http://localhost:49675/GuestHome.aspx');</script>");
return;
}
ShoppingBag sb = (ShoppingBag)Session["myShoppingBag"];
if (sb == null || sb.isEmpty())
{
Response.Write("<script>alert('הסל ריק')</script>");
return;
}
//delete all the prescription from database
presList = (List <DataSet>)Session["presList"];
int presId;
PrescriptioService ps = new PrescriptioService();
if (presList != null)
{
foreach (DataSet d in presList)
{
presId = Convert.ToInt32(d.Tables[0].Rows[0]["PrescriptionId"].ToString());
ps.DeletePrescription(presId);
}
}
//update all the medicine stock according to the current count
Pharmcy.PharmcyWS webser = new Pharmcy.PharmcyWS();
int totalPrice = sb.GetTotalPrice();
List <MedicineInBag> medList = sb.GetProducts();
int countOfMedicine = 0, size = sb.getSize(), index = 0;
//create medicineInBag variables
string[] id = new string[size], name = new string[size], pn = new string[size], cn = new string[size];
int[] price = new int[size], s = new int[size], pro = new int[size], cat = new int[size], count = new int[size];
bool[] p = new bool[size];
foreach (MedicineInBag m in medList)
{
id[index] = m.CMedicineId;
name[index] = m.CMedicineName;
pn[index] = m.CMedicineInBagProducerName;
cn[index] = m.CMedicineInBagCatagoryName;
price[index] = m.CMedicinePrice;
s[index] = m.CMedicineStock;
pro[index] = m.CMedicineProducer;
cat[index] = m.CMedicineCatagory;
p[index] = m.CMedicineNeedPrescription;
count[index] = m.CMedicineInBagMedicineCount;
index++;
/////////////////////////////////////////////////////////////////////////
/*
* int currentStock = webser.GetMedicineStock(Convert.ToInt32(m.CMedicineId));
* countOfMedicine = currentStock - m.CMedicineInBagMedicineCount;
* webser.UpdateMedCount(countOfMedicine,Convert.ToInt32(m.CMedicineId));
*/
//////////////////////////////////////////////////////////////////////////
}
//inseat to data base
User u = (User)Session["user"];
/*
*
* ///////////
* os.InsertOrder(o);
* ////////////////
* ///*/
////////////////////////////////////////////////////////////////////////////
webser.InseartOrder(id, name, price, p, s, pro, cat, pn, cn, count, u.CUserId);
////////////////////////////////////////////////////////////////////////////
//init the shopping bag and the prescription list
presList = new List <DataSet>();
Session["presList"] = new List <DataSet>();
sb = new ShoppingBag();
Session["myShoppingBag"] = new ShoppingBag();
Response.Write("<script>alert('ההזמנה בוצעה בהצלחה, עלות ההזמנה היא: " + totalPrice + " שקלים')</script>");
SortButton_Click(sender, e);
}
protected void SearchReasultGrid_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "AddMedicine")
{
//check if the user is logged in, if not get him a message about it and redirect him to the regestrataion page
User s = (User)Session["user"];
if (s == null)
{
Response.Write("<script>alert('על מנת לרכוש מוצרים עליך להיות לקוח רשום')</script>");
Response.Write("<script>window.open('http://localhost:49675/GuestHome.aspx','_blank');</script>");
return;
}
//get the shopping bag
myShoppingBag = (ShoppingBag)Session["myShoppingBag"];
int rowNumber = Convert.ToInt32(e.CommandArgument);
//create the medicineInBag var
Pharmcy.PharmcyWS webser = new Pharmcy.PharmcyWS();
MedicineInBag MIB = new MedicineInBag();
MIB.CMedicineName = SearchReasultGrid.Rows[rowNumber].Cells[1].Text;
MIB.CMedicineId = SearchReasultGrid.Rows[rowNumber].Cells[0].Text;
MIB.CMedicinePrice = Convert.ToInt32(SearchReasultGrid.Rows[rowNumber].Cells[2].Text);
MIB.CMedicineInBagMedicinePrice = Convert.ToInt32(MIB.CMedicinePrice);
MIB.CMedicineNeedPrescription = Convert.ToBoolean(SearchReasultGrid.Rows[rowNumber].Cells[6].Text);
MIB.CMedicineStock = Convert.ToInt32(SearchReasultGrid.Rows[rowNumber].Cells[3].Text);
//same in MedicineCatagory
MIB.CMedicineProducer = webser.GetMedicineProducer(Convert.ToInt32(MIB.CMedicineId));
MIB.CMedicineCatagory = webser.GetMedicineCatagory(Convert.ToInt32(MIB.CMedicineId));
DataSet temp = webser.GetMedicineCataAndProName(MIB.CMedicineCatagory, MIB.CMedicineProducer);
MIB.CMedicineInBagCatagoryName = temp.Tables[0].Rows[0]["MedicineCatagoryName"].ToString();
MIB.CMedicineInBagProducerName = temp.Tables[0].Rows[0]["MedicineProducerName"].ToString();
///////////////////////////////////////////////////////////////////////////////////
//check count of medicine
//because we didnt change the current stock of the medicine we need to check if there is
//enough from this medicine to buy
int countOfMedicine = myShoppingBag.GetMedicineCount(Convert.ToInt32(MIB.CMedicineId));
User u = (User)Session["user"];
if (MIB.CMedicineStock - countOfMedicine <= 0)
{
Response.Write("<script>alert('אין מספיק תרופות במלאי')</script>");
return;
}
///////////////////////////////////////////////////////////////////////////////////
//check prescription
int MedIdNumber = Convert.ToInt32(MIB.CMedicineId);
//still dont change the current stock of medicine
if (MIB.CMedicineNeedPrescription)
{
PrescriptioService ps = new PrescriptioService();
DataSet ds = ps.GetPrescriptionByMedicineId(MedIdNumber, u.CUserId);
if (ds.Tables[0].Rows.Count == 0)
{
Response.Write("<script>alert('תרופה זאת צריכה מרשם')</script>");
return;
}
else
{
//לבדוק אם הוא באמת הכניס אותה כמות
//אם הוא הכניס אותה כמות אז הכל בסדר
//צריך לזכור לבטל את המרשם ברגע שהקנייה מתבצעת
//אם הכמות לא שווה אז ליידע את הלקוח שהוא צריך לבדוק כמה כדורים נתנו לו
//אפשרות לחשוף קישור בדף לעמוד של המרשמים כדי שיוכל להסתכל
//או שאפשר להגיד למשתמש כמה כדורים הוא יכול לקחת(מעדיף שלא נשמע קצת מוזר)
presList = (List <DataSet>)Session["presList"];
if (presList != null)
{
foreach (DataSet d in presList)
{
if (ds.Tables[0].Rows[0]["PrescriptionId"].ToString() == d.Tables[0].Rows[0]["PrescriptionId"].ToString())
{
Response.Write("<script>alert('מרשם זה כבר שומש')</script>");
return;
}
}
}
presList.Add(ds);
Session["presList"] = presList;
int count = Convert.ToInt32(ds.Tables[0].Rows[0]["PrescriptionMedicineCount"].ToString());
MIB.CMedicineInBagMedicineCount = count;
}
}
else
{
MIB.CMedicineInBagMedicineCount = 1;
}
myShoppingBag.AddMedicine(MIB);
Session["myShoppingBag"] = myShoppingBag;
Response.Write("<script>alert('המוצר הוסף לסל')</script>");
CheckoutButton.Visible = true;
SeeShoppingBag.Visible = true;
}
}
protected void SortButton_Click(object sender, EventArgs e)
{
string order = " ORDER BY ", temp = order;
if (HighToLow.Checked)
{
if (order.Equals(temp))
{
order += "OrderTotalMoney DESC";
}
else
{
order += ",OrderTotalMoney DESC";
}
}
if (LowToHigh.Checked)
{
if (order.Equals(temp))
{
order += "OrderTotalMoney ASC";
}
else
{
order += ",OrderTotalMoney ASC";
}
}
if (SortUser.Checked)
{
if (order.Equals(temp))
{
order += "OrderUserId ASC";
}
else
{
order += ",OrderUserId ASC";
}
}
if (SortDate.Checked)
{
if (order.Equals(temp))
{
order += "OrderDate";
}
else
{
order += ",OrderDate";
}
}
if (IsSupplied.Checked)
{
if (order.Equals(temp))
{
order += "OrderIsSupplied";
}
else
{
order += ",OrderIsSupplied";
}
}
if (order.Equals(temp))
{
order = "";
}
Pharmcy.PharmcyWS webser = new Pharmcy.PharmcyWS();
//sort the orders
DataSet ds = webser.GetAllOrders(order);
if (ds.Tables[0].Rows.Count != 0)
{
ShowOrder.Visible = true;
ShowDetails.Visible = false;
CloseOrders.Visible = true;
ShowOrder.DataSource = ds;
ShowOrder.DataBind();
}
else
{
CloseOrders_Click(sender, e);
Response.Write("<script>alert('לא נמצאו הזמנות')</script>");
}
}
