public DataTable GetSealedComptetion(string date)
{
DBservices dbs = new DBservices();
date = (date != null ? date : "");
dbs = dbs.ReadFromDataBase(26, date);
return dbs.dt;
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
DDL = new DropDownList();
ListItem item = new ListItem();
DBservices dbs = new DBservices();
List<string> itemList = new List<string>();
itemList = dbs.getVendorName();
DDL.Items.Add(" ");
foreach (string name in itemList)
{
DDL.Items.Add(name);
}
DDL.SelectedIndexChanged += new EventHandler(dynamicDDL_SelectedIndexChanged);
VendorDDL.Controls.Add(DDL);
}
catch (Exception ex)
{
ErrHandler.WriteError(ex.Message);
Response.Write("ארעה שגיאה");
}
}
public string Delete(string username)
{
int return_val = 0;
LogFiles lf = new LogFiles();
DBservices dbs = new DBservices();
string Response= "";
username = username.Replace("'", "''");
try
{
return_val = dbs.DeleteDatabase("Rider",username);
}
catch (Exception ex)
{
Response = ("Error in the Delete process the Rider(user) database " + ex.Message);
lf.Main("Users", Response);
return "Error";
}
lf.Main("Users", Response);
if (return_val <= 0)
{
Response = "The Rider " + username + " was not Deleted from the Database";
lf.Main("Users", Response);
return "Error";
}
else
{
Response = "The Rider " + username + " was Deleted from the Database";
lf.Main("Users", Response);
return "Success";
}
}
public string Put(string CompetitionDate, [FromBody]Competition cmpt)
{
string userName = string.Empty;
if (System.Web.HttpContext.Current != null && System.Web.HttpContext.Current.User.Identity.IsAuthenticated)
{
if (User.Identity.IsAuthenticated)
userName = User.Identity.Name;
}
DBservices dbs = new DBservices();
int return_val = 0;
LogFiles lf = new LogFiles();
List<Object> mlist = new List<Object>();
mlist.Add(cmpt);
try
{
return_val = dbs.updateCompetitionInDatabase(cmpt, CompetitionDate);
}
catch (Exception ex)
{
string Response = ("Error updating the Competition database " + ex.Message);
lf.Main("Competition", Response);
return "Error";
}
if (return_val == 0) { return "Error"; }
return "Success";
}
public DataTable Get(string date)
{
DBservices dbs = new DBservices();
dbs = dbs.ReadFromDataBase(24,"50",date, "BronzeWinner");
return dbs.dt;
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
ListItem item = new ListItem();
DBservices dbs = new DBservices();
List<Item> itemList = new List<Item>();
itemList = dbs.getItem();
foreach (Item x in itemList)
{
if (x.Category == "מחטים")
DDneedle.Items.Add(x.Name);
else
if (x.Category == "סליל")
DDcoil.Items.Add(x.Name);
else
if (x.Category == "שקית עירוי")
DDinfusionBag.Items.Add(x.Name);
else
if (x.Category == "תמיסה")
DDsolutions.Items.Add(x.Name);
}
}
catch (Exception ex)
{
ErrHandler.WriteError(ex.Message);
Response.Write("ארעה שגיאה");
}
}
protected void ButtonPatient_Click(object sender, EventArgs e)
{
DBservices dbs = new DBservices();
try
{
NameValueCollection coll = Request.QueryString;
string ID = coll["P_id"];
string Kupah = (DDPatientKupah.SelectedItem).ToString();
string Zantar = (DDPatientZantar.SelectedItem).ToString();
if (Zantar == "כן")
Zantar = "1";
else
Zantar = "0";
string needle = (DDneedle.SelectedItem).ToString();
string coil = (DDcoil.SelectedItem).ToString();
string infusionBag = (DDinfusionBag.SelectedItem).ToString();
string solutions = (DDsolutions.SelectedItem).ToString();
dbs.UpDatePatient(ID, Kupah, Zantar,needle,coil,infusionBag,solutions);
Response.Redirect("PatientList.aspx");
}
catch (Exception ex)
{
ErrHandler.WriteError(ex.Message);
Response.Write("קיימת בעיה אנא נסה שנית מאוחר יותר");
}
}
public DataTable GetUser(string username)
{
DBservices dbs = new DBservices();
username = username.Replace("'", "''");
dbs = dbs.ReadFromDataBase(2, username);
return dbs.dt;
}
protected void buttenIN_Click(object sender, EventArgs e)
{
Session["Name"] = TBusername.Text;
Session["Password"] = TBpassword.Text;
DBservices dbs = new DBservices();
try
{
string iswork = dbs.chekIN(TBusername.Text, TBpassword.Text);
if (iswork == "false")
ans.Text = "שם סיסמא לא נכונים";
else
if (iswork == "worker")
Response.Redirect("OrderList.aspx",false);
else
if (iswork == "manager")
Response.Redirect("ManagementSystem/Homepage.aspx", false);
else
Response.Redirect("Meconomist.aspx",false);
}
catch (Exception ex)
{
ErrHandler.WriteError(ex.Message);
Response.Write("קיימת בעיה אנא נסה שנית מאוחר יותר");
}
}
public DataTable GetOrganization(string orgname, string gender="")
{
DBservices dbs = new DBservices();
orgname = orgname.Replace("'", "''");
dbs = dbs.ReadFromDataBase(12, orgname, gender);
return dbs.dt;
}
public DataTable Get(string orgname)
{
DBservices dbs = new DBservices();
orgname = orgname.Replace("'", "''");
dbs = dbs.ReadFromDataBase(3, orgname);
return dbs.dt;
}
public DataTable GetGroup(string grpname, string orgname)
{
DBservices dbs = new DBservices();
orgname = orgname.Replace("'", "''");
grpname = grpname.Replace("'", "''");
dbs = dbs.ReadFromDataBase(4, grpname, orgname);
return dbs.dt;
}
public DataTable GetRank(string username, string date)
{
DBservices dbs = new DBservices();
username = (username != null ? username : "");
date = (date != null ? date : "");
dbs = dbs.ReadFromDataBase(19, username, date);
return dbs.dt1 ;
}
public DataTable GetOrganizationRank(string gender, string order, string date)
{
DBservices dbs = new DBservices();
gender = (gender != null ? gender : "");
order = (order != null ? order : "Points");
date = (date != null ? date : "");
dbs = dbs.ReadFromDataBase(17, gender, order, date);
return dbs.dt;
}
public string GetEmail(string email)
{
DBservices dbs = new DBservices();
dbs = dbs.ReadFromDataBase(14, email);
if (dbs.dt.Rows.Count > 0)
return dbs.dt.Rows[0].ItemArray[0].ToString();
else
return "NOT EXISTS";
}
protected void Page_Load(object sender, EventArgs e)
{
int runNum = 0;
try
{
DropDownList DDL = sender as DropDownList;
DBservices dbs = new DBservices();
List<Message> ListMessage = new List<Message>();
Table MessageTbl = new Table();
ListMessage = dbs.ReadMessage();
MessageTbl.Attributes.Add("class", "CSSTableGenerator");
TableRow CRow = new TableRow();
TableCell CHEAKCell = new TableCell();
CHEAKCell.Text = "סימון למחיקה";
CRow.Cells.Add(CHEAKCell);
TableCell MessageCell = new TableCell();
MessageCell.Text = "הודעות";
CRow.Cells.Add(MessageCell);
MessageTbl.Rows.Add(CRow);
foreach (Message x in ListMessage)
{
TableRow tRow = new TableRow();
TableCell ChekCell = new TableCell();
CheckBox ChekItem = new CheckBox();
ChekItem.ID = "ChekBox" + (runNum++).ToString();
ChekCell.Controls.Add(ChekItem);
tRow.Cells.Add(ChekCell);
TableCell textCell = new TableCell();
textCell.Text = x.Text_message;
tRow.Cells.Add(textCell);
MessageTbl.Rows.Add(tRow);
}
divmessage.Controls.Add(MessageTbl);
Session["MessageTbl"] = MessageTbl;
}
catch (Exception ex)
{
ErrHandler.WriteError(ex.Message);
Response.Write("ארעה שגיאה");
}
}
public string GetEmail(string orgname)
{
DBservices dbs = new DBservices();
orgname = orgname.Replace("'", "''");
dbs = dbs.ReadFromDataBase(23, orgname);
if (dbs.dt.Rows.Count > 0)
return dbs.dt.Rows[0].ItemArray[0].ToString();
else
return "NOT EXISTS";
}
public DataTable GetGroupRank(string orgname, string gender, string order, string date)
{
DBservices dbs = new DBservices();
orgname = (orgname != "all" ? orgname : "");
gender = (gender != null ? gender : "");
order = (order != null ? order : "Points");
date = (date != null ? date : "");
orgname = orgname.Replace("'", "''");
dbs = dbs.ReadFromDataBase(16, orgname, gender, order, date);
return dbs.dt;
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
string id = Request.QueryString["id"];
DataTable dt = new DataTable();
DBservices dbs = new DBservices();
List<ItemInINV> list = new List<ItemInINV>();
int Disc = 0;
int Sum = dbs.GetTotSum(id);
list = dbs.GetITEMINV(ID);
LBLsum.Text = Sum.ToString() + " :סכום";
dt.Columns.Add("Reason");
dt.Columns.Add("SN");
dt.Columns.Add("Credit");
foreach (ItemInINV x in list)
{
DataRow row = dt.NewRow();
row[0] = "חיוב זיכוי";
row[1] = x.Sn;
row[2] = ((x.It_price - x.Inv_price) * x.Inv_quant);
dt.Rows.Add(row);
Disc += Convert.ToInt32(row[2]);
}
GV_PayTBL.DataSource = dt;
GV_PayTBL.DataBind();
//DataGrid DG = new DataGrid();
//DG.DataSource = dt;
//DG.DataBind();
//Mailmsg msg = new Mailmsg();
//string Body = msg.RenderControl(DG);
//msg.Send(Body, "חשבונית");
LBLdis.Text = (Sum + Disc).ToString() + " :סכום לאחר זיכוי";
}
catch (Exception ex)
{
ErrHandler.WriteError(ex.Message);
Response.Write("ארעה שגיאה");
}
}
public void LoadUserTable()
{
DBservices db = new DBservices();
usetT = db.GetAllUsers();
userGride.DataSource = usetT;
userGride.DataBind();
AddImage();
AddCheckBox();
//load events
EventOnAir ev = new EventOnAir();
dt = ev.readTable();
}
public List<Cities> readCitiesDB()
{
DBservices dbs = new DBservices();
dbs = dbs.ReadFromDataBase(7, "Cities", "[City]");
List<Cities> cities = new List<Cities>();
foreach (DataRow dr in dbs.dt.Rows)
{
cityName = (string)dr["cityName"];
cityDes = (string)dr["cityDes"];
cityCountry = (string)dr["cityCountry"];
}
return cities;
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
NameValueCollection coll = Request.QueryString;
string ItemName = coll["Name"];
List<string> listItem = new List<string>();
DBservices dbs = new DBservices();
listItem = dbs.getItemBYsn(ItemName);
Label lbName = new Label();
lbName.Text = listItem[0].ToString();
PHIteamName.Controls.Add(lbName);
Label lbSN = new Label();
lbSN.ID = "lbSN";
lbSN.Text = listItem[1].ToString();
PHIteamNS.Controls.Add(lbSN);
Label lbCatgory = new Label();
lbCatgory.Text = listItem[2].ToString();
PHIteamCatgory.Controls.Add(lbCatgory);
Label lbNumInBox = new Label();
lbNumInBox.ForeColor = System.Drawing.Color.Red;
lbNumInBox.Text = "הכמות הנוכחית לאריזה : "+ listItem[3].ToString();
PHNumInBox.Controls.Add(lbNumInBox);
Label lbPrice = new Label();
lbPrice.ForeColor = System.Drawing.Color.Red;
lbPrice.Text = "המחיר הנוכחי : "+listItem[4].ToString();
PHTBPrice.Controls.Add(lbPrice);
Label lbvandor = new Label();
lbvandor.Text = listItem[5].ToString();
PHIteamVandor.Controls.Add(lbvandor);
}
catch (Exception ex)
{
ErrHandler.WriteError(ex.Message);
Response.Write("ארעה שגיאה");
}
}
protected void Approval_Click(object sender, EventArgs e)
{
try
{
string NumberDelivery = TBDelivery.Text;
int i = 0;
int numcheck = 0;
DBservices dbs = new DBservices();
Table TBL = new Table();
TBL = (Table)(Session["itemINoRDER"]);
int num = TBL.Rows.Count;
foreach (TableRow x in TBL.Rows)
{
if (TBL.Rows.GetRowIndex(x) != 0)
{
if (i < num - 1)
{
CheckBox itemBox = divOrder.FindControl("ChekBox" + i.ToString()) as CheckBox;
i++;
if (itemBox.Checked == true)
{
numcheck++;
DBservices.AprroveItem(NumberOrder, x.Cells[2].Text);
}
}
}
}
// string sup_date = ShippingDateCalendar.SelectedDate.ToShortDateString();
string sup_date = TBdate.Text;
if (numcheck == count)
dbs.UpDateOrder(NumberOrder, "close", NumberDelivery, sup_date);
else
dbs.UpDateOrder(NumberOrder, "partially approved", NumberDelivery, sup_date);
Response.Redirect("OrderList.aspx",false);
}
catch (Exception ex)
{
ErrHandler.WriteError(ex.Message);
Response.Write("ארעה שגיאה");
}
}
protected void dynamicDDL_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
DropDownList DDL = sender as DropDownList;
string vendor = (DDL.SelectedItem).ToString();
DBservices dbs = new DBservices();
string SNvendor = dbs.getVendorSN(vendor);
Session["vendor"] = SNvendor;
}
catch (Exception ex)
{
ErrHandler.WriteError(ex.Message);
Response.Write("ארעה שגיאה");
}
}
public string Put(string cap_usr, string new_cap_usr)
{
int return_val = 0;
LogFiles lf = new LogFiles();
DBservices dbs = new DBservices();
Rider rdr = new Rider();
try
{
return_val = dbs.updateRiderInDatabase(rdr, cap_usr, new_cap_usr);
}
catch (Exception ex)
{
string Response = ("Error while trying to switch the Captain(user) " + cap_usr + " in the database: " + ex.Message);
lf.Main("Users", Response);
return "Error";
}
if (return_val == 0) { return "Error"; }
return "Success";
}
protected void AddMessage_Click(object sender, EventArgs e)
{
DBservices dbs = new DBservices();
try
{
string text_message =TBnewMessage.Text;
dbs.insertNewMessage(text_message);
Response.Write("<script>alert('נוספה הודעה חדשה במערכת');</script>");
Response.Redirect("message.aspx");
}
catch (Exception ex)
{
ErrHandler.WriteError(ex.Message);
Response.Write("קיימת בעיה אנא נסה שנית מאוחר יותר");
}
}
public string updateDB([FromBody]Group grp)
{
DBservices dbs = new DBservices();
int return_val = 0;
LogFiles lf = new LogFiles();
List<Object> mlist = new List<Object>();
mlist.Add(grp);
try
{
return_val = dbs.InsertDatabase(mlist);
}
catch (Exception ex)
{
string Response = ("Error updating the Group database " + ex.Message);
lf.Main("Groups", Response);
return "Error";
}
if (return_val == 0) { return "Error"; }
return "Success";
}
public string Post([FromBody]Competition cmpt)
{
DBservices dbs = new DBservices();
int return_val = 0;
LogFiles lf = new LogFiles();
List<Object> mlist = new List<Object>();
mlist.Add(cmpt);
try
{
return_val = dbs.InsertDatabase(mlist);
}
catch (Exception ex)
{
string Response = ("Error updating the Competition database " + ex.Message);
lf.Main("Competition", Response);
return "Error";
}
if (return_val == 0) { return "Error"; }
return "Success";
}
public string updateDB([FromBody]Routes rut)
{
DBservices dbs = new DBservices();
int return_val = 0;
LogFiles lf = new LogFiles();
List<Object> mlist = new List<Object>();
mlist.Add(rut);
try
{
return_val = dbs.InsertDatabase(mlist);
}
catch (Exception ex)
{
string Response = ("Error while trying to INSERT the new Route to the database " + ex.Message);
lf.Main("Routes", Response);
return "Error";
}
if (return_val == 0) { return "Error"; }
return "Success";
}
protected void ButtonNewWorker_Click(object sender, EventArgs e)
{
DBservices dbs = new DBservices();
try
{
string Name = TBworkerName.Text;
string ID = TBworkerID.Text;
string Pass = TBworkerPass.Text;
string Title = (DDLworkerTitle.SelectedItem).ToString();
dbs.insertNewWorker(Name, ID, Pass, Title);
Response.Write("<script>alert('העובד נקלט במערכת בהצלחה');</script>");
}
catch (Exception ex)
{
ErrHandler.WriteError(ex.Message);
Response.Write("קיימת בעיה אנא נסה שנית מאוחר יותר");
}
}
// מעדכן את העמודה קונפירם לטרו
public int updateTransfer(int transferID, int status)
{
DBservices dBservices = new DBservices();
return(dBservices.updateTransfer(transferID, status));
}
public List <Architect> Read()
{
DBservices dbs = new DBservices();
return(dbs.getArchitect("PriceITConnectionString", "Architect"));
}
// מחזירה את כל ההעברות מהמורה
public DataTable getTransfersFromTeacher(int teacherID)
{
DBservices dBservices = new DBservices();
return(dBservices.getTransfersFromTeacher(teacherID));
}
public List <favorite> getMyFavorite()
{
DBservices dbs = new DBservices();
return(dbs.getMyFavorite());
}
public List <ProductForWeeklyMenu> ReadProducts(string date, string hour)
{
DBservices db = new DBservices();
return(db.GetProductsByMealType("dietDBConnectionString", date, hour));
}
// נועד ללוח השנה כאשר בוחרים להציג מידע של משימות בפועל מתוך טווח תאריכים
public List <CalendarActualTaskInEvent> GetCalendarActualTaskInEventRangeDate(CalendarActualTaskInEvent t)
{
DBservices dbs = new DBservices();
return(dbs.GetCalendarActualTaskInEventRangeDate(t.FromDate, t.ToDate));
}
void SaveFile(HttpPostedFile file)
{
try
{
String ID = null;
// Specify the path to save the uploaded file to.
//string savePath = "c:\\temp\\";
//string savePath = "~\\Excel\\";
string savePath = Server.MapPath("~/Excel/");
// Get the name of the file to upload.
string fileName = FileUpload1.FileName;
// Create the path and file name to check for duplicates.
string pathToCheck = savePath + fileName;
// Create a temporary file name to use for checking duplicates.
string tempfileName = "";
// Check to see if a file already exists with the
// same name as the file to upload.
if (System.IO.File.Exists(pathToCheck))
{
if (FileUpload1.PostedFile.ContentType == "application/vnd.ms-excel" || FileUpload1.PostedFile.ContentType == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
{
int counter = 2;
while (System.IO.File.Exists(pathToCheck))
{
// if a file with this name already exists,
// prefix the filename with a number.
tempfileName = counter.ToString() + fileName;
pathToCheck = savePath + tempfileName;
counter++;
}
fileName = tempfileName;
// Notify the user that the file name was changed.
UploadStatusLabel.Text = "File Name: " + fileName;
}
else
{
// Notify the user that a file was not an excel file.
UploadStatusLabel.Text = "ניתן לעלות רק קבצי אקסל ו-סי אס וי";
}
}
else
{
// Notify the user that the file was saved successfully.
UploadStatusLabel.Text = "הקובץ הועלה בהצלחה.";
}
// Append the name of the file to upload to the path.
savePath += fileName;
// Call the SaveAs method to save the uploaded
// file to the specified directory.
FileUpload1.SaveAs(savePath);
//Branch_NUM INV_NUM DEL_ID SN Quant Price Sum date
//dt.Columns.Add("DEL_ID", typeof(String));
//dt.Columns.Add("SN", typeof(String));
//dt.Columns.Add("Quant", typeof(int));
//dt.Columns.Add("Price", typeof(float));
//dt.Columns.Add("Sum", typeof(float));
//dt.Columns.Add("Date", typeof(DateTime));
//dt.Columns.Add("Branch_NUM", typeof(String));
dt.Columns.Add("מספר משלוח", typeof(String));
dt.Columns.Add("מקט", typeof(String));
dt.Columns.Add("כמות", typeof(int));
dt.Columns.Add("מחיר", typeof(float));
dt.Columns.Add("סך הכל", typeof(float));
dt.Columns.Add("תאריך", typeof(DateTime));
dt.Columns.Add("מספר מכון", typeof(String));
//DEL_ID SN Quant Price Sum date Branch_NUM
string[] csvRows = File.ReadAllLines(savePath);
csvRows[0] = null;
csvRows = csvRows.Where(x => !string.IsNullOrEmpty(x)).ToArray();
string[] fields = null;
foreach (string rows in csvRows)
{
fields = rows.Split(',');
DataRow row = dt.NewRow();
row.ItemArray = fields;
dt.Rows.Add(row);
}
GridView1.Attributes.Add("class", "CSSTableGenerator");
GridView1.DataSource = dt;
GridView1.DataBind();
DBservices dbs = new DBservices();
ID = dbs.insertINV(dt);
//invinsertlbl.Text = ID + "מספר החשבונית במערכת הוא: ";
Session.Add("ID", ID);
}
catch (Exception ex)
{
ErrHandler.WriteError(ex.Message);
Response.Write("ארעה שגיאה");
}
}
public string SendSuggestion(int SenderCode, int ReceiverCode)
{
DBservices dbs = new DBservices();
return(dbs.SendSuggestion(SenderCode, ReceiverCode));
}
public void ReplySuggestion(int SuggestionCode, bool reply)
{
DBservices dbs = new DBservices();
dbs.ReplySuggestion(SuggestionCode, reply);
}
// POST: api/Order
public void Post([FromBody] string[] values)
{
DBservices db = new DBservices();
db.insertOrder(values);
}
public List <City> GetTopFiveCitiesFromDB()
{
DBservices dbs = new DBservices();
return(dbs.GetAllCitiesFromDB("ConnectionStringPerson"));
}
public int Increase_OrderNum(string Attraction_ID)
{
DBservices dbs = new DBservices();
return(dbs.Increase_OrderNum(Attraction_ID));
}
public List <Promotion> GetPromotedAttraction(int Agent_ID)
{
DBservices dbs = new DBservices();
return(dbs.GetPromotedAttraction(Agent_ID));;
}
public int RemoveTripProfile(string attractionID, int tripProfile, int AgentID)
{
DBservices dbs = new DBservices();
return(dbs.RemoveTripProfile(attractionID, tripProfile, AgentID));
}
public int postTransfer(Transfer transfer)
{
DBservices dBservices = new DBservices();
return(dBservices.postTransfer(transfer));
}
public void deleteArc(int Id)
{
DBservices dbs = new DBservices();
int numAffected = dbs.deleteArc(Id);
}
public InvDetails()
{
DBservices db = new DBservices();
}
public int insert_task(ToDoList task)
{
DBservices dbs = new DBservices();
return(dbs.insert_task(task));
}
public List <sale> getDiscountTable()
{
DBservices dbs = new DBservices();
return(dbs.getDiscountTable());
}
public int updateTask(int taskID, int agent_ID, int completed)
{
DBservices dbs = new DBservices();
return(dbs.updateTask(taskID, agent_ID, completed));
}
public List <SuggestionResult> GetSuggestions(int UserCode, bool IsApproved)
{
DBservices dbs = new DBservices();
return(dbs.GetSuggestions(UserCode, IsApproved));
}
protected void Page_Load(object sender, EventArgs e)
{
List <Patient> listPatient = new List <Patient>();
try
{
if (!IsPostBack)
{
ListItem item = new ListItem();
DBservices dbs = new DBservices();
List <Item> itemList = new List <Item>();
itemList = dbs.getItem();
foreach (Item x in itemList)
{
if (x.Category == "מחטים")
{
DDneedle.Items.Add(x.Name);
}
else
if (x.Category == "סליל")
{
DDcoil.Items.Add(x.Name);
}
else
if (x.Category == "שקית עירוי")
{
DDinfusionBag.Items.Add(x.Name);
}
else
if (x.Category == "תמיסה")
{
DDsolutions.Items.Add(x.Name);
}
}
DropDownList DDL = sender as DropDownList;
NameValueCollection coll = Request.QueryString;
string IdPatient = coll["P_id"];
listPatient = dbs.InfoPatient(IdPatient);
foreach (Patient x in listPatient)
{
Label lbName = new Label();
lbName.Text = x.Name;
PHPatientName.Controls.Add(lbName);
Label lbNum = new Label();
lbNum.Text = x.Num;
PHPatientNum.Controls.Add(lbNum);
Label lbID = new Label();
lbID.Text = x.P_id;
PHPatientID.Controls.Add(lbID);
DDPatientKupah.SelectedValue = x.Kupah;
if (x.Zantar == "False")
{
DDPatientZantar.SelectedValue = "לא";
}
else
{
DDPatientZantar.SelectedValue = "כן";
}
DDneedle.SelectedValue = x.Needle;
DDcoil.SelectedValue = x.Coil;
DDinfusionBag.SelectedValue = x.InfusionBag;
DDsolutions.SelectedValue = x.Solutions;
}
}
}
catch (Exception ex)
{
ErrHandler.WriteError(ex.Message);
Response.Write("ארעה שגיאה");
}
}
public string CheckActiveSuggestions(int SenderCode, int ReceiverCode)
{
DBservices dbs = new DBservices();
return(dbs.CheckActiveSuggestions(SenderCode, ReceiverCode));
}
public void CancelSuggestion(int SuggestionCode)
{
DBservices dbs = new DBservices();
dbs.CancelSuggestion(SuggestionCode);
}
public int removeTask(int taskID)
{
DBservices dbs = new DBservices();
return(dbs.remove_Task(taskID));
}
public void insertFavorite(Favorite fav)
{
DBservices dbs = new DBservices();
int num = dbs.insertFavorite(fav);
}
public List <ToDoList> Read_AllTasks(int Agent_ID)
{
DBservices dbs = new DBservices();
return(dbs.Read_AllTasks(Agent_ID));
}
public List <Therapist> ReadTherapist()
{
DBservices db = new DBservices();
return(db.GetTherapist());
}
public void JoinGroup(int UserCode, int GroupTrainingCode)
{
DBservices dbs = new DBservices();
dbs.JoinGroup(UserCode, GroupTrainingCode);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
DropDownList DDL = sender as DropDownList;
DBservices dbs = new DBservices();
string nameWorker = ((string)Session["name"]);
string paswordWorker = ((string)Session["password"]);
listOfOrder = dbs.ReadOrder(nameWorker, paswordWorker);
Table OrderTbl = new Table();
OrderTbl.Attributes.Add("class", "CSSTableGenerator");
TableRow CRow = new TableRow();
TableCell IdCell = new TableCell();
IdCell.Text = "מספר הזמנה";
CRow.Cells.Add(IdCell);
TableCell SdCell = new TableCell();
SdCell.Text = "תאריך קבלת הזמנה";
CRow.Cells.Add(SdCell);
TableCell PCell = new TableCell();
PCell.Text = "תאריך יצירת הזמנה";
CRow.Cells.Add(PCell);
TableCell STATUSCell = new TableCell();
STATUSCell.Text = "סטטוס הזמנה";
CRow.Cells.Add(STATUSCell);
OrderTbl.Rows.Add(CRow);
foreach (Order x in listOfOrder)
{
TableRow tRow = new TableRow();
TableCell IDceLL = new TableCell();
IDceLL.Text = x.Po_id;
tRow.Cells.Add(IDceLL);
TableCell SDATECell = new TableCell();
if (x.Sup_date != "")
{
DateTime SDATE = new DateTime();
SDATE = Convert.ToDateTime(x.Sup_date);
SDATECell.Text = SDATE.ToShortDateString();
}
else
{
SDATECell.Text = x.Sup_date;
}
tRow.Cells.Add(SDATECell);
TableCell PDATECell = new TableCell();
DateTime PDATE = new DateTime();
PDATE = Convert.ToDateTime(x.Po_date);
//PDATECell.Text = PDATE.ToShortDateString();
PDATECell.Text = PDATE.ToString("dd/MM/yy");
tRow.Cells.Add(PDATECell);
HyperLink link = new HyperLink();
link.NavigateUrl = "OrderConfirmation.aspx?Po_id=" + x.Po_id;
if (x.Status == "open")
{
link.Text = "פתוחה";
}
else if (x.Status == "cancelled")
{
link.Text = "מבוטלת";
}
else if (x.Status == "close")
{
link.Text = "אושרה";
}
else
{
link.Text = "מאושרת חלקית";
}
TableCell SCell = new TableCell();
SCell.Controls.Add(link);
tRow.Cells.Add(SCell);
OrderTbl.Rows.Add(tRow);
}
divOrder.Controls.Add(OrderTbl);
}
}
catch (Exception ex)
{
ErrHandler.WriteError(ex.Message);
Response.Write("ארעה שגיאה");
}
}
