public frmNewSeries(FormSeries fs)
{
InitializeComponent();
updateProductUI();
this.formSeries = fs;
this.lFormTitle.Text = "Edit Form Series";
this.pop();
}
private void btnSeries_Click(object sender, EventArgs e)
{
if (!formSeries.Visible)
{
formSeries = new FormSeries();
formSeries.Show();
}
}
public bool Update(FormSeries fs)
{
string sql = "UPDATE FormSeries SET ";
sql += string.Format("ReportSeriesName='{0}'", fs.Name);
sql += string.Format(" WHERE ID={0}", fs.Id);
return(DB.Update(sql));
}
private FormSeries getDataObject(DataRow row)
{
FormSeries f = new FormSeries();
f.Id = Convert.ToInt32(row[0].ToString());
f.Name = row[1].ToString();
f.CreateDate = DateTime.Parse(row[2].ToString());
f.ModifiedDate = DateTime.Parse(row[3].ToString());
return(f);
}
public bool Delete(FormSeries fs)
{
if (this.Delete(fs.Id))
{
foreach (FormFormSeries ffs in FormFormSeriesDAO.DAO.GetAllByFormSeriesId(fs.Id))
{
FormFormSeriesDAO.DAO.Delete(ffs);
}
return(true);
}
return(false);
}
private void loadPrintSeries(FormSeries fs)
{
this.activePrintSeriesId = fs.Id;
this.newFfs = new List <FormFormSeries>();
ulvPrintSeries.Reset();
ulvPrintSeries.Width = pnlPrintSeries.Width;
ulvPrintSeries.Height = pnlPrintSeries.Height;
ulvPrintSeries.ViewSettingsDetails.CheckBoxStyle = CheckBoxStyle.CheckBox;
ulvPrintSeries.View = UltraListViewStyle.Details;
ulvPrintSeries.ItemSettings.Appearance.Image = imageList1.Images[0];
ulvPrintSeries.ViewSettingsDetails.SubItemColumnsVisibleByDefault = true;
ulvPrintSeries.ViewSettingsDetails.AutoFitColumns = AutoFitColumns.ResizeAllColumns;
ulvPrintSeries.ItemSettings.SubItemsVisibleInToolTipByDefault = false;
ulvPrintSeries.ItemSettings.SelectionType = SelectionType.Single;
UltraListViewMainColumn mainColumn = ulvPrintSeries.MainColumn;
mainColumn.Text = "Enabled";
mainColumn.DataType = typeof(System.Int32);
UltraListViewSubItemColumn cNumberOfCopies = new UltraListViewSubItemColumn();
cNumberOfCopies.Text = "# Copies";
cNumberOfCopies.Width = 50;
cNumberOfCopies.VisibleInDetailsView = DefaultableBoolean.True;
cNumberOfCopies.DataType = typeof(Int32);
UltraListViewSubItemColumn cFormId = new UltraListViewSubItemColumn();
cFormId.Text = "FormId";
cFormId.VisibleInDetailsView = DefaultableBoolean.False;
cFormId.DataType = typeof(Int32);
ulvPrintSeries.SubItemColumns.Add(cNumberOfCopies);
ulvPrintSeries.SubItemColumns.Add(cFormId);
List <FormFormSeries> allffs = FormFormSeriesDAO.DAO.GetAllByFormSeriesId(fs.Id);
allffs.AddRange(this.newFfs);
foreach (FormFormSeries ffs in allffs)
{
VWA4Common.DataObject.Formx f = FormDAO.DAO.Load(ffs.FormId);
UltraListViewItem i = ulvPrintSeries.Items.Add(ffs.Id.ToString(), f.Name);
i.CheckState = ffs.Enabled ? CheckState.Checked : CheckState.Unchecked;
i.SubItems[0].Value = ffs.NumberOfCopies;
i.SubItems[1].Value = ffs.FormId;
}
this.pnlPrintSeries.Controls.Add(ulvPrintSeries);
}
private void deleteFormFormSeries_Click(object sender, EventArgs e)
{
if (this.ulvPrintSeries.SelectedItems.Count > 0)
{
FormFormSeries ffs = FormFormSeriesDAO.DAO.Load(Convert.ToInt32(ulvPrintSeries.SelectedItems[0].Key));
VWA4Common.DataObject.Formx f = FormDAO.DAO.Load(ffs.FormId);
FormSeries fs = FormSeriesDAO.DAO.Load(ffs.FormSeriesId);
if (MessageBox.Show(string.Format("Are you sure you want to delete Form '{0}' from Form Series '{1}'?", f.Name, fs.Name), "Delete Form", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes)
{
FormFormSeriesDAO.DAO.Delete(ffs);
}
this.ulvPrintSeries.Items.Remove(this.ulvPrintSeries.SelectedItems[0]);
}
}
void ulvFormSeries_MouseDown(object sender, MouseEventArgs e)
{
if (e.Button == MouseButtons.Right)
{
Point cursorPos = new Point(e.X, e.Y);
UltraListView listView = sender as UltraListView;
UltraListViewItem itemAtPoint = listView.ItemFromPoint(cursorPos, true);
if (itemAtPoint != null)
{
Infragistics.Win.ISelectionManager selectionManager = listView as Infragistics.Win.ISelectionManager;
selectionManager.SelectItem(itemAtPoint, true);
itemAtPoint.Activate();
contextMenuStrip2.Enabled = true;
contextMenuStrip2.Show(listView, new Point(e.X, e.Y));
}
else
{
contextMenuStrip2.Enabled = false;
}
}
else if (e.Button == MouseButtons.Left)
{
Point cursorPos = new Point(e.X, e.Y);
UltraListView listView = sender as UltraListView;
UltraListViewItem itemAtPoint = listView.ItemFromPoint(cursorPos, true);
if (itemAtPoint != null)
{
Infragistics.Win.ISelectionManager selectionManager = listView as Infragistics.Win.ISelectionManager;
selectionManager.SelectItem(itemAtPoint, true);
itemAtPoint.Activate();
FormSeries fs = FormSeriesDAO.DAO.Load(Convert.ToInt32(listView.SelectedItems[0].Key));
this.pnlPrintSeriesPanel.Visible = true;
this.lblPrintSeriesName.Text = fs.Name + " Series";
this.loadPrintSeries(fs);
}
}
}
public rptFormSeries(FormSeries fs)
{
this.formSeries = fs;
this.formformSeries = FormFormSeriesDAO.DAO.GetAllByFormSeriesId(fs.Id);
InitializeComponent();
}
public frmSeriesProperties(FormSeries fs)
{
InitializeComponent();
updateProductUI();
this.lblNameValue.Text += fs.Name;
this.lblDateCreatedValue.Text += fs.CreateDate.ToShortDateString();
this.lblLastModifiedDateValue.Text += fs.ModifiedDate.ToShortDateString();
UltraListView ulvForms = new UltraListView();
ulvForms.Reset();
ulvForms.Width = 306;
ulvForms.Height = 236;
ulvForms.View = UltraListViewStyle.Details;
ulvForms.ItemSettings.Appearance.Image = imageList1.Images[0];
ulvForms.ViewSettingsDetails.SubItemColumnsVisibleByDefault = true;
ulvForms.ViewSettingsDetails.AutoFitColumns = AutoFitColumns.ResizeAllColumns;
ulvForms.ItemSettings.SubItemsVisibleInToolTipByDefault = false;
ulvForms.ItemSettings.SelectionType = SelectionType.Single;
UltraListViewMainColumn mainColumn = ulvForms.MainColumn;
mainColumn.Text = "Form Name";
mainColumn.Width = 120;
mainColumn.DataType = typeof(System.Int32);
UltraListViewSubItemColumn cDocType = new UltraListViewSubItemColumn();
cDocType.Text = "Type";
cDocType.Width = 50;
cDocType.VisibleInDetailsView = DefaultableBoolean.True;
cDocType.DataType = typeof(String);
UltraListViewSubItemColumn cDataEntryTemplate = new UltraListViewSubItemColumn();
cDataEntryTemplate.Text = "Data Entry Template";
cDataEntryTemplate.Width = 136;
cDataEntryTemplate.VisibleInDetailsView = DefaultableBoolean.True;
cDataEntryTemplate.DataType = typeof(Int32);
ulvForms.SubItemColumns.Add(cDocType);
ulvForms.SubItemColumns.Add(cDataEntryTemplate);
ValueList docType = new ValueList();
ValueList dataEntryTemplate = new ValueList();
foreach (VWA4Common.DataObject.Formx f in FormDAO.DAO.GetAllBySeriesId(fs.Id))
{
docType.ValueListItems.Add(f.DocumentType, f.DocumentType);
dataEntryTemplate.ValueListItems.Add(f.DataEntryTemplateId, VWA4Common.DB.Retrieve(string.Format("select DETName from DataEntryTemplates where ID={0}", f.DataEntryTemplateId)).Rows[0]["DETName"].ToString());
UltraListViewItem i = ulvForms.Items.Add(Guid.NewGuid().ToString(), f.Name);
i.SubItems[0].Value = f.DocumentType;
i.SubItems[1].Value = f.DataEntryTemplateId;
}
ulvForms.SubItemColumns[0].ValueList = docType;
ulvForms.SubItemColumns[1].ValueList = dataEntryTemplate;
this.pnlFormsInSeries.Controls.Add(ulvForms);
}
public int Insert(FormSeries fs)
{
return(this.Insert(fs.Name, fs.CreateDate, fs.ModifiedDate));
}