public void AddRequiredData(FarContract farContract)
{
string sql = $@"select count (1) from FarContract fc
left join
FarContractTypeClause fctc
on fctc.FarContractTypeClauseGuid = fc.FarContractTypeClauseGuid
where ContractGuid = @ContractGuid and fc.IsDeleted =0 and fctc.FarContractTypeGuid = @FarContractTypeGuid";
var result = _context.Connection.QuerySingle <int>(sql, new { ContractGuid = farContract.ContractGuid, FarContractTypeGuid = farContract.FarContractTypeGuid });
if (result == 0)
{
string sqlSoftDelete = $@"update FarContract set IsDeleted = 1
from FarContract Fc
inner join
FarContractTypeClause fctc
on fctc.FarContractTypeClauseGuid = Fc.FarContractTypeClauseGuid
and
fctc.IsRequired = 1
and Fc.ContractGuid =@ContractGuid";
_context.Connection.Execute(sqlSoftDelete, new { ContractGuid = farContract.ContractGuid });
string selectSql = $"SELECT FarContractTypeClauseGuid FROM FarContractTypeClause WHERE FarContractTypeGuid = @FarContractTypeGuid AND IsRequired = 1";
var datas = _context.Connection.Query <Guid>(selectSql, new { FarContractTypeGuid = farContract.FarContractTypeGuid });
foreach (var item in datas)
{
farContract.FarContractTypeClauseGuid = item;
var insertSql = $@"INSERT INTO FarContract
(
ContractGuid,
FarContractTypeClauseGuid,
CreatedBy,
UpdatedBy,
CreatedOn,
IsDeleted,
UpdatedOn
)
VALUES (
@ContractGuid,
@FarContractTypeClauseGuid,
@CreatedBy,
@UpdatedBy,
@CreatedOn,
@IsDeleted,
@UpdatedOn
)";
_context.Connection.Execute(insertSql, farContract);
}
}
}
public void Add(FarContract farContract)
{
string countSql = $@"SELECT COUNT(*)
FROM FarContract
WHERE ContractGuid= @contractGuid
AND FarContractTypeClauseGuid = @farContractTypeClauseGuid AND IsDeleted=0 ";
var result = _context.Connection.QueryFirstOrDefault <int>(countSql,
new
{
contractGuid = farContract.ContractGuid,
farContractTypeClauseGuid = farContract.FarContractTypeClauseGuid
});
if (result == 0)
{
var insertSql = $@"INSERT INTO FarContract
(
ContractGuid,
FarContractTypeClauseGuid,
CreatedBy,
UpdatedBy,
CreatedOn,
IsDeleted,
UpdatedOn
)
VALUES (
@ContractGuid,
@FarContractTypeClauseGuid,
@CreatedBy,
@UpdatedBy,
@CreatedOn,
@IsDeleted,
@UpdatedOn
)";
_context.Connection.Execute(insertSql, farContract);
}
}
private ActionResult Save(FarContractViewModel farContractViewModel)
{
DateTime CreatedOn = CurrentDateTimeHelper.GetCurrentDateTime();
Guid CreatedBy = UserHelper.CurrentUserGuid(HttpContext);
DateTime UpdatedOn = CurrentDateTimeHelper.GetCurrentDateTime();
Guid UpdatedBy = UserHelper.CurrentUserGuid(HttpContext);
bool IsDeleted = false;
if (farContractViewModel.Questionniare != null)
{
_contractQuestionariesService.AddQuestionaires(farContractViewModel.Questionniare, farContractViewModel.ContractGuid, CreatedOn, CreatedBy, UpdatedOn, UpdatedBy);
}
//// Soft Deletes the previous FAR CONTRACT and then adds new.
_farContractService.SoftDelete(farContractViewModel.ContractGuid);
if (farContractViewModel.SelectedValuesList != null)
{
foreach (var item in farContractViewModel.SelectedValuesList)
{
var farContract = new FarContract();
farContract.ContractGuid = farContractViewModel.ContractGuid;
farContract.FarContractTypeClauseGuid = new Guid(item);
farContract.IsDeleted = IsDeleted;
farContract.CreatedBy = CreatedBy;
farContract.CreatedOn = CreatedOn;
farContract.UpdatedBy = UpdatedBy;
farContract.UpdatedOn = UpdatedOn;
_farContractService.Add(farContract);
}
}
//// Hard deletes the soft deleted data..
_farContractService.Delete(farContractViewModel.ContractGuid);
return(Ok(new { status = ResponseStatus.success.ToString(), message = "Successfully Updated !!" }));
}
public void AddRequiredData(FarContract farContract)
{
_farContractRepository.AddRequiredData(farContract);
}
public void Add(FarContract farContract)
{
_farContractRepository.Add(farContract);
}
