public void DeleteRefund() { string command = "SP_Delete_Refund_per_Account(@AccountID:Int,@ChannelID:Int,@Month:datetime)"; 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 (int groupId in this.AssignedToGroups.Keys) { SqlCommand sqlCommand = DataManager.CreateCommand(@"INSERT INTO User_GUI_UserGroupUser (GroupID,UserID) VALUES (@GroupID:Int,@UserID:Int)" ); sqlCommand.Parameters["@GroupID"].Value = 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 Facebook_Campaign_StatusByTime 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(); }