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