protected void Page_Load(object sender, EventArgs e)
{
CostManagerClass cmc = new CostManagerClass();
gv1.DataSource = cmc.viewItems();
gv1.DataBind();
}
protected void b1_Click(object sender, EventArgs e)
{
CostManagerClass cm = new CostManagerClass();
IQueryable <bill_master> ib = cm.viewBills(Int32.Parse(tb.Text));
gv1.DataSource = ib;
gv1.DataBind();
}
protected void CreateBill_click(object sender, EventArgs e)
{
CostManagerClass cm = new CostManagerClass();
int cid = Int32.Parse(tb.Text);
cm.createBill(cid);
// Response.Redirect("CM_View_CreateBill.aspx");
}
protected void pay_btn_Click(object sender, EventArgs e)
{
DataClassesDataContext dc = new DataClassesDataContext();
CostManagerClass cmc = new CostManagerClass();
cmc.billPaid(bill_id);
Response.Redirect("home.aspx");
}
protected void register_btn_Click(object sender, EventArgs e)
{
item i = new item();
i.name = Name_tb.Text;
i.cost_per_item = Int32.Parse(Cost_tb.Text);
CostManagerClass cm = new CostManagerClass();
cm.addItem(i);
}
protected void add_new_bill_btn_Click(object sender, EventArgs e)
{
CostManagerClass cm = new CostManagerClass();
int billid = cm.createBill(int.Parse(Request.QueryString["caseid"]));
if (billid > 0)
{
Response.Redirect("DoctorCaseAddNewBill.aspx?billid=" + billid);
}
}
protected void Button_click(object s, EventArgs e)
{
CostManagerClass cm = new CostManagerClass();
int billid = Int32.Parse(Session["BillId"].ToString());
int itemid = Int32.Parse(tb.Text);
int qty = Int32.Parse(tb2.Text);
cm.addItemsToBill(billid, itemid, qty);
Response.Redirect("CM_ViewBillItems.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["BillId"] == null)
{
Response.Redirect("CM_View_CreateBill.aspx");
}
CostManagerClass cm = new CostManagerClass();
List <ItemsInBill> x = cm.viewItemsInBill(Int32.Parse(Session["BillId"].ToString()));
gv1.DataSource = x;
gv1.DataBind();
}
protected void pay(object sender, EventArgs e)
{
CostManagerClass cmc = new CostManagerClass();
bool res = cmc.giveSalaries();
if (res == false)
{
l1.Text = "Not Enough Balance. NONE Of the doctors have been paid ";
}
else
{
Response.Redirect("AdminSeeHistory.aspx");
}
}
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;
}
}
