protected void btnSave_Click(object sender, EventArgs e) { //do insert or update using (InoviceConnection db = new InoviceConnection()) { supplier_information objC = new supplier_information(); if (!String.IsNullOrEmpty(Request.QueryString["SUPPLIER_ID"])) { Int32 SUPPLIER_ID = Convert.ToInt32(Request.QueryString["SUPPLIER_ID"]); objC = (from c in db.supplier_information where c.SUPPLIER_ID == SUPPLIER_ID select c).FirstOrDefault(); } //populate the supplier from the input form objC.SUPPLIER_NAME= txtName.Text; objC.ADDRESS = txtAddress.Text; objC.CITY = txtCity.Text; objC.STATE = txtState.Text; objC.POSTAL_CODE = txtPostalCode.Text; if (String.IsNullOrEmpty(Request.QueryString["SUPPLIER_ID"])) { //add db.supplier_information.Add(objC); } //save and redirect db.SaveChanges(); Response.Redirect("SupplierList.aspx"); } }
protected void btnSave_Click(object sender, EventArgs e) { //do insert or update using (InoviceConnection db = new InoviceConnection()) { category_information objC = new category_information(); if (!String.IsNullOrEmpty(Request.QueryString["ID"])) { Int32 ID = Convert.ToInt32(Request.QueryString["ID"]); objC = (from c in db.category_information where c.ID == ID select c).FirstOrDefault(); } //populate the product category from the input form objC.CATEGORY_NAME = txtName.Text; if (String.IsNullOrEmpty(Request.QueryString["ID"])) { //add product category db.category_information.Add(objC); } //save and redirect db.SaveChanges(); Response.Redirect("categoryList.aspx"); } }
protected void btnSave_Click(object sender, EventArgs e) { //do insert or update using (InoviceConnection db = new InoviceConnection()) { product_information objC = new product_information(); if (!String.IsNullOrEmpty(Request.QueryString["PRODUCT_ID"])) { Int32 PRODUCT_ID = Convert.ToInt32(Request.QueryString["PRODUCT_ID"]); objC = (from p in db.product_information where p.PRODUCT_ID == PRODUCT_ID select p).FirstOrDefault(); } //populate the product details from the input form objC.NAME = txtName.Text; objC.QUANTITY = Convert.ToInt32(txtQuantity.Text); objC.UNIT_PRICE = Convert.ToDecimal(txtPrice.Text); objC.SUPPLIER_ID = Convert.ToInt32(ddlSupplier.SelectedValue); objC.CATEGORY_ID = Convert.ToInt32(ddlCategory.SelectedValue); if (String.IsNullOrEmpty(Request.QueryString["PRODUCT_ID"])) { //add db.product_information.Add(objC); } //save and redirect db.SaveChanges(); Response.Redirect("productList.aspx"); } }
protected void GetCategory() { using (InoviceConnection db = new InoviceConnection()) { var cate = (from c in db.category_information orderby c.CATEGORY_NAME select c); ddlCategory.DataSource = cate.ToList(); ddlCategory.DataBind(); } }
protected void GetCategory() { //populate the existing product category for editing using (InoviceConnection db = new InoviceConnection()) { Int32 ID = Convert.ToInt32(Request.QueryString["ID"]); category_information objC = (from c in db.category_information where c.ID == ID select c).FirstOrDefault(); //populate the form txtName.Text = objC.CATEGORY_NAME; } }
protected void GetProduct() { using (InoviceConnection db = new InoviceConnection()) { //append the current direction to the Sort Column String sortString = Session["SortColumn"].ToString() + " " + Session["SortDirection"].ToString(); //Get the Product Details var supp = (from p in db.product_information select new { p.PRODUCT_ID, p.NAME, p.category_information.CATEGORY_NAME, p.supplier_information.SUPPLIER_NAME,p.QUANTITY, p.UNIT_PRICE}); //bind the Product GridView grdProduct.DataSource = supp.AsQueryable().OrderBy(sortString).ToList(); grdProduct.DataBind(); } }
protected void GetSupplier() { using (InoviceConnection db = new InoviceConnection()) { //append the current direction to the Sort Column String sortString = Session["SortColumn"].ToString() + " " + Session["SortDirection"].ToString(); //Get the Product Supplier Details var supp = from s in db.supplier_information select new { s.SUPPLIER_ID, s.SUPPLIER_NAME , s.ADDRESS ,s.CITY , s.STATE , s.POSTAL_CODE}; //bind the Supplier GridView grdSupplier.DataSource = supp.AsQueryable().OrderBy(sortString).ToList(); grdSupplier.DataBind(); } }
protected void GetCategories() { using (InoviceConnection db = new InoviceConnection()) { //append the current direction to the Sort Column String sortString = Session["SortColumn"].ToString() + " " + Session["SortDirection"].ToString(); //Get the Product Category Details var category = from c in db.category_information select new { c.ID, c.CATEGORY_NAME }; //bind the Category GridView grdCategory.DataSource = category.AsQueryable().OrderBy(sortString).ToList(); grdCategory.DataBind(); } }
protected void GetOrder() { //Getting Authenticated User if (HttpContext.Current.User.Identity.IsAuthenticated) { if (HttpContext.Current.User.IsInRole("admin")) { using (InoviceConnection db = new InoviceConnection()) { //append the current direction to the Sort Column String sortString = Session["SortColumn"].ToString() + " " + Session["SortDirection"].ToString(); //Get the Product Details var order = (from o in db.order_master select new { o.ORDER_ID, o.AspNetUser.UserName, o.ORDER_DATE, o.category_information.CATEGORY_NAME, o.product_information.NAME, o.QUANTITY, o.UNIT_PRICE, total = o.UNIT_PRICE * o.QUANTITY }); //bind the Product GridView grdOrder.DataSource = order.AsQueryable().OrderBy(sortString).ToList(); grdOrder.DataBind(); } } else { using (InoviceConnection db = new InoviceConnection()) { //Get Loggedin UserId String USER_ID = HttpContext.Current.User.Identity.GetUserId(); //append the current direction to the Sort Column String sortString = Session["SortColumn"].ToString() + " " + Session["SortDirection"].ToString(); //Get the Product Details var order = (from o in db.order_master where o.USER_ID == USER_ID select new { o.ORDER_ID, o.AspNetUser.UserName, o.ORDER_DATE, o.category_information.CATEGORY_NAME, o.product_information.NAME, o.QUANTITY, o.UNIT_PRICE, total = o.UNIT_PRICE * o.QUANTITY }); //bind the Product GridView grdOrder.DataSource = order.AsQueryable().OrderBy(sortString).ToList(); grdOrder.DataBind(); } } } }
protected void GetProduct() { //populate the existing product for editing using (InoviceConnection db = new InoviceConnection()) { Int32 PRODUCT_ID = Convert.ToInt32(Request.QueryString["PRODUCT_ID"]); product_information objC = (from p in db.product_information where p.PRODUCT_ID == PRODUCT_ID select p).FirstOrDefault(); //populate the form txtName.Text = objC.NAME; txtPrice.Text = objC.UNIT_PRICE.ToString(); txtQuantity.Text = objC.QUANTITY.ToString(); ddlCategory.SelectedValue = objC.CATEGORY_ID.ToString(); ddlSupplier.SelectedValue = objC.SUPPLIER_ID.ToString(); } }
protected void grdProduct_RowDeleting(object sender, GridViewDeleteEventArgs e) { //get selected Product ID Int32 PRODUCT_ID = Convert.ToInt32(grdProduct.DataKeys[e.RowIndex].Values["PRODUCT_ID"]); using (InoviceConnection db = new InoviceConnection()) { //get selected Product product_information objC = (from p in db.product_information where p.PRODUCT_ID== PRODUCT_ID select p).FirstOrDefault(); //delete db.product_information.Remove(objC); db.SaveChanges(); //refresh grid GetProduct(); } }
protected void GetSupplier() { //populate the existing product supplier for editing using (InoviceConnection db = new InoviceConnection()) { Int32 SUPPLIER_ID = Convert.ToInt32(Request.QueryString["SUPPLIER_ID"]); supplier_information objC = (from s in db.supplier_information where s.SUPPLIER_ID == SUPPLIER_ID select s).FirstOrDefault(); //populate the form txtName.Text = objC.SUPPLIER_NAME; txtAddress.Text = objC.ADDRESS; txtCity.Text = objC.CITY; txtState.Text = objC.STATE; txtPostalCode.Text = objC.POSTAL_CODE; } }
protected void grdCategory_RowDeleting(object sender, GridViewDeleteEventArgs e) { //get selected category ID Int32 ID = Convert.ToInt32(grdCategory.DataKeys[e.RowIndex].Values["ID"]); using (InoviceConnection db = new InoviceConnection()) { //get selected Category category_information objC = (from c in db.category_information where c.ID == ID select c).FirstOrDefault(); //delete db.category_information.Remove(objC); db.SaveChanges(); //refresh grid GetCategories(); } }
protected void grdSupplier_RowDeleting(object sender, GridViewDeleteEventArgs e) { //get selected Supplier ID Int32 SUPPLIER_ID = Convert.ToInt32(grdSupplier.DataKeys[e.RowIndex].Values["SUPPLIER_ID"]); using (InoviceConnection db = new InoviceConnection()) { //get selected Supplier supplier_information objC = (from s in db.supplier_information where s.SUPPLIER_ID == SUPPLIER_ID select s).FirstOrDefault(); //delete db.supplier_information.Remove(objC); db.SaveChanges(); //refresh grid GetSupplier(); } }
protected void btnSave_Click(object sender, EventArgs e) { //do insert or update using (InoviceConnection db = new InoviceConnection()) { order_master objC = new order_master(); if (!String.IsNullOrEmpty(Request.QueryString["ORDER_ID"])) { Int32 ORDER_ID = Convert.ToInt32(Request.QueryString["ORDER_ID"]); objC = (from p in db.order_master where p.ORDER_ID == ORDER_ID select p).FirstOrDefault(); } //populate the product details from the input form objC.ORDER_DATE = Convert.ToDateTime(txtOrderDate.Text); objC.QUANTITY = Convert.ToInt32(txtQuantity.Text); objC.UNIT_PRICE = Convert.ToDecimal(lblPrice.Text); objC.PRODUCT_ID = Convert.ToInt32(ddlProduct.SelectedValue); objC.CATEGORY_ID = Convert.ToInt32(ddlCategory.SelectedValue); if (String.IsNullOrEmpty(Request.QueryString["ORDER_ID"])) { if (HttpContext.Current.User.Identity.IsAuthenticated) { objC.USER_ID = HttpContext.Current.User.Identity.GetUserId(); } //add db.order_master.Add(objC); } //save and redirect db.SaveChanges(); Response.Redirect("orderList.aspx"); } }
protected void GetOrder() { //populate the existing product for editing using (InoviceConnection db = new InoviceConnection()) { Int32 ORDER_ID = Convert.ToInt32(Request.QueryString["ORDER_ID"]); order_master objC = (from o in db.order_master where o.ORDER_ID == ORDER_ID select o).FirstOrDefault(); //populate the form txtOrderDate.Text = String.Format("{0:MM-dd-yyyy}",objC.ORDER_DATE); txtQuantity.Text = objC.QUANTITY.ToString(); ddlCategory.SelectedValue = objC.CATEGORY_ID.ToString(); GetProduct(); ddlProduct.SelectedValue = objC.PRODUCT_ID.ToString(); lblPrice.Text = String.Format("{0:n2}" ,objC.UNIT_PRICE); lblTotal.Text = String.Format("{0:n2}" ,(objC.UNIT_PRICE * objC.QUANTITY)); } }
protected void GetProduct() { using (InoviceConnection db = new InoviceConnection()) { //Store the selected DepartmentID Int32 CATEGORY_ID = Convert.ToInt32(ddlCategory.SelectedValue); var ObjC = from c in db.product_information where c.CATEGORY_ID == CATEGORY_ID orderby c.NAME select c; //bind to the course dropdown ddlProduct.DataSource = ObjC.ToList(); ddlProduct.DataBind(); //add default options to the 2 dropdowns ListItem newItem = new ListItem("-Select-", "0"); ddlProduct.Items.Insert(0, newItem); } }
protected void GetPrice() { using (InoviceConnection db = new InoviceConnection()) { //Store the selected DepartmentID Int32 PRODUCT_ID = Convert.ToInt32(ddlProduct.SelectedValue); product_information objC = (from o in db.product_information where o.PRODUCT_ID == PRODUCT_ID select o).FirstOrDefault(); lblPrice.Text = objC.UNIT_PRICE.ToString(); } }
protected void grdOrder_RowDeleting(object sender, GridViewDeleteEventArgs e) { //get selected Product ID Int32 ORDER_ID = Convert.ToInt32(grdOrder.DataKeys[e.RowIndex].Values["ORDER_ID"]); using (InoviceConnection db = new InoviceConnection()) { //get selected Product order_master objC = (from o in db.order_master where o.ORDER_ID == ORDER_ID select o).FirstOrDefault(); //delete db.order_master.Remove(objC); db.SaveChanges(); //refresh grid GetOrder(); } }
protected void GetSupplier() { using (InoviceConnection db = new InoviceConnection()) { var supp = (from s in db.supplier_information orderby s.SUPPLIER_NAME select s); ddlSupplier.DataSource = supp.ToList(); ddlSupplier.DataBind(); } }