protected void Page_Load(object sender, EventArgs e) { StationeryController stationeryController = new StationeryController(); ui_category_gridview.DataSource = stationeryController.actionGetStationeryCategories(); ui_category_gridview.GridLines = GridLines.None; ui_category_gridview.DataBind(); }
public static string loadApprovedRequests() { User user = (User)HttpContext.Current.Session["user"]; if (user == null) { return null; } int empId = user.id; //-------------------------------------------------------------- JavaScriptSerializer js = new JavaScriptSerializer(); RequisitionController requisitionController = new RequisitionController(); // hard coded user id = 6 // List<Requisition> requisition_entities =requisitionController.actionGetPendingRequisitionsByUserID(6); List<Requisition> requisition_entities = requisitionController.actionGetApprovedRequisitionsByUserID(empId); List<RequisitionModel> model = new List<RequisitionModel>(); StationeryController stationeryController = new StationeryController(); List<StationaryRequests> stationeryRequests = new List<StationaryRequests>(); foreach (Requisition r in requisition_entities) { StationaryRequests stationaryRequests = new StationaryRequests(); stationaryRequests.Quantity = r.quantity; stationaryRequests.StrationeryName = stationeryController.actionGetStationeryByID(r.stationery).stationery_name; stationaryRequests.RequestedDate = r.datetime_requested.ToString("MMMM dd, yyyy"); stationeryRequests.Add(stationaryRequests); } return js.Serialize(stationeryRequests); }
public string makeRequisition(int userId, string stationeryName, int quantity) { StationeryController stController = new StationeryController(); Requisition requisition = new Requisition(); // System.Diagnostics.Debug.WriteLine("inside actionGetStationeryIdByName::" + name); string newstationeryName = stationeryName.Replace('_', ' '); // System.Diagnostics.Debug.WriteLine("inside actionGetStationeryIdByName::" + newstationeryName); int stationeryId = Convert.ToInt32(stController.actionGetStationeryIdByName(newstationeryName)); requisition.stationery = stationeryId; requisition.quantity = quantity; requisition.user_obj = userId; //hardcoded department id requisition.department = 8; requisition.user_approved_by = null; RequisitionController requisitionController = new RequisitionController(); Message msg = requisitionController.actionCreateRequisition(requisition); if (msg.condition) { System.Diagnostics.Debug.WriteLine("success"); return "success"; } else { System.Diagnostics.Debug.WriteLine("fail"); return "fail"; } }
protected void Page_Load(object sender, EventArgs e) { int category_id; if (int.TryParse(Request.QueryString["id"], out category_id)) { category_id = Convert.ToInt16(Request.QueryString["id"].ToString()); if (category_id < 1) { Response.Redirect("~/StoreClerk/CategoryList.aspx"); } if (!Page.IsPostBack) { StationeryController categoryController = new StationeryController(); StationeryCategory category = categoryController.actionGetStationeryCategoryByID(category_id); ui_id_hiddenfield.Value = category.id.ToString(); ui_catname_textbox.Text = category.category_name; ui_content_title_label.Text = category.category_name; } } else { } }
protected void ui_save_button_Click(object sender, EventArgs e) { StationeryController sationeryController = new StationeryController(); StationeryCategory category = new StationeryCategory(); int category_id; //getting hidden field id if (int.TryParse(ui_id_hiddenfield.Value, out category_id)) { category.id = Convert.ToInt32(ui_id_hiddenfield.Value); } //fields validation if (String.IsNullOrEmpty(ui_catname_textbox.Text)) { Response.Cookies.Add(new HttpCookie("flash_message", "Field(s) marked with * can't be empty.") { Path = "/" }); Response.Cookies.Add(new HttpCookie("flash_css", "alert alert-error") { Path = "/" }); return; //String idstring = (supplier.id > 0) ? ("?id="+supplier.id) : (""); //Response.Redirect("~/StoreClerk/SupplierDetail.aspx"+idstring); } //setting up object category.category_name = ui_catname_textbox.Text; //updating db; Message message; if (category.id > 0) { message = sationeryController.actionUpdateStationeryCategory(category); } else { message = sationeryController.actionCreateStationeryCategory(category); } //redirecting if (message.condition) { Response.Cookies.Add(new HttpCookie("flash_message", "Successfully Saved.") { Path = "/" }); Response.Cookies.Add(new HttpCookie("flash_css", "alert alert-success") { Path = "/" }); Response.Redirect("~/StoreClerk/CategoryDetail.aspx?id=" + category.id); } else { Response.Cookies.Add(new HttpCookie("flash_message", message.message) { Path = "/" }); Response.Cookies.Add(new HttpCookie("flash_css", "alert alert-error") { Path = "/" }); Response.Redirect("~/StoreClerk/CategoryDetail.aspx?id=" + category.id); } }
public static string get_all_stationaries() { StationeryController stationaryController = new StationeryController(); JavaScriptSerializer js = new JavaScriptSerializer(); List<Stationery> stationery_entities = stationaryController.actionGetStationeries(); List<StationeryModel> stationery_models = new List<StationeryModel>(); foreach (Stationery s in stationery_entities) { stationery_models.Add(EntityCopier.Copy(s)); } String str = js.Serialize(stationery_models); return str; }
protected void Page_Load(object sender, EventArgs e) { User suser = (User)Session["user"]; if (suser == null || suser.user_type != 4) { Response.Redirect("~/Login.aspx"); } SupplierController suppliercontroller = new SupplierController(); StationeryController stationerycontroller = new StationeryController(); if(int.TryParse(Request.QueryString["id"],out stationery_id)) { stationery_id = Convert.ToInt16(Request.QueryString["id"].ToString()); if (stationery_id < 1) { Response.Redirect("~/StoreClerk/InventoryStatus.aspx"); } if (!Page.IsPostBack) { User user = (User)Session["user"]; Stationery stationery = stationerycontroller.actionGetStationeryByID(stationery_id); //Supplier supplier = suppliercontroller.actionGetSuppierByID(Convert.ToInt32(stationery.first_supplier)); ui_from_textbox.Text = user.email; ui_to_dropdown.DataSource = stationerycontroller.actionGetStationeryViews(); ui_to_dropdown.DataSource = stationerycontroller.actionGetSuppliersOfAStationery(stationery.id); ui_to_dropdown.DataTextField = "supplier_name"; ui_to_dropdown.DataValueField = "id"; ui_to_dropdown.DataBind(); ui_subject_textbox.Text = "Purchase Order from Logic University."; ui_message_textbox.Text = "<p>Hello" + "" + ",</p>" + "<p>I would like to order the following item for our store. Please kindly proceed.</p>" + "<p><b>Stationery Name : "+stationery.stationery_name+"<br />"+ "Quantity : " + stationery.reorder_quantity + "</b></p>" + "<p>Thank you,<br /> "+ user.firstname + " " + user.lastname + " "+ "(Logic University)</p>"; //+ stationery.stationery_name + stationery.category.ToString() + stationery.reorder_quantity.ToString()+""+"Regards, Logic University"; } } }
protected void Page_Load(object sender, EventArgs e) { ui_content_title_label.Text = "Stock Card"; Session["data:stock_card:stationery_id"] = null; StationeryController stationeryController = new StationeryController(); SupplierController supplierController = new SupplierController(); int stationery_id; if (int.TryParse(Request.QueryString["id"], out stationery_id)) { stationery_id = Convert.ToInt16(Request.QueryString["id"].ToString()); Session["data:stock_card:stationery_id"] = stationery_id; if (!(stationery_id > 0)) { } if (!Page.IsPostBack) { Stationery stationery = stationeryController.actionGetStationeryByID(stationery_id); ui_stationery_code_label.Text = stationery.code.ToString(); ui_stationery_name_label.Text = stationery.stationery_name.ToString(); ui_stationery_bin_label.Text = stationery.bin.ToString(); ui_stationery_uom_label.Text = stationery.unit_of_measure.ToString(); ui_stationery_supplier1_label.Text = supplierController.actionGetSuppierByID(Convert.ToInt16(stationery.first_supplier)).supplier_name.ToString(); ui_stationery_supplier2_label.Text = supplierController.actionGetSuppierByID(Convert.ToInt16(stationery.second_supplier)).supplier_name.ToString(); ui_stationery_supplier3_label.Text = supplierController.actionGetSuppierByID(Convert.ToInt16(stationery.third_supplier)).supplier_name.ToString(); ui_seationerysearch_box.Text = stationery.stationery_name.ToString(); StockTransactionController stockContorller = new StockTransactionController(); //ui_stockcard_gridview.DataSource = new StockTransactionController().actionGetStockTransactionByStationeryId(2); //ui_stockcard_gridview.DataBind(); } else { } } else { ui_stationeryinfo_panel.CssClass = "hide"; } }
public string loadAllApprovedRequisitions(String accessToken) { OAuthController oAuth = new OAuthController(); User user = oAuth.actionGetUserByToken(accessToken); RequisitionController requisitionController = new RequisitionController(); List<Requisition> requisition_entities = requisitionController.actionGetApprovedRequisitionsByUserID(user.id); List<RequisitionModel> model = new List<RequisitionModel>(); StationeryController stationeryController = new StationeryController(); List<StationaryRequests> stationeryRequests = new List<StationaryRequests>(); foreach (Requisition r in requisition_entities) { StationaryRequests stationaryRequests = new StationaryRequests(); stationaryRequests.Quantity = r.quantity; stationaryRequests.StationaryName = stationeryController.actionGetStationeryByID(r.stationery).stationery_name; stationaryRequests.RequestedDate = r.datetime_requested.ToString(); stationeryRequests.Add(stationaryRequests); } return JsonConvert.SerializeObject(stationeryRequests); }
public Message actionCreateNewReOrderWithDefaultValue(int stationery_id, int supplier_id) { Stationery stationery = new StationeryController().actionGetStationeryByID(stationery_id); Supplier supplier = new SupplierController().actionGetSuppierByID(supplier_id); PurchaseOrder order = new PurchaseOrder(); order.po_stationery = stationery.id; order.po_quantity_in_hand = stationery.quantity_in_stock - stationery.pending_quantity_to_distribute; order.po_reorder_date = DateTime.Now; order.po_reorder_level = stationery.reorder_level; order.po_reordered_quantity = stationery.reorder_quantity; order.po_supplier = supplier.id; try { data.PurchaseOrders.AddObject(order); return this.getNewDefaultMessageForDBOperations(data.SaveChanges() == 1); } catch (Exception e) { return this.getNewDefaultMessageForException(e); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { StationeryController stationeryController = new StationeryController(); List<Supplier> suppliers = new SupplierController().actionGetSuppliers(); int stationery_id; if (int.TryParse(Request.QueryString["id"], out stationery_id)) { stationery_id = Convert.ToInt16(Request.QueryString["id"].ToString()); if (stationery_id < 1) { Response.Redirect("~/m/DepartmentEmplyoee/Stationeries.aspx"); } if (!Page.IsPostBack) { Stationery stationery = stationeryController.actionGetStationeryByID(stationery_id); StationeryCategory category = stationeryController.actionGetStationeryCategoryByID(stationery.category); ui_stationery_name.Text = stationery.stationery_name; ui_category.Text = category.category_name; ui_id_hidden.Value = stationery.id.ToString(); ui_uom.Text = stationery.unit_of_measure; ui_price.Text = stationery.price.ToString(); ui_total.Text = stationery.price.ToString(); ui_price_hidden_forjscalculation.Value = stationery.price.ToString(); } } else { } } }
public Message actionCreateNewReOrderWithDefaultValue(int stationery_id, int supplier_id) { Stationery stationery = new StationeryController().actionGetStationeryByID(stationery_id); Supplier supplier = new SupplierController().actionGetSuppierByID(supplier_id); PurchaseOrder order = new PurchaseOrder(); order.po_stationery = stationery.id; order.po_quantity_in_hand = stationery.quantity_in_stock - stationery.pending_quantity_to_distribute; order.po_reorder_date = DateTime.Now; order.po_reorder_level = stationery.reorder_level; order.po_reordered_quantity = stationery.reorder_quantity; order.po_supplier = supplier.id; try { data.PurchaseOrders.AddObject(order); return(this.getNewDefaultMessageForDBOperations(data.SaveChanges() == 1)); } catch (Exception e) { return(this.getNewDefaultMessageForException(e)); } }
public static string[] GetCompletionList(string prefixText, int count, string contextKey) { string[] stringDept = new StationeryController().getStatoineryString(prefixText, count); return stringDept; }
protected void ui_send_button_Click(object sender, EventArgs e) { Supplier supplier = new SupplierController().actionGetSuppierByID(Convert.ToInt32(ui_to_dropdown.SelectedValue)); new PurchaseOrderController().actionCreateNewReOrderWithDefaultValue(stationery_id, supplier.id); if (ui_sentmail.Checked) { Helper.sendMail(supplier.email, ui_from_textbox.Text, ui_subject_textbox.Text, ui_message_textbox.Text); } if (ui_sentsms.Checked) { Stationery stationery = new StationeryController().actionGetStationeryByID(stationery_id); SMSController sms = new SMSController(); sms.sendSMS(supplier.phone_number, "Purchase Order\r\n Stationery : "+ stationery.stationery_name + "\r\n Quantity : "+ stationery.reorder_quantity); } //ui_from_textbox.Text = ""; //ui_subject_textbox.Text = ""; //ui_message_textbox.Text = ""; Response.Cookies.Add(new HttpCookie("flash_message", "Successfully Made Purchase Order.") { Path = "/" }); Response.Cookies.Add(new HttpCookie("flash_css", "alert alert-success") { Path = "/" }); Response.Redirect("~/StoreClerk/InventoryStatus.aspx"); }
protected void Page_Load(object sender, EventArgs e) { StationeryController stationeryController = new StationeryController(); List<Supplier> suppliers = new SupplierController().actionGetSuppliers(); int stationery_id; if (int.TryParse(Request.QueryString["id"], out stationery_id)) { stationery_id = Convert.ToInt16(Request.QueryString["id"].ToString()); if (stationery_id < 1) { Response.Redirect("~/StoreClerk/StationeryList.aspx"); } if (!Page.IsPostBack) { Stationery stationery = stationeryController.actionGetStationeryByID(stationery_id); ui_id_hiddenfield.Value = stationery.id.ToString(); ui_code_textbox.Text = stationery.code.ToString(); ui_name_textbox.Text = stationery.stationery_name; ui_category_dropdown.DataSource = stationeryController.actionGetStationeryCategories(); ui_category_dropdown.DataTextField = "category_name"; ui_category_dropdown.DataValueField = "id"; ui_category_dropdown.DataBind(); ui_category_dropdown.SelectedValue = stationery.category.ToString(); ui_price_textbox.Text = stationery.price.ToString(); ui_reorderlevel_textbox.Text = stationery.reorder_level.ToString(); ; ui_reorderquantity_textbox.Text = stationery.reorder_quantity.ToString(); ui_quantityinstock_label.Text = stationery.quantity_in_stock.ToString(); ui_pendingquantity_label.Text = stationery.pending_quantity_to_distribute.ToString(); ui_uom_textbox.Text = stationery.unit_of_measure.ToString(); ui_binnum_textbox.Text = stationery.bin.ToString(); ui_firstsupplier_dropdown.DataSource = suppliers; ui_secondsupplier_dropdown.DataSource = suppliers; ui_thirdsupplier_dropdown.DataSource = suppliers; ui_firstsupplier_dropdown.DataTextField = "supplier_name"; ui_firstsupplier_dropdown.DataValueField = "id"; ui_secondsupplier_dropdown.DataTextField = "supplier_name"; ui_secondsupplier_dropdown.DataValueField = "id"; ui_thirdsupplier_dropdown.DataTextField = "supplier_name"; ui_thirdsupplier_dropdown.DataValueField = "id"; ui_firstsupplier_dropdown.DataBind(); ui_secondsupplier_dropdown.DataBind(); ui_thirdsupplier_dropdown.DataBind(); ui_firstsupplier_dropdown.SelectedValue = stationery.first_supplier.ToString(); ui_secondsupplier_dropdown.SelectedValue = stationery.second_supplier.ToString(); ui_thirdsupplier_dropdown.SelectedValue = stationery.third_supplier.ToString(); ui_content_title_label.Text = stationery.stationery_name.ToString(); } } else { String tmp_s1 = ui_firstsupplier_dropdown.SelectedValue; String tmp_s2 = ui_secondsupplier_dropdown.SelectedValue; String tmp_s3 = ui_thirdsupplier_dropdown.SelectedValue; String tmp_cate = ui_category_dropdown.SelectedValue; ui_category_dropdown.DataSource = stationeryController.actionGetStationeryCategories(); ui_category_dropdown.DataTextField = "category_name"; ui_category_dropdown.DataValueField = "id"; ui_category_dropdown.DataBind(); ui_firstsupplier_dropdown.DataSource = suppliers; ui_secondsupplier_dropdown.DataSource = suppliers; ui_thirdsupplier_dropdown.DataSource = suppliers; ui_firstsupplier_dropdown.DataTextField = "supplier_name"; ui_firstsupplier_dropdown.DataValueField = "id"; ui_secondsupplier_dropdown.DataTextField = "supplier_name"; ui_secondsupplier_dropdown.DataValueField = "id"; ui_thirdsupplier_dropdown.DataTextField = "supplier_name"; ui_thirdsupplier_dropdown.DataValueField = "id"; ui_firstsupplier_dropdown.DataBind(); ui_secondsupplier_dropdown.DataBind(); ui_thirdsupplier_dropdown.DataBind(); ui_category_dropdown.SelectedValue = tmp_cate; ui_firstsupplier_dropdown.SelectedValue = tmp_s1; ui_secondsupplier_dropdown.SelectedValue = tmp_s2; ui_thirdsupplier_dropdown.SelectedValue = tmp_s3; } }
protected void ui_save_button_Click(object sender, EventArgs e) { StationeryController sationeryController = new StationeryController(); Stationery stationery = new Stationery(); int stationery_id; //getting hidden field id if (int.TryParse(ui_id_hiddenfield.Value, out stationery_id)) { stationery.id = Convert.ToInt32(ui_id_hiddenfield.Value); stationery = sationeryController.actionGetStationeryByID(stationery.id); } //fields validation if (String.IsNullOrEmpty(ui_code_textbox.Text) || String.IsNullOrEmpty(ui_name_textbox.Text) || String.IsNullOrEmpty(ui_reorderlevel_textbox.Text) || String.IsNullOrEmpty(ui_reorderquantity_textbox.Text) || String.IsNullOrEmpty(ui_uom_textbox.Text) || String.IsNullOrEmpty(ui_price_textbox.Text) ) { Response.Cookies.Add(new HttpCookie("flash_message", "Field(s) marked with * can't be empty.") { Path = "/" }); Response.Cookies.Add(new HttpCookie("flash_css", "alert alert-error") { Path = "/" }); return; //String idstring = (supplier.id > 0) ? ("?id="+supplier.id) : (""); //Response.Redirect("~/StoreClerk/SupplierDetail.aspx"+idstring); } try { stationery.reorder_level = Convert.ToInt32(ui_reorderlevel_textbox.Text); stationery.reorder_quantity = Convert.ToInt32(ui_reorderquantity_textbox.Text); stationery.price = Convert.ToDouble(ui_price_textbox.Text); } catch (Exception ex) { Response.Cookies.Add(new HttpCookie("flash_message", "Price Reorder Level and Reorder Quantity only allow numbers." ) { Path = "/" }); Response.Cookies.Add(new HttpCookie("flash_css", "alert alert-error") { Path = "/" }); return; } //setting up object //setting up object stationery.code = ui_code_textbox.Text; stationery.stationery_name = ui_name_textbox.Text; stationery.category = Convert.ToInt32(ui_category_dropdown.SelectedValue); stationery.reorder_level = Convert.ToInt32(ui_reorderlevel_textbox.Text); stationery.reorder_quantity = Convert.ToInt32(ui_reorderquantity_textbox.Text); stationery.unit_of_measure = ui_uom_textbox.Text; stationery.bin = ui_binnum_textbox.Text; //stationery.quantity_in_stock = Convert.ToInt32(ui_quantityinstock_label.Text); //stationery.pending_quantity_to_distribute = Convert.ToInt32(ui_pendingquantity_label.Text); if (Page.IsPostBack) { } stationery.first_supplier = Convert.ToInt32(ui_firstsupplier_dropdown.SelectedItem.Value); stationery.second_supplier = Convert.ToInt32(ui_secondsupplier_dropdown.SelectedItem.Value); stationery.third_supplier = Convert.ToInt32(ui_thirdsupplier_dropdown.SelectedItem.Value); //stationery.first_supplier = 5; //stationery.second_supplier = 4; //stationery.third_supplier = 1; //updating db; Message message; if (stationery.id > 0) { message = sationeryController.actionUpdateStationery(stationery); } else { stationery.quantity_in_stock = 0; stationery.pending_quantity_to_distribute = 0; message = sationeryController.actionCreateStationery(stationery); } //redirecting if (message.condition) { Response.Cookies.Add(new HttpCookie("flash_message", "Successfully Saved.") { Path = "/" }); Response.Cookies.Add(new HttpCookie("flash_css", "alert alert-success") { Path = "/" }); Response.Redirect("~/StoreClerk/StatoneryDetail.aspx?id=" + stationery.id); } else { Response.Cookies.Add(new HttpCookie("flash_message", message.message) { Path = "/" }); Response.Cookies.Add(new HttpCookie("flash_css", "alert alert-error") { Path = "/" }); Response.Redirect("~/StoreClerk/StatoneryDetail.aspx?id=" + stationery.id); } }
public void getJSONByStationery(HttpContext context) { List<MStationery> mList = new List<MStationery>(); List<Stationery> list = new StationeryController().actionGetStationeries(); foreach (Stationery i in list) { mList.Add(new MStationery(i.id, i.stationery_name)); } context.Response.Write(JsonConvert.SerializeObject(mList)); context.Response.End(); }
public void getStationaryId(string stationaryName) { StationeryController stController = new StationeryController(); int id = Convert.ToInt32(stController.actionGetStationeryIdByName(stationaryName)); System.Diagnostics.Debug.WriteLine("id is :" + id); }