public int?AddGroup(Group group)
{
try
{
var values = new Dictionary <string, object>
{
{ GlobalAppSettings.DbColumns.DB_Group.Name, group.GroupName },
{ GlobalAppSettings.DbColumns.DB_Group.Description, group.GroupDescription },
{ GlobalAppSettings.DbColumns.DB_Group.Color, group.GroupColor },
{ GlobalAppSettings.DbColumns.DB_Group.IsActive, true },
{
GlobalAppSettings.DbColumns.DB_Group.ModifiedDate,
DateTime.UtcNow.ToString(GlobalAppSettings.GetDateTimeFormat())
}
};
var output = new List <string>
{
GlobalAppSettings.DbColumns.DB_Group.GroupId
};
var result = _dataProvider.ExecuteScalarQuery(_queryBuilder.AddToTable(
GlobalAppSettings.DbColumns.DB_Group.DB_TableName,
values, output));
if (result.Status)
{
return(Convert.ToInt32(result.ReturnValue));
}
return(null);
}
catch (Exception e)
{
LogExtension.LogError("Error while adding group", e,
MethodBase.GetCurrentMethod(), " GroupName - " + group.GroupName + " GroupDescription - " + group.GroupDescription + " GroupColor - " + group.GroupColor);
return(null);
}
}
public bool AddUserInGroup(int userId, int groupId)
{
try
{
var values = new Dictionary <string, object>
{
{ GlobalAppSettings.DbColumns.DB_UserGroup.GroupId, groupId },
{ GlobalAppSettings.DbColumns.DB_UserGroup.UserId, userId },
{ GlobalAppSettings.DbColumns.DB_UserGroup.IsActive, true },
{
GlobalAppSettings.DbColumns.DB_UserGroup.ModifiedDate,
DateTime.UtcNow.ToString(GlobalAppSettings.GetDateTimeFormat())
}
};
var result = _dataProvider.ExecuteNonQuery(
_queryBuilder.AddToTable(GlobalAppSettings.DbColumns.DB_UserGroup.DB_TableName, values));
return(result.Status);
}
catch (Exception e)
{
LogExtension.LogError("Error while add user in group", e,
MethodBase.GetCurrentMethod(), " UserId - " + userId + " GroupId - " + groupId);
return(false);
}
}
