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