public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
UserVo inVo = (UserVo)vo;
UserFactoryVo inVo2 = new UserFactoryVo
{
UserCode = inVo.UserCode,
FactoryCd = inVo.RegistrationFactoryCode,
RegistrationUserCode = inVo.RegistrationUserCode
};
deleteUserFactoryDao.Execute(trxContext, inVo2);
return(deleteUserDao.Execute(trxContext, vo));
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
UserFactoryVo inVo = (UserFactoryVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Insert into m_user_factory");
sqlQuery.Append(" ( ");
sqlQuery.Append(" user_cd, ");
sqlQuery.Append(" factory_cd, ");
sqlQuery.Append(" display_order, ");
sqlQuery.Append(" registration_user_cd, ");
sqlQuery.Append(" registration_date_time");
sqlQuery.Append(" ) ");
sqlQuery.Append("VALUES ");
sqlQuery.Append(" ( ");
sqlQuery.Append(" :usercd ,");
sqlQuery.Append(" :factorycd ,");
sqlQuery.Append(" :displayorder,");
sqlQuery.Append(" :registrationusercode ,");
sqlQuery.Append(" now()");
sqlQuery.Append(" ); ");
int cnt = 0;
UserFactoryVo outVo = new UserFactoryVo();
foreach (UserFactoryVo userRecord in inVo.UserFactoryListVo)
{
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("usercd", inVo.UserCode);
sqlParameter.AddParameterString("factorycd", userRecord.FactoryCd);
sqlParameter.AddParameterInteger("displayorder", userRecord.DisplayOrder);
sqlParameter.AddParameterString("registrationusercode", inVo.RegistrationUserCode);
outVo.AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter);
}
outVo.AffectedCount = cnt;
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
UserFactoryVo inVo = (UserFactoryVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Delete from m_user_factory");
sqlQuery.Append(" Where user_cd = :usercd ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("usercd", inVo.UserCode);
UserFactoryVo outVo = new UserFactoryVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
UserFactoryVo inVo = (UserFactoryVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("select user_cd, factory_cd, factory_name, display_order from (");
sqlQuery.Append("select mu.user_cd, mf.factory_cd, mf.factory_name, COALESCE(uf.display_order, 99) display_order");
sqlQuery.Append(" from m_mes_user mu ");
sqlQuery.Append(" inner join m_factory mf on mf.factory_cd = mf.factory_cd");
sqlQuery.Append(" left outer join m_user_factory uf on uf.user_cd = mu.user_cd and uf.factory_cd = mf.factory_cd");
sqlQuery.Append(" where 1 = 1 ");
if (inVo.UserCode != null)
{
sqlQuery.Append(" and mu.user_cd = :usercd ");
}
if (inVo.FactoryCd != null)
{
sqlQuery.Append(" and uf.factory_cd = :factorycd ");
}
sqlQuery.Append(") d");
sqlQuery.Append(" order by d.user_cd, d.display_order");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
if (inVo.UserCode != null)
{
sqlParameter.AddParameterString("usercd", inVo.UserCode);
}
if (inVo.FactoryCd != null)
{
sqlParameter.AddParameterString("factorycd", inVo.FactoryCd);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
UserFactoryVo outVo = new UserFactoryVo();
while (dataReader.Read())
{
UserFactoryVo currOutVo = new UserFactoryVo
{
UserCode = dataReader["user_cd"].ToString(),
FactoryCd = dataReader["factory_cd"].ToString(),
FactoryName = dataReader["factory_name"].ToString(),
DisplayOrder = Convert.ToInt32(dataReader["display_order"])
};
outVo.UserFactoryListVo.Add(currOutVo);
}
dataReader.Close();
return(outVo);
}
/// <summary>
/// Updates user role
/// </summary>
private void UpdateUserFactory()
{
TreeNodeCollection nodes = UserFactoryDetails_tv.Nodes;
UserFactoryVo userFactoryInVo = new UserFactoryVo();
try
{
UserFactoryVo userFactoryCheckVo = (UserFactoryVo)base.InvokeCbm(new GetUserFactoryMasterMntCbm(), userFactoryInVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
int displayOrder = 0;
foreach (TreeNode tn in nodes)
{
if (tn.ToolTipText == "Changed")
{
string userCd = tn.Tag.ToString();
userFactoryInVo.UserCode = userCd;
userFactoryInVo.RegistrationUserCode = UserData.GetUserData().UserCode;
foreach (TreeNode child in tn.Nodes)
{
if (child.Checked)
{
displayOrder = displayOrder + 1;
UserFactoryVo userFactoryListVo = new UserFactoryVo
{
UserCode = userCd,
FactoryCd = child.Tag.ToString(),
DisplayOrder = displayOrder
};
userFactoryInVo.UserFactoryListVo.Add(userFactoryListVo);
}
}
try
{
UserFactoryVo userFactoryOutVo = (UserFactoryVo)base.InvokeCbm(new UpdateUserFactoryMasterMntCbm(), userFactoryInVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
}
}
messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
/// <summary>
/// Binds tree view with role
/// </summary>
/// <param name="userList"></param>
private void PopulateTreeView(List <UserVo> userList)
{
UserFactoryDetails_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 node = 0;
UserFactoryVo userFactoryInVo = new UserFactoryVo
{
UserCode = user.UserCode
};
UserFactoryVo userFactoryOutVo;
try
{
userFactoryOutVo = (UserFactoryVo)base.InvokeCbm(new GetUserFactoryMasterMntCbm(), userFactoryInVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
int childNodes = userFactoryOutVo.UserFactoryListVo.Count;
TreeNode[] rootNodes = new TreeNode[childNodes];
List <UserFactoryVo> userFactoryList = userFactoryOutVo.UserFactoryListVo;
foreach (UserFactoryVo userFactory in userFactoryList)
{
TreeNode rootChild = new TreeNode
{
Text = userFactory.FactoryName,
Tag = userFactory.FactoryCd
};
if (userFactory.DisplayOrder < 99)
{
rootChild.Checked = true;
}
rootNodes[node] = rootChild;
headerNode[i].Nodes.Add(rootNodes[node]);
node += 1;
}
UserFactoryDetails_tv.Nodes.Add(headerNode[i]);
i += 1;
}
}
