public int deleteByUser(int userid)
{
AbstractCommonData entity = new LetterItemsPermissionEntity();
string delQuery = "DELETE FROM " + entity.TableName + " WHERE " + LetterItemsPermissionEntity.FIELD_USER_ID + "=" + provider.getSQLString(userid);
return(provider.delete(delQuery));
}
public LetterItemsPermissionEntity getByUser(int userid)
{
LetterItemsPermissionEntity entity = new LetterItemsPermissionEntity();
string cond = LetterItemsPermissionEntity.FIELD_USER_ID + "=" + provider.getSQLString(userid);
provider.loadToDataSet(entity, cond);
return(entity);
}
public LetterItemsPermissionEntity getByTableindex(int tableindex)
{
LetterItemsPermissionEntity entity = new LetterItemsPermissionEntity();
string cond = LetterItemsPermissionEntity.FIELD_ID + "=" + provider.getSQLString(tableindex);
provider.loadToDataSet(entity, cond);
return(entity);
}
private void btnSave_Click(object sender, EventArgs e)
{
LetterItemsPermissionEntity entity = new LetterItemsPermissionEntity();
DataRow dr = entity.Tables[entity.TableName].NewRow();
if (_userid > 0)
{
dr[LetterItemsPermissionEntity.FIELD_USER_ID] = _userid;
dr[LetterItemsPermissionEntity.FIELD_ID] = _tableIndex;
dr[LetterItemsPermissionEntity.FIELD_RECIEVEDLETTERNUMBER] = cbRecievedLetterNumber.Checked;
dr[LetterItemsPermissionEntity.FIELD_RECIEVEDLETTERDATE] = cbRecievedLetterDate.Checked;
dr[LetterItemsPermissionEntity.FIELD_INPUT_REGISTER_NUMBER] = cbInputRegisterNumber.Checked;
dr[LetterItemsPermissionEntity.FIELD_BTN_SEARCH] = cbBtnSearch.Checked;
dr[LetterItemsPermissionEntity.FIELD_LETTER_SUBJECT] = cbLetterSubject.Checked;
dr[LetterItemsPermissionEntity.FIELD_LETTER_SUMMARY] = cbSummary.Checked;
dr[LetterItemsPermissionEntity.FIELD_COMPANY_ID] = cbCmbCompanyId.Checked;
dr[LetterItemsPermissionEntity.FIELD_INSURANCE_TYPE_ID] = cbCmbInsuranceType.Checked;
dr[LetterItemsPermissionEntity.FIELD_MANAGEMENT_ACTION] = cbCmbManagemtAction.Checked;
dr[LetterItemsPermissionEntity.FIELD_INSURANCE_DATE] = cbInsuranceDate.Checked;
dr[LetterItemsPermissionEntity.FIELD_INSURANCE_NUMBER] = cbCmbInsuranceNumber.Checked;
dr[LetterItemsPermissionEntity.FIELD_LETTER_STATE_ID] = cbCmbLetterStateId.Checked;
dr[LetterItemsPermissionEntity.FIELD_BTN_LETTER_STATE] = cbBtnLetterState.Checked;
dr[LetterItemsPermissionEntity.FIELD_REFERENCED_USER_ID] = cbCmbReferenceUserId.Checked;
dr[LetterItemsPermissionEntity.FIELD_ARCHIVE] = cbCbArchive.Checked;
dr[LetterItemsPermissionEntity.FIELD_FINAL_CONFIRM] = cbCbFinalConfirm.Checked;
dr[LetterItemsPermissionEntity.FIELD_BTN_USERS_REPLIES] = cbBtnUsersReplies.Checked;
dr[LetterItemsPermissionEntity.FIELD_BTN_REFER_TO_MASTER] = cbRefertoMaster.Checked;
dr[LetterItemsPermissionEntity.FIELD_BTN_SHOW_REFFRENCES] = cbShowReffrences.Checked;
dr[LetterItemsPermissionEntity.FIELD_ALARM_STARTDATE] = cbAlarmStartDate.Checked;
dr[LetterItemsPermissionEntity.FIELD_BTN_AGENT] = cbAgent.Checked;
dr[LetterItemsPermissionEntity.FIELD_DELETE_LETTER] = cbDeleteLetter.Checked;
dr[LetterItemsPermissionEntity.FIELD_FASTACTION] = cbCbFastAction.Checked;
dr[LetterItemsPermissionEntity.FIELD_BTN_DO_CHANING_TO_RECIEVE] = cbDoChainingToRecieve.Checked;
dr[LetterItemsPermissionEntity.FIELD_BTN_DO_CHANING_TO_SEND] = cbDoChainingToSend.Checked;
dr[LetterItemsPermissionEntity.FIELD_BTN_SEPERATE_CHANING] = cbSeperateFromChain.Checked;
dr[LetterItemsPermissionEntity.FIELD_INSURANCE_COMPANY] = cbInsuranceCompany.Checked;
entity.Tables[entity.TableName].Rows.Add(dr);
if (_tableIndex < 0)
{
_tableIndex = _letterItemPermBL.addPermission(entity);
}
else
{
_letterItemPermBL.update(entity);
}
lblMsg.Text = "تغییرات ثبت گردید";
}
}
private void doPermision()
{
//permision
if (UsersBS.ADMIN.ToString().Equals(UsersBS.loginedUser.get(UsersEntity.FIELD_USER_TYPE).ToString()))
{
return;
}
int userid = int.Parse(UsersBS.loginedUser.get(UsersEntity.FIELD_ID).ToString());
LetterItemsPermissionBL letItemPerm = new LetterItemsPermissionBL();
LetterItemsPermissionEntity entity = letItemPerm.getByUser(userid);
doPerm(btnDelete, entity.get(LetterItemsPermissionEntity.FIELD_DELETE_LETTER));
}
public void load()
{
_letterItemPermBL = new LetterItemsPermissionBL();
LetterItemsPermissionEntity entity = _letterItemPermBL.getByUser(_userid);
if (entity.Tables[entity.FilledTableName].Rows.Count <= 0)
{
setAllUnchecked();
return;
}
_tableIndex = int.Parse(entity.get(LetterItemsPermissionEntity.FIELD_ID).ToString());
doItem(entity, LetterItemsPermissionEntity.FIELD_RECIEVEDLETTERNUMBER, txtRecievedLetterNumber);
doItem(entity, LetterItemsPermissionEntity.FIELD_RECIEVEDLETTERNUMBER, txtRecievedLetterDate);
doItem(entity, LetterItemsPermissionEntity.FIELD_LETTER_SUBJECT, txtLetterSubject);
doItem(entity, LetterItemsPermissionEntity.FIELD_INPUT_REGISTER_NUMBER, txtInputRegisterNumber);
doItem(entity, LetterItemsPermissionEntity.FIELD_BTN_SEARCH, btnSearch);
doItem(entity, LetterItemsPermissionEntity.FIELD_LETTER_SUMMARY, txtSummary);
doItem(entity, LetterItemsPermissionEntity.FIELD_INSURANCE_TYPE_ID, cmbInsuranceType);
doItem(entity, LetterItemsPermissionEntity.FIELD_MANAGEMENT_ACTION, cmbManagemtAction);
doItem(entity, LetterItemsPermissionEntity.FIELD_INSURANCE_DATE, txtInsuranceDate);
doItem(entity, LetterItemsPermissionEntity.FIELD_INSURANCE_NUMBER, txtInsuranceNumber);
doItem(entity, LetterItemsPermissionEntity.FIELD_COMPANY_ID, cmbCompanyId);
doItem(entity, LetterItemsPermissionEntity.FIELD_LETTER_STATE_ID, cmbLetterStateId);
doItem(entity, LetterItemsPermissionEntity.FIELD_BTN_LETTER_STATE, btnLetterState);
doItem(entity, LetterItemsPermissionEntity.FIELD_REFERENCED_USER_ID, cmbReferenceUserId);
doItem(entity, LetterItemsPermissionEntity.FIELD_ARCHIVE, cbCbArchive);
doItem(entity, LetterItemsPermissionEntity.FIELD_FINAL_CONFIRM, cbCbFinalConfirm);
doItem(entity, LetterItemsPermissionEntity.FIELD_BTN_USERS_REPLIES, btnUsersReplies);
doItem(entity, LetterItemsPermissionEntity.FIELD_BTN_REFER_TO_MASTER, btnReferToMasterUSer);
doItem(entity, LetterItemsPermissionEntity.FIELD_BTN_SHOW_REFFRENCES, btnShowRefrences);
doItem(entity, LetterItemsPermissionEntity.FIELD_ALARM_STARTDATE, txtRefferDate);
doItem(entity, LetterItemsPermissionEntity.FIELD_BTN_AGENT, btnAgent);
doItem(entity, LetterItemsPermissionEntity.FIELD_DELETE_LETTER, btnDelete);
doItem(entity, LetterItemsPermissionEntity.FIELD_FASTACTION, cbCbFastAction);
doItem(entity, LetterItemsPermissionEntity.FIELD_BTN_DO_CHANING_TO_RECIEVE, btnDoChainingToRecive);
doItem(entity, LetterItemsPermissionEntity.FIELD_BTN_DO_CHANING_TO_SEND, btnDoChainingToSend);
doItem(entity, LetterItemsPermissionEntity.FIELD_BTN_SEPERATE_CHANING, btnSeperateFromChain);
doItem(entity, LetterItemsPermissionEntity.FIELD_INSURANCE_COMPANY, cmbInsuranceCompany);
}
private void doItem(LetterItemsPermissionEntity entity, string fld, Control item)
{
bool b = false;
if (entity.get(fld).ToString().Length <= 0)
{
b = false;
}
else
{
b = bool.Parse(entity.get(fld).ToString());
}
if (b)
{
checkItem(item);
}
else
{
UncheckItem(item);
}
}
public int update(LetterItemsPermissionEntity entity)
{
return(provider.update(entity));
}
public int addPermission(LetterItemsPermissionEntity entity)
{
return(provider.add(entity));
}
public int update(LetterItemsPermissionEntity entity)
{
return(((LetterItemsPermissionDA)_abstractDA).update(entity));
}
public int addPermission(LetterItemsPermissionEntity entity)
{
return(((LetterItemsPermissionDA)_abstractDA).addPermission(entity));
}
