private void ComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
stkRptOp.Visibility = Visibility.Collapsed;
stkReport.Visibility = Visibility.Collapsed;
firstTime = true;
if (e.AddedItems == null)
{
return;
}
if (e.AddedItems != null && e.AddedItems.Count > 0)
{
IqReport report = e.AddedItems[0] as IqReport;
if (report != null)
{
SelectionData(sender, new DataEventArgs <IqReport>(report));
//RunData(sender, new DataEventArgs<String>(txtToShow.Text));
stkReport.Visibility = Visibility.Visible;
stkRptOp.Visibility = Visibility.Visible;
popUcFilters.IsOpen = true;
popUcFilters.StaysOpen = true;
//stkFilters.Visibility = Visibility.Visible;
}
}
//stkRptOp.Visibility = Visibility.Visible;
}
void View_DeleteReport(object sender, DataEventArgs <IqReport> e)
{
//Eliminar El reporte y sus Hijos.
try
{
IqReport data = e.Value;
data.ModifiedBy = App.curUser.UserName;
data.ModDate = DateTime.Now;
data.Status = App.EntityStatusList.Where(f => f.StatusID == EntityStatus.Inactive).First();
service.UpdateIqReport(data);
Util.ShowMessage(Util.GetResourceLanguage("REPORT_DELETED"));
View.Model.ReportSystem = null;
View.Model.ListReportSystems = service.GetIqReport(new IqReport {
Status = new Status {
StatusID = EntityStatus.Active
}
});
View.Model.Details = null;
View.GridDet.Columns.Clear();
View.GridDet.Items.Refresh();
View.CboReport.Items.Refresh();
}
catch (Exception ex)
{
Util.ShowError(Util.GetResourceLanguage("ERROR_SAVING_THE_REPORTS") + "\n" + ex.Message);
}
}
private void OnSave(object sender, DataEventArgs <IqReport> e)
{
if (e.Value == null)
{
return;
}
try
{
IqReport data = e.Value;
data.CreatedBy = App.curUser.UserName;
data.CreationDate = DateTime.Now;
data.IsForSystem = false;
View.Model.ReportSystem = service.SaveIqReport(data);
View.Model.ListReportSystems = service.GetIqReport(new IqReport {
Status = new Status {
StatusID = EntityStatus.Active
}
});
Util.ShowMessage(Util.GetResourceLanguage("REPORT_SAVED"));
}
catch (Exception ex)
{
Util.ShowError(Util.GetResourceLanguage("ERROR_SAVING_THE_REPORTS") + "\n" + ex.Message);
}
}
public IList <IqReport> Select(IqReport data)
{
IList <IqReport> datos = new List <IqReport>();
try {
datos = GetHsql(data).List <IqReport>();
if (!Factory.IsTransactional)
{
Factory.Commit();
}
}
catch (Exception e)
{
NHibernateHelper.WriteEventLog(WriteLog.GetTechMessage(e));
}
return(datos);
}
void View_UpdateData(object sender, DataEventArgs <IqReport> e)
{
if (e.Value == null)
{
return;
}
try
{
IqReport data = e.Value;
data.ModifiedBy = App.curUser.UserName;
data.ModDate = DateTime.Now;
service.UpdateIqReport(data);
Util.ShowMessage("Report Updated.");
}
catch (Exception ex)
{
Util.ShowError("Error saving the reports.\n" + ex.Message);
}
}
void View_UpdateData(object sender, DataEventArgs <IqReport> e)
{
if (e.Value == null)
{
return;
}
try
{
IqReport data = e.Value;
data.ModifiedBy = App.curUser.UserName;
data.ModDate = DateTime.Now;
service.UpdateIqReport(data);
Util.ShowMessage(Util.GetResourceLanguage("REPORT_UPDATED"));
}
catch (Exception ex)
{
Util.ShowError(Util.GetResourceLanguage("ERROR_SAVING_THE_REPORTS") + "\n" + ex.Message);
}
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from IqReport a where ");
IqReport iqreport = (IqReport)data;
if (iqreport != null)
{
Parms = new List <Object[]>();
if (iqreport.ReportId != 0)
{
sql.Append(" a.ReportId = :id and ");
Parms.Add(new Object[] { "id", iqreport.ReportId });
}
if (!String.IsNullOrEmpty(iqreport.Name))
{
sql.Append(" a.Name = :nom2 and ");
Parms.Add(new Object[] { "nom2", iqreport.Name });
}
if (iqreport.IsForSystem != null)
{
sql.Append(" a.IsForSystem = :nom3 and ");
Parms.Add(new Object[] { "nom3", iqreport.IsForSystem });
}
if (iqreport.Status != null && iqreport.Status.StatusID != 0)
{
sql.Append(" a.Status.StatusID = :stid and ");
Parms.Add(new Object[] { "stid", iqreport.Status.StatusID });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append("1=1 order by a.ReportId asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return(query);
}
private void OnSave(object sender, DataEventArgs <IqReport> e)
{
if (e.Value == null)
{
return;
}
try
{
IqReport data = e.Value;
data.CreatedBy = App.curUser.UserName;
data.CreationDate = DateTime.Now;
data.IsForSystem = false;
View.Model.ReportSystem = service.SaveIqReport(data);
View.Model.ListReportSystems = service.GetIqReport(new IqReport());
Util.ShowMessage("Report Saved.");
}
catch (Exception ex)
{
Util.ShowError("Error saving the reports.\n" + ex.Message);
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
//Save As
SettingsRepository settings = new SettingsRepository();
this.GridDetails.SaveUserSettings(settings, UserSettings.All);
IqReport saveAs = Model.ReportSystem;
saveAs.Settings = Util.XmlSerializer(settings);
saveAs.Name = TextName.Text;
foreach (IqReportTable tb in saveAs.ReportTables)
{
tb.ReportTableId = 0;
foreach (IqReportColumn rc in tb.ReportColumns)
{
rc.ReportColumnId = 0;
}
}
SaveData(sender, new DataEventArgs <IqReport>(saveAs));
}
private void ReportSelectedChange(IqReport rep)
{
if (rep == null)
{
return;
}
IList <IqReportColumn> columnList = new List <IqReportColumn>();
foreach (IqReportTable rt in rep.ReportTables)
{
foreach (IqReportColumn rc in rt.ReportColumns)
{
columnList.Add(rc);
}
}
View.Model.AllColumns = columnList.OrderBy(f => f.NumOrder).ToList();
//Habilitando O Desabilitando el Boton de Delete
View.BtnDelRep.IsEnabled = false;
if (rep.IsForSystem == false && rep.CreatedBy == App.curUser.UserName)
{
View.BtnDelRep.IsEnabled = true;
}
LoadReportFilters();
//Habilitando O Desabilitando el Boton de Update
//View.BtnUpdRep.IsEnabled = false;
//if (rep.IsForSystem == false && rep.CreatedBy == App.curUser.UserName)
// View.BtnUpdRep.IsEnabled = true;
}
public IqReport SelectById(IqReport data)
{
return((IqReport)base.SelectById(data));
}
public Boolean Delete(IqReport data)
{
return(base.Delete(data));
}
public Boolean Update(IqReport data)
{
return(base.Update(data));
}
public IqReport Save(IqReport data)
{
return((IqReport)base.Save(data));
}
public void DeleteIqReport(IqReport data)
{
try
{
SetService(); SerClient.DeleteIqReport(data);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public IqReport SaveIqReport(IqReport data)
{
try
{
SetService(); return SerClient.SaveIqReport(data);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
