public UpdateSubcontractProcessMasterQM UpdateSubcontractProcessMaster(UpdateSubcontractProcessMasterCM updateSubcontractProcessMasterCM)
{
using (var connection = new DbConnectionProvider().CreateConnection())
{
connection.Open();
var command = new SubcontractProcessMasterUpdateCommand {
Connection = connection
};
command.Execute(updateSubcontractProcessMasterCM);
}
return(new UpdateSubcontractProcessMasterQM());
}
public UpdateSubcontractProcessMasterResponseDto UpdateSubcontractProcessMaster(UpdateSubcontractProcessMasterRequestDto updateSubcontractProcessMasterRequestDto)
{
var cModel = new UpdateSubcontractProcessMasterCM
{
ProcessCode = updateSubcontractProcessMasterRequestDto.ProcessCode,
ProcessDescription = updateSubcontractProcessMasterRequestDto.ProcessDescription,
UpdatedBy = new Guid("783F190B-9B66-42AC-920B-E938732C1C01"), //Later needs to be remove,
UpdatedDateTime = System.DateTime.UtcNow,
};
var response = subcontractProcessMasterRepository.UpdateSubcontractProcessMaster(cModel);
return(new UpdateSubcontractProcessMasterResponseDto());
}
public void Execute(UpdateSubcontractProcessMasterCM model)
{
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspUpdateSubContractProcessMaster]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@ProcessDescription", SsDbType.VarChar, ParameterDirection.Input, model.ProcessDescription));
sqlCommand.Parameters.Add(AddParameter("@UpdatedBy", SsDbType.UniqueIdentifier, ParameterDirection.Input, new Guid()));
sqlCommand.Parameters.Add(AddParameter("@UpdatedDateTime", SsDbType.DateTime, ParameterDirection.Input, DateTime.UtcNow));
sqlCommand.Parameters.Add(AddParameter("@ProcessCode", SsDbType.Decimal, ParameterDirection.Input, model.ProcessCode));
sqlCommand.ExecuteNonQuery();
}
}
