public void load()
{
_chequeFieldsPermBL = new ChequeFieldsPermissionBL();
ChequeFieldsPermissionEntity entity = _chequeFieldsPermBL.getByUser(_userid);
if (entity.Tables[entity.FilledTableName].Rows.Count <= 0)
{
setAllUnchecked();
return;
}
_tableIndex = int.Parse(entity.get(ChequeFieldsPermissionEntity.FIELD_ID).ToString());
doItem(entity, ChequeFieldsPermissionEntity.FIELD_PAYTYPE, cmbPayType, cbcmbPayType);
doItem(entity, ChequeFieldsPermissionEntity.FIELD_CHEQUENUMBER, txtChequeNumber, cbtxtChequeNumber);
doItem(entity, ChequeFieldsPermissionEntity.FIELD_MATURITYDATE, txtMaturityDate, cbtxtMaturityDate);
doItem(entity, ChequeFieldsPermissionEntity.FIELD_ENTRYDATE, txtEntryDate, cbtxtEntryDate);
doItem(entity, ChequeFieldsPermissionEntity.FIELD_BANKID, cmbBankId, cbcmbBankId);
doItem(entity, ChequeFieldsPermissionEntity.FIELD_PRICE, txtPrice, cbtxtPrice);
doItem(entity, ChequeFieldsPermissionEntity.FIELD_ACCOUNTNUMBER, txtAccountNumber, cbtxtAccountNumber);
doItem(entity, ChequeFieldsPermissionEntity.FIELD_COMPANYID, txtCompany, cbtxtCompany);
doItem(entity, ChequeFieldsPermissionEntity.FIELD_REFFERFROM, cmbReferenceUserId, cbcmbReferenceUserId);
doItem(entity, ChequeFieldsPermissionEntity.FIELD_REFFERDATE, txtRefferDate, cbtxtRefferDate);
doItem(entity, ChequeFieldsPermissionEntity.FIELD_INSURANCECOMPANY, cmbInsuranceCompany, cbcmbInsuranceCompany);
doItem(entity, ChequeFieldsPermissionEntity.FIELD_INSURANCENUMBER, txtInsuranceNumber, cbtxtInsuranceNumber);
doItem(entity, ChequeFieldsPermissionEntity.FIELD_ACCOUNTHOLDERNAME, txtAccountHolderName, cbtxtAccountHolderName);
doItem(entity, ChequeFieldsPermissionEntity.FIELD_ARCHIVE, cbArchive, cbcbArchive);
doItem(entity, ChequeFieldsPermissionEntity.FIELD_CHEQUEITEMS, null, cbdataGridView1);
}
public int deleteByUser(int userid)
{
AbstractCommonData entity = new ChequeFieldsPermissionEntity();
string delQuery = "DELETE FROM " + entity.TableName + " WHERE " + ChequeFieldsPermissionEntity.FIELD_USERID + "=" + provider.getSQLString(userid);
return(provider.delete(delQuery));
}
private void setPermision()
{
int userid = int.Parse(UsersBS.loginedUser.get(UsersEntity.FIELD_ID).ToString());
ChequeFieldsPermissionBL chqFieldsPermBL = new ChequeFieldsPermissionBL();
ChequeFieldsPermissionEntity m_permissionEntity = chqFieldsPermBL.getByUser(userid);
if (UsersBS.ADMIN.ToString().Equals(UsersBS.loginedUser.get(UsersEntity.FIELD_USER_TYPE).ToString()))
{
return;
}
doPerm(cmbPayType, m_permissionEntity.get(ChequeFieldsPermissionEntity.FIELD_PAYTYPE));
doPerm(txtChequeNumber, m_permissionEntity.get(ChequeFieldsPermissionEntity.FIELD_CHEQUENUMBER));
doPerm(txtMaturityDate, m_permissionEntity.get(ChequeFieldsPermissionEntity.FIELD_MATURITYDATE));
doPerm(txtEntryDate, m_permissionEntity.get(ChequeFieldsPermissionEntity.FIELD_ENTRYDATE));
doPerm(cmbBankId, m_permissionEntity.get(ChequeFieldsPermissionEntity.FIELD_BANKID));
doPerm(txtPrice, m_permissionEntity.get(ChequeFieldsPermissionEntity.FIELD_PRICE));
doPerm(txtAccountNumber, m_permissionEntity.get(ChequeFieldsPermissionEntity.FIELD_ACCOUNTNUMBER));
doPerm(txtCompany, m_permissionEntity.get(ChequeFieldsPermissionEntity.FIELD_COMPANYID));
doPerm(btnShowCompany, m_permissionEntity.get(ChequeFieldsPermissionEntity.FIELD_COMPANYID));
doPerm(txtRefferDate, m_permissionEntity.get(ChequeFieldsPermissionEntity.FIELD_REFFERDATE));
doPerm(cmbReferenceUserId, m_permissionEntity.get(ChequeFieldsPermissionEntity.FIELD_REFFERFROM));
doPerm(cmbInsuranceCompany, m_permissionEntity.get(ChequeFieldsPermissionEntity.FIELD_INSURANCECOMPANY));
doPerm(txtInsuranceNumber, m_permissionEntity.get(ChequeFieldsPermissionEntity.FIELD_INSURANCENUMBER));
doPerm(txtAccountHolderName, m_permissionEntity.get(ChequeFieldsPermissionEntity.FIELD_ACCOUNTHOLDERNAME));
doPerm(tblReply, m_permissionEntity.get(ChequeFieldsPermissionEntity.FIELD_CHEQUEITEMS));
doPerm(cbArchive, m_permissionEntity.get(ChequeFieldsPermissionEntity.FIELD_ARCHIVE));
}
public ChequeFieldsPermissionEntity getByTableindex(int tableindex)
{
ChequeFieldsPermissionEntity entity = new ChequeFieldsPermissionEntity();
string cond = ChequeFieldsPermissionEntity.FIELD_ID + "=" + provider.getSQLString(tableindex);
provider.loadToDataSet(entity, cond);
return(entity);
}
public ChequeFieldsPermissionEntity getByUser(int userid)
{
ChequeFieldsPermissionEntity entity = new ChequeFieldsPermissionEntity();
string cond = ChequeFieldsPermissionEntity.FIELD_USERID + "=" + provider.getSQLString(userid);
provider.loadToDataSet(entity, cond);
return(entity);
}
private void doItem(ChequeFieldsPermissionEntity entity, string fld, Control item, CheckBox checkBoxControl)
{
bool b = false;
if (entity.get(fld).ToString().Length <= 0)
{
b = false;
}
else
{
b = bool.Parse(entity.get(fld).ToString());
}
checkBoxControl.Checked = b;
}
private void btnSave_Click(object sender, EventArgs e)
{
ChequeFieldsPermissionEntity entity = new ChequeFieldsPermissionEntity();
DataRow dr = entity.Tables[entity.TableName].NewRow();
if (_userid > 0)
{
dr[ChequeFieldsPermissionEntity.FIELD_USERID] = _userid;
dr[ChequeFieldsPermissionEntity.FIELD_ID] = _tableIndex;
dr[ChequeFieldsPermissionEntity.FIELD_PAYTYPE] = cbcmbPayType.Checked;
dr[ChequeFieldsPermissionEntity.FIELD_CHEQUENUMBER] = cbtxtChequeNumber.Checked;
dr[ChequeFieldsPermissionEntity.FIELD_MATURITYDATE] = cbtxtMaturityDate.Checked;
dr[ChequeFieldsPermissionEntity.FIELD_ENTRYDATE] = cbtxtEntryDate.Checked;
dr[ChequeFieldsPermissionEntity.FIELD_BANKID] = cbcmbBankId.Checked;
dr[ChequeFieldsPermissionEntity.FIELD_PRICE] = cbtxtPrice.Checked;
dr[ChequeFieldsPermissionEntity.FIELD_ACCOUNTNUMBER] = cbtxtAccountNumber.Checked;
dr[ChequeFieldsPermissionEntity.FIELD_COMPANYID] = cbtxtCompany.Checked;
dr[ChequeFieldsPermissionEntity.FIELD_REFFERFROM] = cbcmbReferenceUserId.Checked;
dr[ChequeFieldsPermissionEntity.FIELD_REFFERDATE] = cbtxtRefferDate.Checked;
dr[ChequeFieldsPermissionEntity.FIELD_INSURANCECOMPANY] = cbcmbInsuranceCompany.Checked;
dr[ChequeFieldsPermissionEntity.FIELD_INSURANCENUMBER] = cbtxtInsuranceNumber.Checked;
dr[ChequeFieldsPermissionEntity.FIELD_ACCOUNTHOLDERNAME] = cbtxtAccountHolderName.Checked;
dr[ChequeFieldsPermissionEntity.FIELD_ARCHIVE] = cbcbArchive.Checked;
dr[ChequeFieldsPermissionEntity.FIELD_CHEQUEITEMS] = cbdataGridView1.Checked;
entity.Tables[entity.TableName].Rows.Add(dr);
if (_tableIndex < 0)
{
_tableIndex = _chequeFieldsPermBL.addPermission(entity);
}
else
{
_chequeFieldsPermBL.update(entity);
}
lblMsg.Text = "تغییرات ثبت گردید";
}
}
public int update(ChequeFieldsPermissionEntity entity)
{
return(provider.update(entity));
}
public int addPermission(ChequeFieldsPermissionEntity entity)
{
return(provider.add(entity));
}
public int update(ChequeFieldsPermissionEntity entity)
{
return(((ChequeFieldsPermissionDA)_abstractDA).update(entity));
}
public int addPermission(ChequeFieldsPermissionEntity entity)
{
return(((ChequeFieldsPermissionDA)_abstractDA).addPermission(entity));
}
