/// <summary>
/// selects user record for updation and show user form
/// </summary>
private void BindUpdateUserData()
{
int selectedrowindex = RoleData_dgv.SelectedCells[0].RowIndex;
RoleVo selectedData = (RoleVo)RoleData_dgv.Rows[selectedrowindex].DataBoundItem;
AddRoleForm newAddForm = new AddRoleForm(CommonConstants.MODE_UPDATE, selectedData);
newAddForm.ShowDialog(this);
if (newAddForm.IntSuccess > 0)
{
messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind(FormConditionVo());
}
else if (newAddForm.IntSuccess == 0)
{
messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind(FormConditionVo());
}
}
public List <RoleVo> GetAllPlayer()
{
List <RoleVo> list = new List <RoleVo>();
for (int i = 0; i < 3; i++)
{
RoleVo tempVo = new RoleVo();
PlayerData pl = new PlayerData();
StreamReader sr = null;
try
{
sr = File.OpenText(Application.persistentDataPath + "//playerData_" + i + ".json");
}
catch (Exception e)
{
continue;
}
string jsonStr = sr.ReadToEnd();
PlayerData jsonInfo = JsonUtility.FromJson <PlayerData>(jsonStr);
tempVo.Update(jsonInfo.roleVo);
list.Add(tempVo);
sr.Close();
sr.Dispose();
}
return(list);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
RoleVo inVo = (RoleVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Update m_mes_role");
sqlQuery.Append(" Set ");
sqlQuery.Append(" role_name = :rolename ");
sqlQuery.Append(" Where ");
sqlQuery.Append(" role_cd = :rolecd ;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("rolecd", inVo.RoleCode);
sqlParameter.AddParameterString("rolename", inVo.RoleName);
RoleVo outVo = new RoleVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
/// <summary>
/// Fills all user records to gridview control
/// </summary>
private void GridBind(RoleVo conditionInVo)
{
RoleData_dgv.DataSource = null;
try
{
RoleVo outVo = (RoleVo)base.InvokeCbm(new GetRoleMasterMntCbm(), conditionInVo, false);
RoleData_dgv.AutoGenerateColumns = false;
BindingSource bindingSource1 = new BindingSource(outVo.RoleListVo, null);
if (bindingSource1.Count > 0)
{
RoleData_dgv.DataSource = bindingSource1;
}
else
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); //role
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
RoleData_dgv.ClearSelection();
Update_btn.Enabled = false;
Delete_btn.Enabled = false;
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
private void OnOkClick(object obj)
{
RoleVo roleVo = DataManager.Instance.roleVo;
roleVo.name = inputName.text;
roleVo.id = id;
roleVo.level = 1;
roleVo.money = 0;
roleVo.exp = 0;
roleVo.charactor = charactorId;
roleVo.baseAttackBig = 0;
roleVo.baseAttackSmall = 0;
roleVo.baseCrit = 0;
roleVo.baseCritDamage = 0;
roleVo.baseDeface = 0;
roleVo.baseDefanceRate = 0;
roleVo.baseDuck = 0;
roleVo.baseHp = 0;
roleVo.baseMagicAttack = 0;
roleVo.baseMagicDefance = 0;
roleVo.baseMp = 0;
roleVo.baseSpeed = 0;
roleVo.dropServantRate = 0.05f;
roleVo.maxEquipNum = 50;
roleVo.maxItemNum = 50;
roleVo.maxServantNum = 20;
roleVo.ifShopOpen = false;
DataManager.Instance.servantModel.Add(StaticDataPool.Instance.staticUnitLevelPool.GetStaticDataVo(1, 1));
DataManager.Instance.servantModel.SetNow(0);
DataManager.Instance.mapModel.Create();
DataManager.Instance.Save(id);
UIManager.Instance.Create(Panel_ID.BattlePanel);
GameRoot.Instance.evt.CallEvent(GameEventDefine.LOAD_MAP, 1);
DataManager.Instance.currentPlayer = id;
}
/// <summary>
/// For setting selected user record into respective controls(textbox and combobox) for update operation
/// passing selected user data as parameter
/// </summary>
/// <param name="dgvData"></param>
private void LoadUserData(RoleVo dgvData)
{
if (dgvData != null)
{
RoleCode_txt.Text = dgvData.RoleCode;
RoleName_txt.Text = dgvData.RoleName;
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
RoleVo inVo = (RoleVo)arg;
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append("Select * from m_mes_role ");
sqlQuery.Append(" where 1 = 1 ");
if (inVo.RoleCode != null)
{
sqlQuery.Append(" and role_cd like :rolecd ");
}
if (inVo.RoleName != null)
{
sqlQuery.Append(" and role_name like :rolename ");
}
sqlQuery.Append(" order by role_cd");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
if (inVo.RoleCode != null)
{
sqlParameter.AddParameterString("rolecd", inVo.RoleCode + "%");
}
if (inVo.RoleName != null)
{
sqlParameter.AddParameterString("rolename", inVo.RoleName + "%");
}
sqlQuery.Append(" order by role_cd");
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
RoleVo outVo = new RoleVo();
while (dataReader.Read())
{
RoleVo currOutVo = new RoleVo
{
RoleCode = dataReader["role_cd"].ToString(),
RoleName = dataReader["role_name"].ToString()
};
outVo.RoleListVo.Add(currOutVo);
}
dataReader.Close();
return(outVo);
}
/// <summary>
/// constructor for the form
/// </summary>
/// <param name="pmode"></param>
/// <param name="dataItem"></param>
public AddRoleForm(string pmode, RoleVo dataItem = null)
{
InitializeComponent();
mode = pmode;
updateData = dataItem;
if (string.Equals(mode, CommonConstants.MODE_UPDATE))
{
this.Text = UpdateText_lbl.Text;
}
}
public void Create(RoleVo roleVo)
{
btnCreate.gameObject.SetActive(false);
btnDelete.gameObject.SetActive(true);
btnGo.gameObject.SetActive(true);
textName.gameObject.SetActive(true);
textLevel.gameObject.SetActive(true);
textCharactor.gameObject.SetActive(true);
textMoney.gameObject.SetActive(true);
textName.text = roleVo.name;
textLevel.text = "Lv." + roleVo.level.ToString();
textCharactor.text = StaticDataPool.Instance.staticUnitLevelPool.GetStaticDataVo(roleVo.charactor, 1).name;
textMoney.text = roleVo.exp.ToString();
}
/// <summary>
/// checks role relation to other tables in DB
/// </summary>
/// <param name="rolVo"></param>
/// <returns></returns>
private RoleVo CheckRelation(RoleVo rolVo)
{
RoleVo outVo = new RoleVo();
try
{
outVo = (RoleVo)base.InvokeCbm(new CheckRoleRelationCbm(), rolVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
return(outVo);
}
/// <summary>
/// Creates seacrh condition as per user inputs
/// </summary>
/// <returns>search condition</returns>
private RoleVo FormConditionVo()
{
RoleVo inVo = new RoleVo();
if (RoleCode_txt.Text != string.Empty)
{
inVo.RoleCode = RoleCode_txt.Text;
}
if (RoleName_txt.Text != string.Empty)
{
inVo.RoleName = RoleName_txt.Text;
}
return(inVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
RoleVo inVo = (RoleVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("select ro.role_cd, Count(ur.user_cd) as UserCount, Count(rac.authority_control_cd) AuthCount");
sqlQuery.Append(" from m_mes_role ro");
sqlQuery.Append(" left outer join m_mes_user_role ur on ur.role_cd = ro.role_cd");
sqlQuery.Append(" left outer join m_role_authority_control rac on rac.role_cd = ro.role_cd");
sqlQuery.Append(" where 1 = 1 ");
if (inVo.RoleCode != null)
{
sqlQuery.Append(" and UPPER(ro.role_cd) = UPPER(:rolecd)");
}
sqlQuery.Append(" group by ro.role_cd");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
if (inVo.RoleCode != null)
{
sqlParameter.AddParameterString("rolecd", inVo.RoleCode);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
RoleVo outVo = new RoleVo();
while (dataReader.Read())
{
outVo.UserCount = Convert.ToInt32("0" + dataReader["UserCount"]);
outVo.AuthorityCount = Convert.ToInt32("0" + dataReader["AuthCount"]);
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
RoleVo inVo = (RoleVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Insert into m_mes_role");
sqlQuery.Append(" ( ");
sqlQuery.Append(" role_cd, ");
sqlQuery.Append(" role_name, ");
sqlQuery.Append(" registration_user_cd, ");
sqlQuery.Append(" registration_date_time, ");
sqlQuery.Append(" factory_cd ");
sqlQuery.Append(" ) ");
sqlQuery.Append("VALUES ");
sqlQuery.Append(" ( ");
sqlQuery.Append(" :rolecd ,");
sqlQuery.Append(" :rolename ,");
sqlQuery.Append(" :registrationusercode ,");
sqlQuery.Append(" now() ,");
sqlQuery.Append(" :factorycode ");
sqlQuery.Append(" ); ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("rolecd", inVo.RoleCode);
sqlParameter.AddParameterString("rolename", inVo.RoleName);
sqlParameter.AddParameterString("registrationusercode", inVo.RegistrationUserCode);
//sqlParameter.AddParameterDateTime("registrationdatetime", inVo.RegistrationDateTime);
sqlParameter.AddParameterString("factorycode", inVo.FactoryCode);
RoleVo outVo = new RoleVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
/// <summary>
/// Binds tree view with user
/// </summary>
private void BindTreeView()
{
RoleVo roleInVo = new RoleVo();
if (RoleName_txt.Text != string.Empty)
{
roleInVo.RoleName = RoleName_txt.Text;
}
try
{
RoleVo roleOutVo = (RoleVo)base.InvokeCbm(new GetRoleMasterMntCbm(), roleInVo, false);
PopulateTreeView(roleOutVo.RoleListVo);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
RoleVo inVo = (RoleVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select Count(*) as RoleCount from m_mes_role ");
sqlQuery.Append(" where 1 = 1 ");
if (inVo.RoleCode != null)
{
sqlQuery.Append(" and UPPER(role_cd) = UPPER(:rolecd)");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
if (inVo.RoleCode != null)
{
sqlParameter.AddParameterString("rolecd", inVo.RoleCode);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
RoleVo outVo = new RoleVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["RoleCount"]);
}
dataReader.Close();
return(outVo);
}
override public void HandleNotification(INotification note)
{
switch (note.Name)
{
case ApplicationFacade.NEW_USER:
ClearForm();
break;
case ApplicationFacade.USER_ADDED:
RolePanel.User = note.Body as UserVo;
RoleVo roleVO = new RoleVo(RolePanel.User.Username, new ObservableCollection <RoleEnum>());
RoleProxy.AddItem(roleVO);
ClearForm();
break;
case ApplicationFacade.USER_UPDATED:
ClearForm();
break;
case ApplicationFacade.USER_DELETED:
ClearForm();
break;
case ApplicationFacade.CANCEL_SELECTED:
ClearForm();
break;
case ApplicationFacade.USER_SELECTED:
RolePanel.User = note.Body as UserVo;
RolePanel.UserRoles = RoleProxy.GetUserRoles(RolePanel.User.Username);
RolePanel.RoleCombo.SelectedItem = RoleEnum.NONE_SELECTED;
RolePanel.IsEnabled = true;
RolePanel.RemoveButton.IsEnabled = false;
RolePanel.AddButton.IsEnabled = false;
break;
}
}
/// <summary>
/// Binds tree view with role
/// </summary>
/// <param name="userList"></param>
private void PopulateTreeView(List <UserVo> userList)
{
RoleVo roleOutVo = new RoleVo();
AuthorityControlVo authorityOutVo = new AuthorityControlVo();
try
{
roleOutVo = (RoleVo)base.InvokeCbm(new GetRoleMasterMntCbm(), roleInVo, false);
AuthorityControlVo authorityInVo = new AuthorityControlVo();
authorityOutVo = (AuthorityControlVo)base.InvokeCbm(new GetAuthorityControlMasterMntCbm(), authorityInVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
Logger.Error(exception.GetMessageData());
return;
}
UserRoleDetails_tv.Nodes.Clear();
TreeNode[] headerNode = new TreeNode[userList.Count];
int i = 0;
foreach (UserVo user in userList)
{
TreeNode child = new TreeNode
{
Text = user.UserCode + ": " + user.UserName,
Tag = user.UserCode
};
headerNode[i] = child;
int childNodes = roleOutVo.RoleListVo.Count;
TreeNode[] rootNodes = new TreeNode[childNodes];
int node = 0;
//UserRoleVo userRoleInVo = new UserRoleVo();
UserRoleVo userRoleOutVo = new UserRoleVo();
try
{
userRoleOutVo = (UserRoleVo)base.InvokeCbm(new GetUserRoleMasterMntCbm(), new UserRoleVo(), false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
Logger.Error(exception.GetMessageData());
return;
}
foreach (RoleVo role in roleOutVo.RoleListVo)
{
TreeNode rootChild = new TreeNode
{
Text = role.RoleCode + ": " + role.RoleName,
Tag = role.RoleCode
};
List <UserRoleVo> userRoleList = userRoleOutVo.UserRoleListVo.Where(t => t.UserCode == child.Tag.ToString()).ToList();
foreach (UserRoleVo userRole in userRoleList)
{
if (userRole.RoleCode == rootChild.Tag.ToString())
{
rootChild.Checked = true;
}
}
rootNodes[node] = rootChild;
headerNode[i].Nodes.Add(rootNodes[node]);
RoleAuthorityControlVo roleAuthorityOutVo = new RoleAuthorityControlVo();
try
{
roleAuthorityOutVo = (RoleAuthorityControlVo)base.InvokeCbm(new GetRoleAuthorityControlMasterMntCbm(), new RoleAuthorityControlVo(), false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
Logger.Error(exception.GetMessageData());
return;
}
List <RoleAuthorityControlVo> roleAuthorityList = roleAuthorityOutVo.RoleAuthorityControlListVo.Where(t => t.RoleCode == rootChild.Tag.ToString()).ToList();
int authorityNodes = roleAuthorityList.Count;
TreeNode[] authorityRootNodes = new TreeNode[authorityNodes];
int subnode = 0;
foreach (RoleAuthorityControlVo roleAuth in roleAuthorityList)
{
AuthorityControlVo authVo = authorityOutVo.AuthorityControlListVo.Where(t => t.AuthorityControlCode == roleAuth.AuthorityControlCode).ToList().First();
TreeNode authorityChild = new TreeNode
{
Text = authVo.AuthorityControlCode + ": " + authVo.AuthorityControlName,
Tag = authVo.AuthorityControlCode
};
authorityRootNodes[subnode] = authorityChild;
rootNodes[node].Nodes.Add(authorityRootNodes[subnode]);
subnode += 1;
}
node += 1;
}
UserRoleDetails_tv.Nodes.Add(headerNode[i]);
i += 1;
}
}
public void setAwt_SceneStatus(bool boo, RoleVo vo = null)
{
}
/// <summary>
/// event to delete the selected record
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Delete_btn_Click(object sender, EventArgs e)
{
int selectedrowindex = RoleData_dgv.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = RoleData_dgv.Rows[selectedrowindex];
messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colRoleCode"].Value.ToString());
// Logger.Info(messageData);
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
// DialogResult dialogResult = MessageBox.Show("Are you sure want to delete the role = " + selectedRow.Cells["colRoleCode"].Value.ToString(), "", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.OK)
{
RoleVo inVo = new RoleVo
{
RoleCode = selectedRow.Cells["colRoleCode"].Value.ToString()
};
try
{
RoleVo checkVo = CheckRelation(inVo);
if (checkVo != null)
{
StringBuilder message = new StringBuilder();
if (checkVo.UserCount > 0)
{
message.Append(RoleRelationTables.UserRole);
}
if (checkVo.AuthorityCount > 0)
{
if (message.Length > 0)
{
message.Append(" And ");
}
message.Append(RoleRelationTables.RoleAuthorityControl);
}
if (message.Length > 0)
{
messageData = new MessageData("mmce00007", Properties.Resources.mmce00007, message.ToString());
popUpMessage.Information(messageData, Text);
return;
}
}
RoleVo outVo = (RoleVo)base.InvokeCbm(new DeleteRoleMasterMntCbm(), inVo, false);
if (outVo.AffectedCount > 0)
{
messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind(FormConditionVo());
}
else if (outVo.AffectedCount == 0)
{
messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind(FormConditionVo());
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
else if (dialogResult == DialogResult.Cancel)
{
//do something else
}
}
/// <summary>
/// add an item to the data
/// </summary>
/// <param name="item">The RoleVo item to add to the list</param>
public void AddItem(RoleVo role)
{
Roles.Add(role);
}
/// <summary>
/// update data to db
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Ok_btn_Click(object sender, EventArgs e)
{
var sch = StringCheckHelper.GetInstance();
if (CheckMandatory())
{
if (!sch.IsASCII(RoleCode_txt.Text))
{
messageData = new MessageData("mmce00003", Properties.Resources.mmce00003);
logger.Info(messageData);
popUpMessage.ConfirmationOkCancel(messageData, Text);
RoleCode_txt.Focus();
return;
}
RoleVo inVo = new RoleVo
{
RoleCode = RoleCode_txt.Text.Trim(),
RoleName = RoleName_txt.Text.Trim(),
//RegistrationDateTime = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"),
RegistrationUserCode = UserData.GetUserData().UserCode,
FactoryCode = UserData.GetUserData().FactoryCode
};
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
RoleVo checkVo = DuplicateCheck(inVo);
if (checkVo != null && checkVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, RoleCode_lbl.Text + " : " + RoleCode_txt.Text);
popUpMessage.Information(messageData, Text);
return;
}
}
try
{
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
RoleVo outVo = (RoleVo)base.InvokeCbm(new AddRoleMasterMntCbm(), inVo, false);
IntSuccess = outVo.AffectedCount;
}
else if (string.Equals(mode, CommonConstants.MODE_UPDATE))
{
RoleVo outVo = (RoleVo)base.InvokeCbm(new UpdateRoleMasterMntCbm(), inVo, false);
IntSuccess = outVo.AffectedCount;
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
if ((IntSuccess > 0) || (IntSuccess == 0))
{
this.Close();
}
}
}
