private static void SetErpPmUser(Project proj, SqlConnection sqlc, IUserService _userService, IMfUserGroupService _mfusergroupService, Vault ovault)
{
try
{
var select1 = string.Format("select userid from erppm ");
var sqlcommand1 = new SqlCommand(select1, sqlc);
var rds1 = new SqlDataAdapter(sqlcommand1);
var dt1 = new DataTable();
rds1.Fill(dt1);
var userid = 1;
if (dt1.Rows.Count > 0)
{
foreach (DataRow row in dt1.Rows)
{
foreach (DataColumn column in dt1.Columns)
{
userid = int.Parse(row[column].ToString());
break;
}
var username = _userService.GetUserById(userid).UserName;
var userId = _mfusergroupService.GetUserId(ovault, username);
var ugid =
ovault.GetMetadataStructureItemIDByAlias(
MFMetadataStructureItem.MFMetadataStructureItemUserGroup,
MfilesAliasConfig.UgErpPrincipal);
_mfusergroupService.AddUserToGroup(ovault, userId, ugid);
break;
}
}
}
catch (Exception ex)
{
// Log.Info("SetErpPmUser error:" + ex.Message);
}
}
private void SetVicePresidentByCompany(Project proj, SqlConnection sqlc, IUserService _userService, IMfUserGroupService _mfusergroupService, long companyid)
{
try
{
var select1 = string.Format("select userid,groupid from usergroup where id = '{0}' ", companyid);
var sqlcommand1 = new SqlCommand(select1, sqlc);
var rds1 = new SqlDataAdapter(sqlcommand1);
var dt1 = new DataTable();
rds1.Fill(dt1);
if (dt1.Rows.Count > 0)
{
foreach (DataRow row in dt1.Rows)
{
var index = 0;
var userg = new UserGroupDb();
foreach (DataColumn column in dt1.Columns)
{
switch (index)
{
case 0:
userg.UserId = int.Parse(row[column].ToString());
break;
case 1:
userg.GroupId = int.Parse(row[column].ToString());
break;
}
index++;
}
var username = _userService.GetUserById(userg.UserId).UserName;
string mfigroupid = GetMfGroupName(userg.GroupId);
_mfusergroupService.AddUserToGroup(proj.Vault, username, mfigroupid);
}
}
}
catch (Exception ex)
{
// Log.Info(companyid + "SetVicePresidentByCompany error:" + ex.Message);
}
}
