public List <doctor> viewDoctors() { var Doctors = from x in dc.GetTable <doctor>() select x; return(Doctors.ToList()); }
public IQueryable <room_master> viewRooms() { var v = from x in dc.GetTable <room_master>() select x; return(v); }
protected void submit_appointment_btn_Click(object sender, EventArgs e) { DataClassesDataContext dc = new DataClassesDataContext(); case_master c = new case_master(); c.patientid = int.Parse(Session["pid"].ToString()); c.date = Convert.ToDateTime(case_date.Text); c.chiefcomplaint = chief_complaint_tb.Text; c.isactive = "yes"; dc.case_masters.InsertOnSubmit(c); dc.SubmitChanges(); doctor_case doc_case = new doctor_case(); var cas = from case_master in dc.GetTable <case_master>() where case_master.patientid == int.Parse(Session["pid"].ToString()) && case_master.date == Convert.ToDateTime(case_date.Text) && case_master.chiefcomplaint == chief_complaint_tb.Text select case_master; foreach (var ca in cas) { doc_case.caseid = ca.caseid; } var query = from doctor in dc.GetTable <doctor>() where doctor.field == consult.SelectedItem.Text select doctor; foreach (var doc in query) { doc_case.doctorid = doc.doctorid; } dc.doctor_cases.InsertOnSubmit(doc_case); dc.SubmitChanges(); Response.Redirect("home.aspx"); }
public void Add(T entity) { try { db.GetTable <T>().InsertOnSubmit(entity); } catch (Exception ex) { throw new Exception(ex.Message, ex.InnerException); } }
public static List <Product> GetProductsWithNRecentReviews(int howManyReviews) { using (DataClassesDataContext data = new DataClassesDataContext()) { Table <Product> products = data.GetTable <Product>(); Table <ProductReview> reviewes = data.GetTable <ProductReview>(); List <Product> result = (from product in products where product.ProductReviews.Count == howManyReviews select product).ToList(); return(result); } }
public List <ActCases> viewActiveCases(int dr_id) { //get active cases from case_master treated by given doctor & get name of the patient var ActiveCases = from x in dc.GetTable <case_master>() join y in dc.GetTable <doctor_case>() on x.caseid equals y.caseid join z in dc.GetTable <patient>() on x.patientid equals z.patientid where x.isactive == "yes" where y.doctorid == dr_id select new { z.fname, x.ailments, x.caseid, x.chiefcomplaint, x.date, x.patientid }; // Convert to list cause can not return anonymous types. List <ActCases> lac = new List <ActCases>(); foreach (var abc in ActiveCases) //generate list { ActCases ac = new ActCases(); ac.fname = abc.fname; ac.ailments = abc.ailments; ac.caseid = abc.caseid; ac.patientid = abc.patientid; ac.date = abc.date; ac.chiefcomplaint = abc.chiefcomplaint; lac.Add(ac); } return(lac); }
protected void Page_Load(object sender, EventArgs e) { case_range.MinimumValue = DateTime.Today.ToString("dd-MM-yyyy"); case_range.MaximumValue = DateTime.Today.AddMonths(3).ToString("dd-MM-yyyy"); if (Session["username"] == null) { Response.Redirect("default.aspx"); } else { DataClassesDataContext dc = new DataClassesDataContext(); var profile = from patient in dc.GetTable <patient>() where patient.patientid == int.Parse(Session["pid"].ToString()) || patient.fname == Session["username"].ToString() select patient; foreach (var p in profile) { patient_pic.ImageUrl = p.pictureurl.ToString(); name.Text = p.fname + p.lname; patient_name_lb.Text = p.fname + " " + p.mname + " " + p.lname; patient_gender_lb.Text = p.gender; dob_lb.Text = p.dob.ToString("dd-MM-yyyy"); patient_age_lb.Text = p.age.ToString(); maritalstatus_lb.Text = p.maritalstatus; patient_bg_lb.Text = p.bloodgroup; email_lb.Text = p.email; phoneno_lb.Text = p.phoneno; address_lb.Text = p.address; } var myquery = from case_master in dc.GetTable <case_master>() where case_master.patientid == int.Parse(Session["pid"].ToString()) select case_master; int cnt = 0; foreach (var cases in myquery) { cnt++; } if (cnt != 0) { var query = from case_master in dc.GetTable <case_master>() join patient in dc.GetTable <patient>() on case_master.patientid equals patient.patientid where case_master.patientid == int.Parse(Session["pid"].ToString()) || patient.fname == Session["username"].ToString() select case_master; gvTab.DataSource = query; gvTab.DataBind(); } else if (cnt == 0) { // gvTab.DataSource = myquery; // gvTab.DataBind(); grid_not_visible.Text = "No data found"; } } }
protected void login_Click(object sender, EventArgs e) { CommonClass cm = new CommonClass(); DataClassesDataContext dc = new DataClassesDataContext(); patient p = new patient(); p.email = email_tb.Text; p.password = password_tb.Text; bool b = cm.login(p); if (b) { var q = from patient in dc.GetTable <patient>() where patient.email == email_tb.Text && patient.password == password_tb.Text select patient; foreach (var a in q) { Session["username"] = a.fname; Session["pid"] = a.patientid; } // Session["username"] = email_tb.Text; Response.Redirect("home.aspx"); } else { error.Text = "email or password is incorrect.!"; //Response.Redirect("login.aspx"); } }
protected void login_btn_Click(object sender, EventArgs e) { if (email_tb.Text == "admin" && password_tb.Text == "admin") { Session["admin"] = 1; Response.Redirect("AdminHome.aspx"); } DoctorClass cm = new DoctorClass(); DataClassesDataContext dc = new DataClassesDataContext(); doctor p = new doctor(); p.email = email_tb.Text; p.password = password_tb.Text; bool b = cm.login(p); if (b) { var q = from doctor in dc.GetTable <doctor>() where doctor.email == email_tb.Text && doctor.password == password_tb.Text select doctor; foreach (var a in q) { Session["doctorname"] = a.name; Session["doctorId"] = a.doctorid; } // Session["username"] = email_tb.Text; Response.Redirect("DoctorHome.aspx"); } else { error.Text = "email or password is incorrect"; //Response.Redirect("login.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["username"] == null) { Response.Redirect("default.aspx"); } DataClassesDataContext dc = new DataClassesDataContext(); var query = from patient in dc.GetTable <patient>() where patient.patientid == int.Parse(Session["pid"].ToString()) select patient; if (!this.IsPostBack) { foreach (var d in query) { first_name_tb.Text = d.fname; mid_name_tb.Text = d.mname; last_name_tb.Text = d.patientid.ToString(); gender_dl.SelectedItem.Text = d.gender; phoneno_tb.Text = d.phoneno; DropDownList1.SelectedItem.Text = d.maritalstatus; DropDownList2.SelectedItem.Text = d.bloodgroup; dob.Text = d.dob.ToString("dd-MM-yyyy"); Address_tb.Text = d.address; occupation_tb.Text = d.occupation; patient_pic.ImageUrl = d.pictureurl; ViewState["pictureurl"] = d.pictureurl; } } }
protected void Page_Load(object sender, EventArgs e) { DataClassesDataContext db = new DataClassesDataContext(); System.Data.Linq.Table <JB_gysxx> table = db.GetTable <JB_gysxx>(); GridView1.DataSource = table; GridView1.DataBind(); }
protected void Button7_Click(object sender, EventArgs e) { // DataClassesDataContext db = new DataClassesDataContext(); System.Data.Linq.Table <JB_khxx> table = db.GetTable <JB_khxx>(); GridView1.DataSource = table; GridView1.DataBind(); }
public static List <Product> GetNProductsFromCategory(string categoryName, int n) { DataClassesDataContext data = new DataClassesDataContext(); Table <Product> products = data.GetTable <Product>(); List <Product> result = (from product in products where product.ProductSubcategory.ProductCategory.Name == categoryName select product).Take(n).ToList(); return(result); }
public void MethodSyntaxGetProductWithoutCategoryTest() { using (DataClassesDataContext dataContext = new DataClassesDataContext()) { Table <Product> productTable = dataContext.GetTable <Product>(); List <Product> products = productTable.ToList(); products = products.GetProductsWithoutCategoryMS(); Assert.AreEqual(209, products.Count); } }
protected void add_item_into_bill_btn_Click(object sender, EventArgs e) { int cnt1 = 0; CostManagerClass cm = new CostManagerClass(); DataClassesDataContext dc = new DataClassesDataContext(); //var query = from item in dc.GetTable<item>() where item.name == itemname_dd.SelectedItem.Text select item; //foreach(var q in query) var c = from bill_item in dc.GetTable <bill_item>() where bill_item.billid == int.Parse(Request.QueryString["billid"]) select bill_item; foreach (var a in c) { if (a.itemid == int.Parse(itemname_dd.SelectedItem.Value)) { cnt1 = 1; } } if (cnt1 == 0) { if (cm.addItemsToBill(int.Parse(Request.QueryString["billid"]), int.Parse(itemname_dd.SelectedItem.Value), int.Parse(qty_tb.Text))) { int cnt = 0; var q = from bill_item in dc.GetTable <bill_item>() join item in dc.GetTable <item>() on bill_item.itemid equals item.itemid where bill_item.billid == int.Parse(Request.QueryString["billid"]) select new { item.itemid, item.name, item.cost_per_item, bill_item.qty }; foreach (var a in q) { cnt++; } if (cnt >= 1) { item_grid.DataSource = q; item_grid.DataBind(); } else { grid_not_visible.Text = "No Data Found.!"; } } } else { l1.Text = "you already selected " + itemname_dd.SelectedItem.Text; } }
public static int GetTotalStandardCostByCategory(ProductCategory category) { using (DataClassesDataContext data = new DataClassesDataContext()) { Table <Product> products = data.GetTable <Product>(); decimal result = (from product in products where (product.ProductSubcategory.ProductCategory.ProductCategoryID == category.ProductCategoryID || product.ProductSubcategory.ProductCategory.Name == category.Name) select product.StandardCost).ToList().Sum(); return((int)result); } }
public static List <Product> GetNRecentlyReviewedProducts(int howManyProducts) { using (DataClassesDataContext data = new DataClassesDataContext()) { Table <ProductReview> reviewes = data.GetTable <ProductReview>(); List <Product> result = (from review in reviewes orderby review.ReviewDate descending group review.Product by review.ProductID into p select p.First()).Take(howManyProducts).ToList(); return(result); } }
protected void update_case_btn_Click(object sender, EventArgs e) { DataClassesDataContext dc = new DataClassesDataContext(); var query = (from case_master in dc.GetTable <case_master>() where case_master.caseid == int.Parse(Request.QueryString["caseid"]) select case_master).SingleOrDefault(); query.examinationresult = Examination_result_tb.Text; query.reportrequirement = report_tb.Text; query.treatments = treatmentplan_tb.Text; query.ailments = ailment_tb.Text; dc.SubmitChanges(); Response.Redirect("DoctorCase.aspx?caseid=" + Request.QueryString["caseid"]); }
protected void OnRowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { int bill_id = int.Parse(billgv.DataKeys[e.Row.RowIndex].Value.ToString()); //l1.Text = bill_id.ToString(); DataClassesDataContext dc = new DataClassesDataContext(); var q = from bill_item in dc.GetTable <bill_item>() join item in dc.GetTable <item>() on bill_item.itemid equals item.itemid where bill_item.billid == bill_id select new { item.itemid, item.name, item.cost_per_item, bill_item.qty }; GridView itemgrid = e.Row.FindControl("itemgv") as GridView; itemgrid.DataSource = q; itemgrid.DataBind(); } }
public List <OFFER_TYPE> getAllOfferTypes() { List <OFFER_TYPE> allFlyers = new List <OFFER_TYPE>(); using (DataClassesDataContext context = new DataClassesDataContext()) { var result = (from a in context.GetTable <OFFER_TYPE>() select a);; foreach (OFFER_TYPE f in result) { allFlyers.Add(f); } } return(allFlyers); }
public List <PRODUCT_TYPE> getAllCategoryTypes(int catID) { List <PRODUCT_TYPE> allTypes = new List <PRODUCT_TYPE>(); using (DataClassesDataContext context = new DataClassesDataContext()) { var result = (from a in context.GetTable <PRODUCT_TYPE>() where a.CATEGORY_ID == catID select a).ToList <PRODUCT_TYPE>(); foreach (PRODUCT_TYPE f in result) { allTypes.Add(f); } } return(allTypes); }
public User doLogin(string username, string password) { User validUser = null; using (DataClassesDataContext context = new DataClassesDataContext()) { var user = (from a in context.GetTable <User>() where (a.USER_NAME == username && a.USER_PASSWORD == password) select a).FirstOrDefault <User>(); if (user != null) { validUser = user; } } return(validUser); }
public List <User> getAllUsers() { try { using (DataClassesDataContext context = new DataClassesDataContext()) { var users = (from a in context.GetTable <User>() select a).ToList <User>(); return(users); } } catch (Exception e) { return(null); } }
public void SplitProductsIntoPagesTest() { using (DataClassesDataContext dataContext = new DataClassesDataContext()) { int size = 20; int pages = 2; Table <Product> productTable = dataContext.GetTable <Product>(); List <Product> productsFromDB = productTable.ToList(); List <Product> productsSplited = productsFromDB.SplitProductsIntoPages(size, pages); Assert.AreEqual(size, productsSplited.Count); for (int i = 0; i < size; i++) { Assert.AreEqual(productsFromDB[i + size * pages], productsSplited[i]); } } }
public List <PROD_TYPE_TEMPLATE> getAllTypeSpecs(int typeID) { List <PROD_TYPE_TEMPLATE> allTypes = new List <PROD_TYPE_TEMPLATE>(); using (DataClassesDataContext context = new DataClassesDataContext()) { var result = (from a in context.GetTable <PROD_TYPE_TEMPLATE>() where a.TYPE_ID == typeID select a).ToList <PROD_TYPE_TEMPLATE>(); foreach (PROD_TYPE_TEMPLATE f in result) { allTypes.Add(f); } } return(allTypes); }
public bool login(doctor p) { int cnt = 0; DataClassesDataContext dc = new DataClassesDataContext(); var query = from doctor in dc.GetTable <doctor>() where doctor.email == p.email && doctor.password == p.password select doctor; foreach (var q in query) { cnt++; } if (cnt == 1) { return(true); } else { return(false); } }
public bool login(patient p) { int cnt = 0; DataClassesDataContext dc = new DataClassesDataContext(); var query = from patient in dc.GetTable <patient>() where patient.email == p.email && patient.password == p.password select patient; foreach (var q in query) { cnt++; } if (cnt == 1) { return(true); } else { return(false); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["doctorname"] == null) { Response.Redirect("DoctorLogin.aspx"); } DataClassesDataContext dc = new DataClassesDataContext(); if (!this.IsPostBack) { var query = from item in dc.GetTable <item>() select item; foreach (var b in query) { ListItem it = new ListItem(); it.Text = b.name; it.Value = b.itemid.ToString(); itemname_dd.Items.Add(it); } } }
public int approveRejectFlyer(int flyerID, bool flag) { try { using (DataClassesDataContext context = new DataClassesDataContext()) { var flyer = (from a in context.GetTable <OFFER_FLYER>() where (a.FLYER_ID == flyerID) select a).FirstOrDefault <OFFER_FLYER>(); if (flyer != null) { flyer.FLYER_APPROVED = flag; context.SubmitChanges(); } } return(flyerID); } catch (Exception e) { return(-1); } }
public int updatePassword(int userID, string password) { try { using (DataClassesDataContext context = new DataClassesDataContext()) { var user = (from a in context.GetTable <User>() where (a.USER_ID == userID) select a).FirstOrDefault <User>(); if (user != null) { user.USER_PASSWORD = password; context.SubmitChanges(); } } return(userID); } catch (Exception e) { return(-1); } }