78 lines
3.2 KiB
C#
78 lines
3.2 KiB
C#
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Linq;
|
|
using Kreta.DataAccess.Interfaces;
|
|
using Kreta.DataAccessManual.Interfaces;
|
|
using Kreta.DataAccessManual.Util;
|
|
using Kreta.Enums;
|
|
using Kreta.Framework;
|
|
using Kreta.Framework.Util;
|
|
using SDA.Kreta.Entities;
|
|
|
|
namespace Kreta.DataAccessManual
|
|
{
|
|
internal class RendszerBeallitasDAL : DataAccessBase, IRendszerBeallitasDAL
|
|
{
|
|
public RendszerBeallitasDAL(DalHandler handler, GridParameters parameters) : base(handler, parameters)
|
|
{ }
|
|
|
|
public RendszerBeallitasDAL(DalHandler handler) : base(handler)
|
|
{ }
|
|
|
|
public IRendszerBeallitas Get(RendszerBeallitasTipusEnum beallitasTipus, int tanevId)
|
|
{
|
|
return RendszerBeallitas.LoadWithFilter(string.Format(" and C_BEALLITASTIPUS = {0} AND C_TANEVID = {1}", (int)beallitasTipus, tanevId)).SingleOrDefault();
|
|
}
|
|
|
|
public void FullUpdate(IRendszerBeallitas dto)
|
|
{
|
|
var entity = dto as RendszerBeallitas;
|
|
entity.FullUpdate();
|
|
FollowUp(entity);
|
|
DalHelper.Commit();
|
|
}
|
|
|
|
public void ResetSystemSettings(int? intezmenyID, int? tanevID, List<int> exceptSystemSettings)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = new SDA.DataProvider.SDACommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.CommandType = CommandType.Text;
|
|
|
|
command.CommandText = "UPDATE T_RENDSZERBEALLITAS_OSSZES SET C_ERTEK = C_ALAPERTEK WHERE C_INTEZMENYID = :pIntezmenyID AND C_TANEVID = :pTanevID";
|
|
|
|
command.Parameters.Add("pIntezmenyID", intezmenyID ?? -1);
|
|
command.Parameters.Add("pTanevID", tanevID ?? -1);
|
|
|
|
if (exceptSystemSettings != null && exceptSystemSettings.Count > 0)
|
|
{
|
|
command.CommandText += " AND C_BEALLITASTIPUS NOT IN (:pExceptSystemSettings)";
|
|
command.Parameters.Add("pExceptSystemSettings", string.Join(",", exceptSystemSettings.Select(x => x.ToString()).ToArray()));
|
|
}
|
|
|
|
var result = command.ExecuteNonQuery();
|
|
this.DalHelper.Commit();
|
|
}
|
|
}
|
|
public void FollowupRendszerBeallitas(int intezmenyID, int tanevID, int kovetkezoTanevID, int beallitasID)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = new SDA.DataProvider.SDACommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
|
|
command.CommandType = CommandType.StoredProcedure;
|
|
command.CommandText = "uspFollowUpRendszerBeallitas";
|
|
|
|
command.Parameters.Add("intezmenyId", intezmenyID);
|
|
command.Parameters.Add("aktTanevId", tanevID);
|
|
command.Parameters.Add("kovetkezoTanevId", kovetkezoTanevID);
|
|
command.Parameters.Add("beallitasId", beallitasID);
|
|
|
|
command.ExecuteNonQuery();
|
|
}
|
|
DalHelper.Commit();
|
|
}
|
|
}
|
|
}
|