private void btnSave_Click(object sender, EventArgs e) { ReferenceCycleEntity entity = new ReferenceCycleEntity(); DataRow dr = entity.Tables[entity.TableName].NewRow(); if (_id < 0) { return; } dr[ChequeEntity.FIELD_ID] = _id; dr[ReferenceCycleEntity.FIELD_LETTERID] = _entity.get(ReferenceCycleEntity.FIELD_LETTERID); dr[ReferenceCycleEntity.FIELD_FIRSTREFERDATE] = _entity.get(ReferenceCycleEntity.FIELD_FIRSTREFERDATE); dr[ReferenceCycleEntity.FIELD_FIRSTFROMUSER] = _entity.get(ReferenceCycleEntity.FIELD_FIRSTFROMUSER); dr[ReferenceCycleEntity.FIELD_FIRSTTOUSER] = _entity.get(ReferenceCycleEntity.FIELD_FIRSTTOUSER); dr[ReferenceCycleEntity.FIELD_SECONDREFERDATE] = _entity.get(ReferenceCycleEntity.FIELD_SECONDREFERDATE); dr[ReferenceCycleEntity.FIELD_SECONDFROMUSER] = _entity.get(ReferenceCycleEntity.FIELD_SECONDFROMUSER); dr[ReferenceCycleEntity.FIELD_SECONDTOUSER] = _entity.get(ReferenceCycleEntity.FIELD_SECONDTOUSER); dr[ReferenceCycleEntity.FIELD_ACTION] = ((ComboBoxItem)cmbAction.Items[cmbAction.SelectedIndex]).Value; dr[ReferenceCycleEntity.FIELD_ACTIONDESCRIPTION] = txtActionDesc.Text; dr[ReferenceCycleEntity.FIELD_ARCHIVE] = cbArchive.Checked; entity.Tables[entity.TableName].Rows.Add(dr); _refCycleBL.update(entity); this.Close(); }
public int delete(int id) { AbstractCommonData entity = new ReferenceCycleEntity(); string delQuery = "DELETE FROM " + entity.TableName + " where " + entity.IndexFieldName + "=" + provider.getSQLString(id); return(provider.delete(delQuery)); }
private void search() { cmbCompareDate.SelectedIndex = 5; string cond = ""; cond = _searchTools.getStringFldCond(ReferenceCycleEntity.FIELD_LETTERID + "_DESC", txtLetterNumber.Text, cond); cond = _searchTools.getCheckBoxListCond(cbRefferFrom, ReferenceCycleEntity.FIELD_SECONDTOUSER, cond); cond = _searchTools.getDateFldCond(ReferenceCycleEntity.FIELD_SECONDREFERDATE, txtRefDateFrom.Text, txtRefDateTo.Text, cmbCompareDate, cond); cond = _searchTools.getCheckBoxListCond(cbReferAction, ReferenceCycleEntity.FIELD_ACTION, cond); cond = _searchTools.getStringFldCond(ReferenceCycleEntity.FIELD_ACTIONDESCRIPTION, txtAction.Text, cond); if (cond.Length > 0) { cond += "and"; } if (cbArchived.Checked) { cond += " " + ReferenceCycleEntity.FIELD_ARCHIVE + "=1"; } else { cond += " (" + ReferenceCycleEntity.FIELD_ARCHIVE + "=0" + " OR " + ReferenceCycleEntity.FIELD_ARCHIVE + " is null)"; } ReferenceCycleEntity entity = null; entity = _referenceCycleBl.get(cond); System.Collections.Hashtable hash = new Hashtable(); _gridTools.bindDataToGrid(dataGridView1, entity, null, hash); }
public ReferenceCycleEntity get(int id) { ReferenceCycleEntity entity = new ReferenceCycleEntity(); string cond = ReferenceCycleEntity.FIELD_ID + "=" + provider.getSQLString(id); provider.loadToDataSet(entity, cond); return(entity); }
public ReferenceCycleEntity get() { ReferenceCycleEntity entity = new ReferenceCycleEntity(); string cond = "ID > 0"; provider.loadToDataSet(entity, cond); return(entity); }
private void fillGrid(string cond) { ReferenceCycleEntity entity = null; entity = _referenceCycleBl.get(cond); System.Collections.Hashtable hash = new Hashtable(); _gridTools.bindDataToGrid(dataGridView1, entity, null, hash); }
public ReferenceCycleEntity get(string cond) { ReferenceCycleEntity entity = new ReferenceCycleEntity(); if (cond.Length > 0) { cond += " AND "; } cond += "ID > 0"; provider.loadToDataSet(entity, cond); return(entity); }
private void init() { if (_id <= 0) { return; } _entity = _refCycleBL.get(_id); txtLetterNumber.Text = _entity.get(ReferenceCycleEntity.FIELD_LETTERID + "_DESC").ToString(); txtFirstRefDate.Text = _entity.get(ReferenceCycleEntity.FIELD_FIRSTREFERDATE + "").ToString(); DateConverter converter = new DateConverter(); txtFirstRefDate.Text = converter.valueToString(_entity.get(ReferenceCycleEntity.FIELD_FIRSTREFERDATE)); txtSecondRefDate.Text = converter.valueToString(_entity.get(ReferenceCycleEntity.FIELD_SECONDREFERDATE)); txtFirstRefFromUser.Text = _entity.get(ReferenceCycleEntity.FIELD_FIRSTFROMUSER + "_DESC").ToString(); txtFirstRefToUser.Text = _entity.get(ReferenceCycleEntity.FIELD_FIRSTTOUSER + "_DESC").ToString(); txtSecondRefFromUser.Text = _entity.get(ReferenceCycleEntity.FIELD_SECONDFROMUSER + "_DESC").ToString(); txtSecondRefToUser.Text = _entity.get(ReferenceCycleEntity.FIELD_SECONDTOUSER + "_DESC").ToString(); int action = 0; if (_entity.get(ReferenceCycleEntity.FIELD_ACTION).ToString().Length > 0) { action = int.Parse(_entity.get(ReferenceCycleEntity.FIELD_ACTION).ToString()); } BasicInfoUtil.fillComboBox(cmbAction, "ReferenceCycleAction", action); txtActionDesc.Text = _entity.get(ReferenceCycleEntity.FIELD_ACTIONDESCRIPTION).ToString(); bool archive = false; string a = _entity.get(ReferenceCycleEntity.FIELD_ARCHIVE).ToString(); if (a == null || a.Length == 0) { archive = false; } else { archive = bool.Parse(a); } cbArchive.Checked = archive; }
/** * find any cycle happening in any refer o fletter between users * */ private void checkForReferenceCycle(int letterId, int newFromUserId, int newToUserId) { ReferLetterEntity referEntity = getLastReferedEntity(letterId); if (referEntity == null) { return; } int lastFromUser = int.Parse( referEntity.Tables[0].Rows[0][ReferLetterEntity.FIELD_REFER_FROM_USER].ToString()); if (lastFromUser == newToUserId) { //a cycle happened // persist it ReferenceCycleEntity cycleEntity = new ReferenceCycleEntity(); DataRow dr = null; dr = cycleEntity.Tables[cycleEntity.TableName].NewRow(); cycleEntity.FilledTableName = cycleEntity.TableName; dr[ReferenceCycleEntity.FIELD_FIRSTREFERDATE] = referEntity.Tables[0].Rows[0][ReferLetterEntity.FIELD_REFER_DATE]; dr[ReferenceCycleEntity.FIELD_FIRSTFROMUSER] = referEntity.Tables[0].Rows[0][ReferLetterEntity.FIELD_REFER_FROM_USER]; dr[ReferenceCycleEntity.FIELD_FIRSTTOUSER] = referEntity.Tables[0].Rows[0][ReferLetterEntity.FIELD_REFER_TO_USER]; dr[ReferenceCycleEntity.FIELD_SECONDREFERDATE] = DateTime.Now; dr[ReferenceCycleEntity.FIELD_SECONDFROMUSER] = newFromUserId; dr[ReferenceCycleEntity.FIELD_SECONDTOUSER] = newToUserId; dr[ReferenceCycleEntity.FIELD_LETTERID] = letterId; cycleEntity.Tables[cycleEntity.TableName].Rows.Add(dr); ReferenceCycleBL referenceCycleBL = new ReferenceCycleBL(); referenceCycleBL.add(cycleEntity); } }
public int update(ReferenceCycleEntity entity) { return(((ReferenceCycleDA)_abstractDA).update(entity)); }
public int add(ReferenceCycleEntity entity) { return(((ReferenceCycleDA)_abstractDA).add(entity)); }
public int update(ReferenceCycleEntity entity) { return(provider.update(entity)); }
public int add(ReferenceCycleEntity entity) { return(provider.add(entity)); }