public IList <CountSchedule> Select(CountSchedule data)
{
IList <CountSchedule> datos = new List <CountSchedule>();
try {
datos = GetHsql(data).List <CountSchedule>();
if (!Factory.IsTransactional)
{
Factory.Commit();
}
}
catch (Exception e)
{
NHibernateHelper.WriteEventLog(WriteLog.GetTechMessage(e));
}
return(datos);
}
public void UpdateCountSchedule(CountSchedule data)
{
try
{
SetService();
SerClient.UpdateCountSchedule(data);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public CountSchedule SaveCountSchedule(CountSchedule data)
{
try
{
SetService(); return SerClient.SaveCountSchedule(data);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
WMSServiceClient serv = new WMSServiceClient();
if (rdOpt.IsChecked == true)
{
// make the Count document
if (Products == null || Products.Rows.Count == 0)
{
Util.ShowError("Records not selected");
return;
}
NewTask();
}
else
{
//// make the schedule
if (string.IsNullOrEmpty(Query))
{
Util.ShowError("Records not selected");
return;
}
if (string.IsNullOrEmpty(txtTitle.Text))
{
Util.ShowError("Name or Reference is required");
return;
}
if (string.IsNullOrEmpty(txtSchDateFrom.Text))
{
Util.ShowError("Start Date is required");
return;
}
if (string.IsNullOrEmpty(txtSchDateTo.Text))
{
Util.ShowError("End Date is required");
return;
}
if (string.IsNullOrEmpty(txtFrecuency.Text))
{
Util.ShowError("Frecuency field is required");
return;
}
if (txtSchDateFrom.SelectedDate >= txtSchDateTo.SelectedDate)
{
Util.ShowError("End Date must be older than Start Date");
return;
}
// CAA [2010/05/05] Valida que se incluyan las columnas necesarias en el reporte
if (cboToDo.SelectedIndex == 0) //Only BIN
{
if (!Query.Contains("as BinCode"))
{
Util.ShowError("BinCode column missing.");
return;
}
}
else
if (cboToDo.SelectedIndex == 1) // BIN & PRODUCT
{
if (!Query.Contains("as BinCode") || (!Query.Contains("as Product FROM") && !Query.Contains("as Product,")))
{
Util.ShowError("BinCode and/or Product columns are missing.");
return;
}
}
CountSchedule sch = new CountSchedule
{
Start = txtSchDateFrom.SelectedDate.Value, // DateTime.Parse(txtSchDateFrom.Text);
Finish = txtSchDateTo.SelectedDate.Value, // DateTime.Parse(txtSchDateTo.Text);
NextDateRun = txtSchDateFrom.SelectedDate.Value, //.AddDays(double.Parse(txtFrecuency.Text));
IsDone = false,
Query = Query,
Parameters = queryParam.GetXml(),
RepeatEach = short.Parse(txtFrecuency.Text),
CreatedBy = App.curUser.UserName,
CreationDate = DateTime.Now,
Location = App.curLocation,
CountOption = cboToDo.SelectedIndex,
Title = txtTitle.Text
};
sch = serv.SaveCountSchedule(sch);
Util.ShowMessage("Cycle Count Scheduled.");
}
ClosePopup();
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
WMSServiceClient serv = new WMSServiceClient();
if (rdOpt.IsChecked == true)
{
// make the Count document
if (Products == null || Products.Rows.Count == 0)
{
Util.ShowError("Records not selected");
return;
}
NewTask();
}
else
{
//// make the schedule
if (string.IsNullOrEmpty(Query))
{
Util.ShowError("Records not selected");
return;
}
if (string.IsNullOrEmpty(txtTitle.Text))
{
Util.ShowError("Name or Reference is required");
return;
}
if (string.IsNullOrEmpty(txtSchDateFrom.Text))
{
Util.ShowError("Start Date is required");
return;
}
if (string.IsNullOrEmpty(txtSchDateTo.Text))
{
Util.ShowError("End Date is required");
return;
}
if (string.IsNullOrEmpty(txtFrecuency.Text))
{
Util.ShowError("Frecuency field is required");
return;
}
if (txtSchDateFrom.SelectedDate >= txtSchDateTo.SelectedDate)
{
Util.ShowError("End Date must be older than Start Date");
return;
}
// CAA [2010/05/05] Valida que se incluyan las columnas necesarias en el reporte
if (cboToDo.SelectedIndex == 0) //Only BIN
{
if (!Query.Contains("as BinCode"))
{
Util.ShowError("BinCode column missing.");
return;
}
}
else
if (cboToDo.SelectedIndex == 1) // BIN & PRODUCT
{
if (!Query.Contains("as BinCode") || (!Query.Contains("as Product FROM") && !Query.Contains("as Product,")))
{
Util.ShowError("BinCode and/or Product columns are missing.");
return;
}
}
CountSchedule sch = new CountSchedule
{
Start = txtSchDateFrom.SelectedDate.Value, // DateTime.Parse(txtSchDateFrom.Text);
Finish = txtSchDateTo.SelectedDate.Value, // DateTime.Parse(txtSchDateTo.Text);
NextDateRun = txtSchDateFrom.SelectedDate.Value, //.AddDays(double.Parse(txtFrecuency.Text));
IsDone = false,
Query = Query,
Parameters = queryParam.GetXml(),
RepeatEach = short.Parse(txtFrecuency.Text),
CreatedBy = App.curUser.UserName,
CreationDate = DateTime.Now,
Location = App.curLocation,
CountOption = cboToDo.SelectedIndex,
Title = txtTitle.Text
};
sch = serv.SaveCountSchedule(sch);
Util.ShowMessage("Cycle Count Scheduled.");
}
ClosePopup();
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from CountSchedule a where ");
CountSchedule countSchedule = (CountSchedule)data;
if (countSchedule != null)
{
Parms = new List <Object[]>();
if (countSchedule.RowID != 0)
{
sql.Append(" a.RowID = :id and ");
Parms.Add(new Object[] { "id", countSchedule.RowID });
}
if (countSchedule.RepeatEach != 0)
{
sql.Append(" a.RepeatEach = :id1 and ");
Parms.Add(new Object[] { "id1", countSchedule.RepeatEach });
}
if (countSchedule.Start != null)
{
sql.Append(" a.Start = :id2 and ");
Parms.Add(new Object[] { "id2", countSchedule.Start });
}
if (countSchedule.Finish != null)
{
sql.Append(" a.Finish = :id3 and ");
Parms.Add(new Object[] { "id3", countSchedule.Finish });
}
if (countSchedule.NextDateRun != null)
{
sql.Append(" a.NextDateRun = :id4 and ");
Parms.Add(new Object[] { "id4", countSchedule.NextDateRun });
}
if (countSchedule.IsDone != null)
{
sql.Append(" a.IsDone = :id5 and ");
Parms.Add(new Object[] { "id5", countSchedule.IsDone });
}
//if (!string.IsNullOrEmpty(countSchedule.Title))
//{
// sql.Append(" a.Title like :id6 and ");
// Parms.Add(new Object[] { "id6", "%" + countSchedule.Title + "%" });
//}
if (countSchedule.Location != null && countSchedule.Location.LocationID != 0)
{
sql.Append(" a.Location.LocationID = :loc and ");
Parms.Add(new Object[] { "loc", countSchedule.Location.LocationID });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append("1=1 order by a.NextDateRun asc");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return(query);
}
public CountSchedule SelectById(CountSchedule data)
{
return((CountSchedule)base.SelectById(data));
}
public Boolean Delete(CountSchedule data)
{
return(base.Delete(data));
}
public Boolean Update(CountSchedule data)
{
return(base.Update(data));
}
public CountSchedule Save(CountSchedule data)
{
return((CountSchedule)base.Save(data));
}
