public async Task <IActionResult> GetAllCage() { using (var cageDAO = new CageDAO()) { return(Json((await cageDAO.ReadAll(false)) .ToArray())); } }
protected void RadGrid1_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e) { if (!e.IsFromDetailTable) { CageDAO cage = new CageDAO(); CagesRadGrid.DataSource = cage.GetCages(); } }
public async Task <IActionResult> GetCageSearchResult(string keyword) { using (var cageDAO = new CageDAO()){ return(Json((cageDAO.Context.Cage .Include(x => x.Product) .Where(x => x.Product.Name.IndexOf(keyword, StringComparison.OrdinalIgnoreCase) != -1)) .ToArray())); } }
protected void CagesRadGrid_DeleteCommand(object sender, GridCommandEventArgs e) { GridEditableItem editedItem = e.Item as GridEditableItem; int cageID = int.Parse(editedItem.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["cage_id"].ToString()); CageDAO cagedao = new CageDAO(); cagedao.UpdateCageStatus(cageID, (int)CageStatus.Cancelled, User.Identity.Name); DisplayMessage(false, "Cage " + cageID.ToString() + " cancelled"); }
private void DoCageCreate(string cageType, int numOfCages) { CageDAO cagedao = new CageDAO(); DataSet cageDS = cagedao.CreateCages(numOfCages, cageType, User.Identity.Name); PrintService ps = new PrintService(); //Print each of the labels foreach (DataRow cageRow in cageDS.Tables[0].Rows) { string machinename = Shared.UserHostName; string reportname = "5"; string devicetype = "1"; int cageid = int.Parse(cageRow["cage_id"].ToString()); string test = ps.PrintLabel(reportname, machinename, devicetype, cageid, true); } }
protected void CagesRadGrid_InsertCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e) { int numOfCages = (int)((RadNumericTextBox)(e.Item.FindControl("numcages_radnumerictextbox"))).Value; string cageType = ((RadComboBox)e.Item.FindControl("cagetype_radcombobox")).SelectedValue; string createForStores = ((RadioButtonList)e.Item.FindControl("rblCreateForStores")).SelectedValue; bool storesFound = false; if (createForStores == "T") { CageDAO cagedao = new CageDAO(); PrintService ps = new PrintService(); SystemParamsDAO sysParam = new SystemParamsDAO(); const Int32 toteDelayParamId = 24; const int labelsInBatch = 50; const int defaultDelay = 50; int delayCounter = 0; int delaySeconds; try { if (!int.TryParse(sysParam.Get_param_value(toteDelayParamId), out delaySeconds)) { delaySeconds = defaultDelay; // if param not set then use default delay. } } catch // The params package doesn't handle parameter not found so need to catch error. { delaySeconds = defaultDelay; // if param not set then use default delay. } // Creating IDataReader in a using block should tidy up properly when we are finished with it or // in case of failure. using (IDataReader toteLabels = cagedao.GetToteLabels(numOfCages, cageType, User.Identity.Name)) { while (toteLabels.Read()) { storesFound = true; ps.PrintPackDocuments(Convert.ToDecimal(toteLabels["order_id"].ToString()), true, Shared.UserHostName, "L", Shared.CurrentUser); delayCounter++; if (delayCounter == labelsInBatch) { System.Threading.Thread.Sleep(delaySeconds * 1000); // Sleep is in milliseconds delayCounter = 0; } } } if (storesFound) { DisplayMessage(false, "Tote Label(s) of type " + cageType + " created"); } else { DisplayMessage(true, "Error: No valid stores for tote labels found for cage type " + cageType); } } else { DoCageCreate(cageType, numOfCages); DisplayMessage(false, numOfCages.ToString() + " cage(s) of type " + cageType + " created"); } }