public int CheckDuplicate(FarContractType farContractType)
{
string selectQuery = $@"SELECT count(1) FROM FarContractType where Code = @Code and FarContractTypeGuid != @FarContractTypeGuid and IsDeleted = 0";
var data = _context.Connection.QueryFirstOrDefault <int>(selectQuery, new { FarContractTypeGuid = farContractType.FarContractTypeGuid, Code = farContractType.Code });
return(data);
}
public void Update(FarContractType farContractType)
{
string updateQuery = $@"Update FarContractType set
Code = @Code ,
UpdatedBy = @UpdatedBy ,
Title = @Title
where FarContractTypeGuid = @FarContractTypeGuid ";
_context.Connection.Execute(updateQuery, farContractType);
}
public void Add(FarContractType farContractType)
{
string insertQuery = $@"INSERT INTO [dbo].[FarContractType]
(
FarContractTypeGuid ,
Code ,
IsDeleted ,
UpdatedBy ,
Title
)
VALUES (
@FarContractTypeGuid ,
@Code ,
@IsDeleted ,
@UpdatedBy ,
@Title
)";
_context.Connection.Execute(insertQuery, farContractType);
}
public void Update(FarContractType farContractType)
{
_farContractTypeRepository.Update(farContractType);
}
public int CheckDuplicate(FarContractType farContractType)
{
return(_farContractTypeRepository.CheckDuplicate(farContractType));
}
public void Add(FarContractType farContractType)
{
_farContractTypeRepository.Add(farContractType);
}
