public EstablishmentAccountModel SelectEstablishmentAccount(int establishmentId)
{
var establishmentAccount = _establishmentAccountRepository.SelectEstablishmentAccount(establishmentId);
if (establishmentAccount == null)
{
establishmentAccount = new EstablishmentAccountModel();
}
return(establishmentAccount);
}
public bool UpdateEstablishAccount(EstablishmentAccountModel establishmentAccount, int establishmentId)
{
establishmentAccount.EstablishmentId = establishmentId;
if (establishmentAccount != null && establishmentAccount.EstablishmentId != 0)
{
_establishmentAccountRepository.UpdateEstablishmentAccount(establishmentAccount);
}
return(true);
}
public bool UpdateEstablishmentAccount(EstablishmentAccountModel request)
{
#region .: Query :.
var query = @"
UPDATE [dbo].[EstablishmentAccount]
SET [Agency] = @Agency, [Account] = @Account
WHERE [EstablishmentId] = @EstablishmentId";
#endregion
ExecuteQuery(query, ConnectionString, request);
return(true);
}
public int InsertEstablishmentAccount(EstablishmentAccountModel request)
{
#region .: Query :.
var query = @"
INSERT INTO [dbo].[EstablishmentAccount]
([EstablishmentId], [Agency], [Account])
VALUES (@EstablishmentId, @Agency, @Account)
SELECT CAST(SCOPE_IDENTITY() AS INT) [EstablishmentAccountId]";
#endregion
var establishmentAccountId = ExecuteGetObj <int>(query, ConnectionString, request);
return(establishmentAccountId);
}
public int InsertEstablishmentAccount(EstablishmentAccountModel establishmentAccount, int establishmentId)
{
int establishmentAccountId = 0;
if (establishmentAccount != null)
{
establishmentAccount.EstablishmentId = establishmentId;
establishmentAccountId = _establishmentAccountRepository.InsertEstablishmentAccount(establishmentAccount);
}
return(establishmentAccountId);
}
