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