public static User GetUserByID(int id)
{
User user = null;
ThingReader <User> thingReader;
Func <FieldInfo, IDataRecord, object> customApply = CustomApply;
using (SqlConnection conn = new SqlConnection(AppSettings.GetConnectionString("Easynet.Edge.Core.Data.DataManager.Connection", "String")))
{
SqlCommand sqlCommand = DataManager.CreateCommand("User_GetByID(@userID:int)", CommandType.StoredProcedure);
sqlCommand.Connection = conn;
conn.Open();
sqlCommand.Parameters["@userID"].Value = id;
thingReader = new ThingReader <User>(sqlCommand.ExecuteReader(), CustomApply);
if (thingReader.Read())
{
user = (User)thingReader.Current;
}
}
if (user != null)
{
user = MapperUtility.ExpandObject <User>(user, customApply);
}
return(user);
//System.Data.SqlClient.SqlCommand cmd = Easynet.Edge.Core.Data.DataManager.CreateCommand("User_GetAllPermissions(@userID:int)");
}
public static List <User> GetAllUsers()
{
List <User> users = new List <User>();
ThingReader <User> thingReader;
Func <FieldInfo, IDataRecord, object> customApply = CustomApply;
using (SqlConnection conn = new SqlConnection(AppSettings.GetConnectionString("Easynet.Edge.Core.Data.DataManager.Connection", "String")))
{
SqlCommand sqlCommand = DataManager.CreateCommand("SELECT UserID,IsActive,Name,Email FROM User_GUI_User ORDER BY Name");
sqlCommand.Connection = conn;
conn.Open();
thingReader = new ThingReader <User>(sqlCommand.ExecuteReader(), CustomApply);
while (thingReader.Read())
{
users.Add((User)thingReader.Current);
}
}
if (users != null && users.Count > 0)
{
for (int i = 0; i < users.Count; i++)
{
users[i] = MapperUtility.ExpandObject <User>(users[i], customApply);
}
}
return(users.OrderBy(N => N.Name).ToList());
}
public static List <Group> GetAllGroups()
{
List <Group> groups = new List <Group>();
ThingReader <Group> thingReader;
Func <FieldInfo, IDataRecord, object> customApply = CustomApply;
using (SqlConnection conn = new SqlConnection(AppSettings.GetConnectionString("Easynet.Edge.Core.Data.DataManager.Connection", "String")))
{
conn.Open();
SqlCommand sqlCommand = DataManager.CreateCommand("SELECT GroupID,IsActive,Name,AccountAdmin FROM User_GUI_UserGroup ORDER BY Name");
sqlCommand.Connection = conn;
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
thingReader = new ThingReader <Group>(sqlCommand.ExecuteReader(), CustomApply);
while (thingReader.Read())
{
groups.Add((Group)thingReader.Current);
}
}
if (groups != null && groups.Count > 0)
{
for (int i = 0; i < groups.Count; i++)
{
groups[i] = MapperUtility.ExpandObject <Group>(groups[i], customApply);
}
}
return(groups);
}
public static Group GetGroupByID(int groupID)
{
Group group = null;
ThingReader <Group> thingReader;
Func <FieldInfo, IDataRecord, object> customApply = CustomApply;
using (SqlConnection conn = new SqlConnection(AppSettings.GetConnectionString("Easynet.Edge.Core.Data.DataManager.Connection", "String")))
{
SqlCommand sqlCommand = DataManager.CreateCommand(@"SELECT GroupID,
Name,
IsActive,
AccountAdmin
FROM User_GUI_UserGroup
WHERE GroupID=@GroupID:Int" );
sqlCommand.Parameters["@GroupID"].Value = groupID;
sqlCommand.Connection = conn;
conn.Open();
thingReader = new ThingReader <Group>(sqlCommand.ExecuteReader(), CustomApply);
if (thingReader.Read())
{
group = (Group)thingReader.Current;
}
}
if (group != null)
{
group = MapperUtility.ExpandObject <Group>(group, customApply);
}
return(group);
}
public static List <Group> GetAllGroups()
{
List <Group> groups = new List <Group>();
ThingReader <Group> thingReader;
Func <FieldInfo, IDataRecord, object> customApply = CustomApply;
using (DataManager.Current.OpenConnection())
{
SqlCommand sqlCommand = DataManager.CreateCommand("SELECT GroupID,Name,AccountAdmin FROM User_GUI_UserGroup ORDER BY GroupID");
thingReader = new ThingReader <Group>(sqlCommand.ExecuteReader(), CustomApply);
while (thingReader.Read())
{
groups.Add((Group)thingReader.Current);
}
}
if (groups != null && groups.Count > 0)
{
for (int i = 0; i < groups.Count; i++)
{
groups[i] = MapperUtility.ExpandObject <Group>(groups[i], customApply);
}
}
return(groups);
}
public static List <User> GetAllUsers()
{
List <User> users = new List <User>();
ThingReader <User> thingReader;
Func <FieldInfo, IDataRecord, object> customApply = CustomApply;
using (DataManager.Current.OpenConnection())
{
SqlCommand sqlCommand = DataManager.CreateCommand("SELECT UserID,Name,AccountAdmin,Email FROM User_GUI_User ORDER BY UserID");
thingReader = new ThingReader <User>(sqlCommand.ExecuteReader(), CustomApply);
while (thingReader.Read())
{
users.Add((User)thingReader.Current);
}
}
if (users != null && users.Count > 0)
{
for (int i = 0; i < users.Count; i++)
{
users[i] = MapperUtility.ExpandObject <User>(users[i], customApply);
}
}
return(users);
}
public void DeleteRefund()
{
string command = "SP_Delete_Refund_per_Account(@AccountID:Int,@ChannelID:Int,@Month:datetime)";
SqlConnection sqlConnection = new SqlConnection(AppSettings.Get(string.Empty, "DWH.ConnectionString").ToString());
sqlConnection.Open();
MapperUtility.SaveOrRemoveSimpleObject <Refund>(command, System.Data.CommandType.StoredProcedure, SqlOperation.Insert, this, sqlConnection, null);
}
public void AddRefund()
{
string command = "SP_Add_Refund_per_Account(@AccountID:Int,@ChannelID:Int,@Month:datetime, @RefundAmount:decimal)";
SqlConnection sqlConnection = new SqlConnection(AppSettings.GetAbsolute("DWH.ConnectionString").ToString());
sqlConnection.Open();
MapperUtility.SaveOrRemoveSimpleObject <Refund>(command, System.Data.CommandType.StoredProcedure, SqlOperation.Insert, this, sqlConnection, null);
}
public int UserOperations(SqlOperation sqlOperation)
{
SqlTransaction sqlTransaction = null;
int returnValue = -1;
try
{
//Insert/Update/Remove user (also this clean all permissions and assigned groups)
string command = @"User_Operations(@Action:Int,@UserID:Int,@Name:NvarChar,@IsActive:bit,@AccountAdmin:bit,@Email:NvarChar,@Password:NvarChar)";
SqlConnection sqlConnection = new SqlConnection(DataManager.ConnectionString);
sqlConnection.Open();
sqlTransaction = sqlConnection.BeginTransaction("SaveUser");
returnValue = this.UserID = Convert.ToInt32(MapperUtility.SaveOrRemoveSimpleObject <User>(command, CommandType.StoredProcedure, sqlOperation, this, sqlConnection, sqlTransaction));
//insert the new permission
foreach (KeyValuePair <int, List <AssignedPermission> > assignedPermissionPerAccount in this.AssignedPermissions)
{
foreach (AssignedPermission assignedPermission in assignedPermissionPerAccount.Value)
{
SqlCommand sqlCommand = DataManager.CreateCommand("Permissions_Operations(@AccountID:Int,@TargetID:Int,@TargetIsGroup:Bit,@PermissionType:NvarChar,@Value:Bit)", CommandType.StoredProcedure);
sqlCommand.Connection = sqlConnection;
sqlCommand.Transaction = sqlTransaction;
sqlCommand.Parameters["@AccountID"].Value = assignedPermissionPerAccount.Key;
sqlCommand.Parameters["@TargetID"].Value = this.UserID;
sqlCommand.Parameters["@TargetIsGroup"].Value = 0;
sqlCommand.Parameters["@PermissionType"].Value = assignedPermission.PermissionType;
sqlCommand.Parameters["@Value"].Value = assignedPermission.Value;
sqlCommand.ExecuteNonQuery();
}
}
foreach (Group group in this.AssignedToGroups)
{
SqlCommand sqlCommand = DataManager.CreateCommand(@"INSERT INTO User_GUI_UserGroupUser
(GroupID,UserID)
VALUES
(@GroupID:Int,@UserID:Int)" );
sqlCommand.Parameters["@GroupID"].Value = group.GroupID;
sqlCommand.Parameters["@UserID"].Value = this.UserID;
sqlCommand.Connection = sqlConnection;
sqlCommand.Transaction = sqlTransaction;
sqlCommand.ExecuteNonQuery();
}
sqlTransaction.Commit();
}
catch (Exception ex)
{
if (sqlTransaction != null)
{
sqlTransaction.Rollback();
}
throw ex;
}
return(returnValue);
}
public static void Update(List <CampaignStatusSchedule> campaignStatusSchedules)
{
string command;
SqlTransaction sqlTransaction = null;
SqlConnection sqlConnection = new SqlConnection(DataManager.ConnectionString);
sqlConnection.Open();
sqlTransaction = sqlConnection.BeginTransaction("Schedule");
command = "DELETE FROM Campaigns_Scheduling WHERE Campaign_GK=@Campaign_GK:int";
MapperUtility.SaveOrRemoveSimpleObject <CampaignStatusSchedule>(command, System.Data.CommandType.Text, SqlOperation.Delete, campaignStatusSchedules[0], sqlConnection, sqlTransaction);
command = @"CampaignStatusSchedule_Insert(@Action:Int,@Account_ID:int,
@Campaign_GK:int,
@Channel_ID:int,
@Day:int,
@Hour00:int,
@Hour01:int,
@Hour02:int,
@Hour03:int,
@Hour04:int,
@Hour05:int,
@Hour06:int,
@Hour07:int,
@Hour08:int,
@Hour09:int,
@Hour10:int,
@Hour11:int,
@Hour12:int,
@Hour13:int,
@Hour14:int,
@Hour15:int,
@Hour16:int,
@Hour17:int,
@Hour18:int,
@Hour19:int,
@Hour20:int,
@Hour21:int,
@Hour22:int,
@Hour23:int)";
foreach (CampaignStatusSchedule campaignStatusSchedule in campaignStatusSchedules)
{
MapperUtility.SaveOrRemoveSimpleObject <CampaignStatusSchedule>(command, System.Data.CommandType.StoredProcedure, SqlOperation.Update, campaignStatusSchedule, sqlConnection, sqlTransaction);
}
command = @"UPDATE UserProcess_GUI_PaidCampaign
SET ScheduleEnabled=@ScheduleEnabled:bit
WHERE Campaign_GK= @Campaign_GK:int" ;
;
MapperUtility.SaveOrRemoveSimpleObject <CampaignStatusSchedule>(command, System.Data.CommandType.Text, SqlOperation.Update, campaignStatusSchedules[0], sqlConnection, sqlTransaction);
sqlTransaction.Commit();
}
public bool Read()
{
bool hasData = _reader.Read();
if (hasData)
{
_current = new ThingT();
_current = MapperUtility.CreateMainObject <ThingT>(_reader, _onApplyValue);
}
return(hasData);
}