private void propertiesFormFormSeries_Click(object sender, EventArgs e)
{
if (this.ulvPrintSeries.SelectedItems.Count > 0)
{
FormFormSeries editFfs = new FormFormSeries();
try
{
editFfs = FormFormSeriesDAO.DAO.Load(Convert.ToInt32(ulvPrintSeries.SelectedItems[0].Key));
}
catch (Exception)
{
foreach (FormFormSeries ffs in this.newFfs)
{
if (ffs.Id == Convert.ToInt32(ulvPrintSeries.SelectedItems[0].Key))
{
editFfs = ffs;
break;
}
}
}
frmFormFormSeriesProperties prop = new frmFormFormSeriesProperties(editFfs);
prop.ShowDialog();
}
}
private void editFormFormSeries_Click(object sender, EventArgs e)
{
if (ulvPrintSeries.SelectedItems.Count > 0)
{
FormFormSeries editFfs = new FormFormSeries();
try
{
editFfs = FormFormSeriesDAO.DAO.Load(Convert.ToInt32(ulvPrintSeries.SelectedItems[0].Key));
}
catch (Exception)
{
foreach (FormFormSeries ffs in this.newFfs)
{
if (ffs.Id == Convert.ToInt32(ulvPrintSeries.SelectedItems[0].Key))
{
editFfs = ffs;
break;
}
}
}
frmEditFormFormSeries edit = new frmEditFormFormSeries(editFfs);
edit.FormClosed += new FormClosedEventHandler(editFormFormSeries_FormClosed);
edit.ShowDialog();
}
}
private void btnSavePrintSeries_Click(object sender, EventArgs e)
{
int order = 1;
foreach (UltraListViewItem i in ulvPrintSeries.Items)
{
FormFormSeries ffs = new FormFormSeries();
try
{
ffs = FormFormSeriesDAO.DAO.Load(Convert.ToInt32(i.Key));
}
catch (Exception)
{
ffs.Id = 0;
}
ffs.FormId = Convert.ToInt32(i.SubItems[1].Value);
ffs.FormSeriesId = this.activePrintSeriesId;
ffs.Enabled = i.CheckState.Equals(CheckState.Checked) ? true : false;
ffs.SortOrder = order++;
ffs.NumberOfCopies = Convert.ToInt32(i.SubItems[0].Value);
FormFormSeriesDAO.DAO.InsertOrUpdate(ffs);
}
this.newFfs = new List <FormFormSeries>();
MessageBox.Show(string.Format("{0} has been saved.", this.lblPrintSeriesName.Text), "Manage Forms");
}
public frmEditFormFormSeries(FormFormSeries ffs)
{
InitializeComponent();
updateProductUI();
this.formFormSeries = ffs;
this.chkEnabled.Checked = ffs.Enabled;
this.txtNumberOfCopies.Text = ffs.NumberOfCopies.ToString();
}
public bool InsertOrUpdate(FormFormSeries ffs)
{
if (ffs.IsNew)
{
this.Insert(ffs);
return(true);
}
else
{
return(this.Update(ffs));
}
}
private FormFormSeries getDataObject(DataRow row)
{
FormFormSeries f = new FormFormSeries();
f.Id = Convert.ToInt32(row[0].ToString());
f.FormId = Convert.ToInt32(row[1].ToString());
f.FormSeriesId = Convert.ToInt32(row[2].ToString());
f.Enabled = Boolean.Parse(row[3].ToString());
f.NumberOfCopies = Convert.ToInt32(row[4].ToString());
f.SortOrder = Convert.ToInt32(row[5].ToString());
return(f);
}
public bool Update(FormFormSeries ffs)
{
string sql = "UPDATE FormFormSeries SET ";
sql += string.Format("FormId={0}, ", ffs.FormId);
sql += string.Format("FormSeriesId={0}, ", ffs.FormSeriesId);
sql += string.Format("Enabled={0}, ", ffs.Enabled);
sql += string.Format("NumberOfCopies={0}, ", ffs.NumberOfCopies);
sql += string.Format("SortOrder={0} ", ffs.SortOrder);
sql += string.Format(" WHERE ID={0}", ffs.Id);
return(DB.Update(sql));
}
private void OnDragEnd(UltraListView listView, bool canceled)
{
if (canceled == false && this.dragItem != null)
{
VWA4Common.DataObject.Formx f = FormDAO.DAO.Load(Convert.ToInt32(dragItem.Key));
UltraListViewItem i = new UltraListViewItem();
List <FormFormSeries> allffs = new List <FormFormSeries>();
allffs.AddRange(FormFormSeriesDAO.DAO.GetAllByFormSeriesId(this.activePrintSeriesId));
allffs.AddRange(this.newFfs);
foreach (FormFormSeries ffs in allffs)
{
if (ffs.FormId == f.Id && ffs.FormSeriesId == this.activePrintSeriesId)
{
MessageBox.Show("Duplicate forms cannot be added to the same series.", "Manage Forms");
return;
}
}
try
{
FormFormSeries ffs = new FormFormSeries
{
Id = FormFormSeriesDAO.DAO.GetNextId() + this.newFfs.Count,
FormId = f.Id,
FormSeriesId = this.activePrintSeriesId,
Enabled = true,
NumberOfCopies = 1,
SortOrder = (dropItem == null) ? 0 : dropItem.Index + 1
};
i.Key = ffs.Id.ToString();
i.Value = f.Name;
ulvPrintSeries.Items.Insert((dropItem == null) ? 0 : dropItem.Index + 1, i);
this.newFfs.Add(ffs);
}
catch (Exception ex)
{
throw ex;
}
i.CheckState = CheckState.Checked;
i.SubItems[0].Value = 1;
i.SubItems[1].Value = f.Id;
}
this.dragItem = this.dropItem = null;
this.lastMouseDown = new Point();
}
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]);
}
}
private void printToolStripMenuItem_Click(object sender, EventArgs e)
{
if (this.ulvForms.SelectedItems.Count > 0)
{
List <FormFormSeries> ffs = new List <FormFormSeries>();
FormFormSeries fs = new FormFormSeries();
fs.FormId = Convert.ToInt32(this.ulvForms.SelectedItems[0].Key);
ffs.Add(fs);
VWA4Common.DataObject.Formx f = FormDAO.DAO.Load(fs.FormId);
f.LastPrintedDate = DateTime.Now.ToShortDateString();
FormDAO.DAO.Update(f);
rptFormSeries rpt = new rptFormSeries(ffs);
rpt.Run();
}
}
public frmFormFormSeriesProperties(FormFormSeries ffs)
{
InitializeComponent();
updateProductUI();
VWA4Common.DataObject.Formx f = FormDAO.DAO.Load(ffs.FormId);
this.lblNameValue.Text += f.Name;
this.lblDocumentValue.Text += f.FileName;
this.lblTypeValue.Text += f.DocumentType;
this.lblLocationValue.Text += f.SavePath.Length > 0 ? f.SavePath : "Database";
this.lblTemplateValue.Text += f.DataEntryTemplateId != 0 ? VWA4Common.DB.Retrieve("select DETName from DataEntryTemplates where ID=" + f.DataEntryTemplateId).Rows[0]["DETName"] : "";
this.lblLastPrintDateValue.Text += f.LastPrintedDate;
this.lblCreateDateValue.Text += f.CreateDate.ToShortDateString();
this.lblLastModifiedDateValue.Text += f.ModifiedDate.ToShortDateString();
this.lblEnabledValue.Text += ffs.Enabled ? "Yes" : "No";
this.lblNumberOfCopiesValue.Text += ffs.NumberOfCopies.ToString();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (this.formSeries.IsNew)
{
this.formSeries.Name = this.txtName.Text;
this.formSeries.Id = FormSeriesDAO.DAO.Insert(this.formSeries);
if (!this.formSeries.IsNew)
{
for (int i = 0; i < ulvForms.CheckedItems.Count; i++)
{
FormFormSeries ffs = new FormFormSeries();
ffs.FormId = Convert.ToInt32(ulvForms.CheckedItems[i].Key);
ffs.FormSeriesId = this.formSeries.Id;
ffs.Enabled = true;
ffs.NumberOfCopies = 1;
FormFormSeriesDAO.DAO.Insert(ffs);
}
}
}
else
{
this.formSeries.Name = this.txtName.Text;
FormSeriesDAO.DAO.Update(this.formSeries);
FormFormSeriesDAO.DAO.ClearAllByFormSeriesId(this.formSeries.Id);
for (int i = 0; i < ulvForms.CheckedItems.Count; i++)
{
FormFormSeries ffs = new FormFormSeries();
ffs.FormId = Convert.ToInt32(ulvForms.CheckedItems[i].Key);
ffs.FormSeriesId = this.formSeries.Id;
ffs.Enabled = true;
ffs.NumberOfCopies = 1;
FormFormSeriesDAO.DAO.Insert(ffs);
}
}
this.Close();
}
public int Insert(FormFormSeries ffs)
{
return(this.Insert(ffs.FormId, ffs.FormSeriesId, ffs.Enabled, ffs.NumberOfCopies, ffs.SortOrder));
}
public bool Delete(FormFormSeries ffs)
{
return(this.Delete(ffs.Id));
}
