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);
}
}
